We
will discuss expressions more in depth in the next chapter.
6. Create a Table element in the report, and bind it to the employeeSales Data
Set. Do this either by dragging over from the Data Explorer, or using the
Palette. Delete the OrderDate column.
7. Create a Group in the Table called GroupByEmployee, and set it to group on
the EmployeeNumber. Create another group below GroupByEmployee, and
call it groupByDate. Set it to group on the orderDateShort field.
Charts, Hyperlinks, and Drill-Downs
[ 218 ]
8. Merge all of the cells in the orderDateShort Detail Row into one large cell.
9. In the new large cell, create a Chart element.
Chapter 9
[ 219 ]
10. Select Meter as the type, and select the Super imposed Meter as the Chart
subtype. Change the Output Format to PNG.
Charts, Hyperlinks, and Drill-Downs
[ 220 ]
11. In the Select Data tab, create another Dial by selecting
from
the Meter Value Definition drop-down list.
12. For the expression for Dial 1, select row["SALES"] by either dragging the
column over from the Data Preview pane, or by using the Expression
Builder. The value for Dial 2 should be set to 3000.
Chapter 9
[ 221 ]
13. For Category Definition, use row["NAME"] by either dragging the column
over from the Data Preview section, or using the Expression Builder.
Pages:
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178