Organizing Data in Reports in .NET

Encoding QR in .NET Organizing Data in Reports

Right-click anywhere inside the list border, click Properties, click the Sorting tab, click =Fields!Category.Value in the Expression list box, and then click the OK button. The rows in this list will sort alphabetically by Category. At this point, however, a report preview will not render the list because fields have not yet been added to the list.

Fields in a freestanding textbox can be used anywhere in a list. Just drag the field from the Fields window and position the textbox in the desired position. When you add a numeric field to a list that has grouping applied, the Sum function is automatically included in the field expression. In this procedure, you add Category to the list to serve as a label.

In the Fields window, click Category, drag it to the top left corner of the list, and then drag the right side of the new textbox until it is approximately 2 inches wide. The list in the design grid looks like this:

Click the Bold button on the Report Formatting toolbar. A basic list data region is created that includes a label to display the current Category when the list repeats the group. Now you re ready to move the chart and matrix into the list.

6

To overcome the limitation that a list can have only one grouping level, you can nest a second list inside the first list. Nested lists increase your flexibility by simulating the effect of grouping. You can also nest other data regions inside a list, thereby enabling a variety of report structures that are limited only by your imagination. When nesting data regions in a list, all data regions must use the same dataset. In this procedure, you nest a chart and a matrix inside the list.

Click the chart, and then drag the chart into the list just below the Category textbox so that the list data region looks like this:

Preview the report. The top of the report should have four separate charts, one for each category. The list is repeating the textbox and the chart for each member of the Category group. The matrix appears below the list just one time, because it is not yet part of the list.

Note If the chart is not repeating, the chart might not be properly positioned within the list. Try moving the chart so that its boundaries are clearly within the boundaries of the list.

Click the Layout tab, select the matrix, and then drag the matrix into the list just below the chart. Now the list should completely surround the chart and matrix. Save and preview the report. A portion of the first Category of the list is shown here:

6 7 8

Now the scope of each matrix is limited to the Category group, which makes the subtotal for SubCategory redundant. Notice that the bottom two rows of the matrix are identical except for the difference in styles. You can edit the matrix to remove one of the subtotals to fix this duplication. Click the Layout tab, right-click the SubCategory Total cell, and then click Subtotal. The Subtotal cell disappears from the matrix. Drag the lower edge of the list up to place it just below the lower edge of the matrix to shrink the space between the repeating regions. Save the report, and preview the report to confirm there is now only one subtotal row. Close the solution.

Organizing Data in Reports To Add a data region Do this Open the Toolbox window, click the desired data region, point to the target destination in the report body, and then click to place the data region.

Add a row group or column Select a field in the Fields window and drag to the appligroup to a matrix cable area, marked Rows or Columns, in the matrix. Add a static row or column Right-click a textbox in the matrix, and click one of the to a matrix following: Add Row or Add Column. Add subtotals to a matrix Click the group cell in a row or column, and then click Subtotal. Format the subtotal value by clicking the green triangle in the new Total cell for the group.