Task 7: Display aggregate information
Display the number of customers in each group
Figure 7-10 shows the complete definition for the aggregation element.Figure 7-10 Aggregation Builder displaying values for getting the count of customers in each credit limit group
4 Choose OK. In the report design, shown in Figure 7-11, the aggregation element displays the sigma symbol followed by the column binding name.Figure 7-11 Report design displaying the aggregation element
4 Preview the report. The report displays the number of customers at the end of each group. Figure 7-12 shows the number of customers, 37, for the first credit limit group.Figure 7-12 Report preview showing a count for each groupFigure 7-13 Text specified for the text element
8 Scroll to the bottom of the first credit limit group. The report should look like the one shown in Figure 7-14. The group footer displays the following information:Display the total number of customers in the report
In the previous procedure, you added aggregate data by inserting the aggregation element from the palette. This time, you add aggregate data by creating a column binding through the table’s Binding page.
2 In Property Editor, choose the Binding tab. The Binding page, as shown in Figure 7-15, displays all the column bindings used by elements in the table.Figure 7-15 Column bindings displayed
3 In Aggregate On, select Table. This value indicates that the COUNT function returns the number of rows in the table. Figure 7-16 shows the complete definition for the aggregation element.
6 Right-click the guide cell on the left of the first row, Table - Header, then choose Insert→Row→Above. A new table header row appears above the row that displays the column headings. The new row appears in color because it inherits the properties of the row below it.
7 Figure 7-17 The expression builder displaying the expression that refers to the TOTAL_CUSTOMERS column binding
![]()
Figure 7-18 Column binding defined
5
10 Preview the report. The report displays the number of customers at the beginning of the table, as shown in Figure 7-20. The text is centered within the column. You re-format this text later.
(c) Copyright Actuate Corporation 2013 |