asp.net qr code s REPORTING WITH ASP.NET WEB FORMS in Visual C#.NET

Drawer QR Code in Visual C#.NET s REPORTING WITH ASP.NET WEB FORMS

Figure 5-29. Setting up the chart s 3-D visual effect After changing the position of the legend and introducing the 3-D effect, the chart gets a makeover and looks cool. As you make these alterations, you ll notice that the chart figure on the report design surface reflects your changes. Please make sure your report design looks similar to the one shown in Figure 5-30.

The last step before we can see our report in action here is using the ObjectDataSource class to bind the NetIncome collection object to the ReportViewer. The good news is that it is done transparently for us all we need to do is tell the report name to the ReportViewer. This process automatically creates an instance of ObjectDataSource and gets our project ready for build. Make sure the Default.aspx page is open in design view. Select the ReportViewer by clicking it once. As soon as you click it, you will see a small arrow-like icon in the right-most corner. Click the icon, and select our report, rptNetIncomeChart.rpt. This action will do the job of binding our object collection with the help of ObjectDataSource, and we are good to go to see the report in action. Please see Figure 5-31 for an illustration of the steps.

All the code is taken care of for us by the VS IDE in this report. The only code we needed was to add two classes, which we have already done.

The data binding in this report is different compared with other reports we have done so far. It uses ObjectDataSource as the data provider and collection objects as the data source. Let s build the project; you can click the small, green play button in the main toolbox or press F5 on the keyboard to start the application in run-time mode. If all goes well, you should see page in the default browser with a nice column chart. The output should match Figure 5-24. Let s move on to another reporting project filled with challenges. This time, I ll show you how to use the drill-through feature of RS. This feature is often used to create a report that uses data from two tables with a master/details relationship. You ll also see how to provide user input to the report by passing in values from the GUI.

Assume you re working for AdventureWorks Incorporated as a developer; you ve been asked to develop a Product Information and Inventory Status report. This report should gather data from two tables, which have a master/details relationship. Initially, the report will only display the product information. However, it should allow the users to click the product number to probe the inventory status. The UI on the web page should allow users to hide the price list information, if they choose not to see it on the report. Further, the report should meet all the characteristics described in Table 5-9, and the report output should match Figure 5-32. Table 5-9. Report Characteristics

Product Information & Inventory Status (Header Left) Page: n/n (Header Right) Click the Product Number to check the Inventory Status (Header Left) ProductDrilldown, ProductLocation ProductDrilldown: ProductNumber, ProductName, CategoryName and ListPrice InventoryStatus: ProductNumber, LocationName, Shelf, Bin and Quantity Letter Portrait rptInventoryStatus

Figure 5-33. Drill-through information for the selected product number The Product Information and Inventory Status report is a two-in-one report. Initially, the report will list the brief production information with the product list price. However, inventory status details can be viewed for any given product by clicking the product number. Multitask reports like this are used by various departments in a company. Folks who just want to have a quick look at the product list can have what they want. A detailed inventory status with storage location information is helpful for others who use the information to carry on further business processes, for example, when the year-end physical count of inventory takes place for auditing purposes.