This is just like
the totalEmployeeSales, except that it is on the Table instead of on the
employeeNumberGrouping.
Styles, Themes, and Templates
[ 192 ]
10. In the Outline, Delete the Row under Groups|Header.
11. "Drag and drop" all of the data elements from the Table|Detail|Row|Cells
into the Table|Group|Footers|Cells.
12. Delete the Detail Row from the Table. Double-click on the PRICEEACH
field to enter the edit Dialog. Enter the function Dialog and change the
Expression to Available Column Binding|Table|totalEmployeeSales.
Chapter 8
[ 193 ]
13. Insert a new data element into the cell in the Table Footer Row (last column),
and set the Expression to row["totalSales"]. This will display the total overall
sales as specified in the aggregation in the report.
14. Click on the Table Header Row, and change the text alignment to Left.
15. Click on the Header Label for PRICEEACH and change it to
Employee Sales.
16. Click on the last column and change the text alignment to Right. As this
is a currency field, we want this to be right justified, which is normal for
accounting-related reporting.
17. In the data elements for totalEmployeeSales and totalSales, change the
Format Number|Format As value to Currency.
Styles, Themes, and Templates
[ 194 ]
18. Select the Master Page tab in the Report Designer.
Pages:
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165