1. Add a new group to the table with the Orders.
2. Use the following information:
Name: grpOrderInfo
Group On: ORDERNUMBER
Chapter 5
[ 99 ]
3. Under the Outline view, select Body\Table (the one with Orders, not the
tblEmployeePayments)\Groups\Table Groups\Header\Row. Delete
the Row.
4. In the Layout Editor, select the Order Number column. In the General Tab,
click on the Suppress Duplicates checkbox.
5. Do the same thing for the Customer Number column.
6. Click Preview.
Now, when we click on Preview, we can see that the orders are all grouped by
the Order Number, and instead of repeatedly displaying the Order Number and
Customer Number for each line as in the previous previews, it will now only
display it once.
Working with Data
[ 100 ]
Lists
Lists work in a similar manner to tables, except that they do not have the ability
to have multiple columns. This is useful for single column tables or when using
one Data Set to drive the results of another during render time or to create lists of
tables based on a single value. Lists are created the same way as Tables are created
manually, and only support a single column.
Aggregation
Often, when working with groups of data, it is desirable to perform aggregations
on one of the values. For example, if you have a report listing employees' sales for
a year, you may want to create a sub-total for each month and a grand total for the
year.
Pages:
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111