Setting the Evaluate Option
The Evaluate option determines when a new element is shown on the chart. On a standard vertical chart, they would be the elements listed on the X-axis. For example, this determines when a new bar is drawn on a bar chart. There are three options to choose from and they are listed in Table 10-3.
Table 10-3. The Evaluate options.
|On Change Of||A new element is created when the value of the field changes. The value plotted on the other axis is the sum of all fields that are in each group.|
|For Each Record||A new element is created for each detail record in the table. Check the number of detail records because too many records will over-crowd the chart.|
|For All Records||Shows a single element on the chart. The value plotted on the other axis is the grand total of each field selected in the Show Value(s) list.|
The On Change Of option requires a little more explanation than the other two options, which are fairly straightforward. The On Change Of option is used in conjunction with one or more report fields. It creates chart-only groups and summarizes the values within the group. The groups in the chart...