Report Item in C#

Creator Quick Response Code in C# Report Item

Product Information & Inventory Status Normal, Arial, 10pt, Bold ="Page :" & Globals!PageNumber & " of " & Globals!TotalPages Right Click on the Product Number to check the Inventory Status Italic, Arial, 10pt, Normal 2pt

Designing the Body Section We ll make use of a table report item in this section to list product information. Let s start by dragging Report Items Table from the toolbox and dropping it inside the body section in the report designer. As usual, a new table item named table1 is part of the report now, and we have the three columns added for us. However, we need one more column, so please add one to the right side. Make sure your report design surface looks similar to the one shown in Figure 5-43.

Figure 5-43. The report design surface after adding the table item As usual, table1 needs to be mapped to our data tables; therefore, select Data Source dsProductInventory ProductNumber and drag and drop it inside the first cell of the table item s detail section (TableRow2). Repeat this task for ProductName, CategoryName, and ListPrice. After mapping the data, make sure to apply all the properties settings of table1 according to the settings mentioned in Table 5-12. If you notice in the report output, the product number appears as an underlined link. This is achieved by setting TextDecoration property of the text box to Underline. Table 5-12. Table Item Properties for the Body Section

TableRow1 TableRow1 TableRow1 Column1 TableRow1 Column2 TableRow1 Column3 TableRow1 Column4 TableRow1 Column4 TableRow2 Column1

Solid Italic, Arial, 10pt, Bold Product Number Product Name Category List Price Right =Fields!ProductNumber.Value

TableRow2 Column1 TableRow2 Column2 TableRow2 Column3 TableRow2 Column4 TableRow2 Column4

Our report design is ready now, so please make sure your final report design looks similar to Figure 5-44.

Figure 5-44. Final look of the report design All right, our design is ready now, but how do we get the drill-through feature working Well, it is easy. Recall that a user will click the product number to launch our Inventory Status report. To make this possible, we need to pass the product number from our parent report and provide instructions for jumping to the Inventory Status report. To set up the drill-through feature to accomplish that, use the following steps (see Figure 5-45): 1. Right-click the Product Number cell (TableRow2 Column1) to access the Textbox Properties dialog box. 2. From the Navigation tab, type or select rptInventoryStatus from the Jump to report drop-down menu. 3. Click the Parameters button, and set the following values (see Figure 5-46): Parameter Name: parProductNumber Parameter Value: =Fields!ProductNumber.Value 4. Click the OK button to complete the process.

Figure 5-46. Setting the drill-through parameter values We have reached to the last step to complete our report before we move on to writing the C# code. Recall that we need to provide the on-demand hide feature for the price list column. For this, we need to add a parameter to our report. We will use this parameter to get values from the GUI client, and based on the value, we will either hide or show the price list column. Just like we added the parameter in the previous section for the inventory status report, let s add a parameter to this report now; use the following steps to add a report parameter (see Figure 5-40):

1. Right-click the report designer s gray open area, and select Report Parameters. 2. Click the Add button inside the Report Parameters dialog box. 3. Name the parameter parHidePriceList; for the Prompt, type Hide Product List Y/N. 4. Click the OK button to complete the process. This is what we needed as the design for this report. Let s move on to writing some cool C# code for dynamic communication between the client and reports and bring life to our drillthrough report.