In order to start with exception highlighting, the designer can right-click on
the data cells in the grid or outside of the grid; right-clicking on either the row
or column headers will not show the Exception Highlighting option. After rightclicking
in one of the two proper areas and selecting Exception Highlighting, the
Exception Highlighting dialog box appears, as shown in Figure 6-42. Note that the
first dropdown box lists the measures that are available in this view. The second
dropdown box contains a list of conditions, including equal to, not equal to, between,
and so forth. Finally, there is a box to hold the actual value.
In Figure 6-42, the view has been changed so that the measure Gross Profit
Margin, and both the filter empty rows and filter empty columns buttons have been
selected. In addition, the business has decided that any gross profit margin over 40%
should be highlighted with a green background, while any gross profit margin of less
than zero should have a red background.
In order to set this up, a designer would set the first condition to have a measure
of Gross Profit Margin (the only one available in this case), the condition to ???greater
than,??? and the value to 40. In order to set the background as green, the developer
would click the Configure Highlight Format button causing a new dialog box to appear
that allows for the background color, font color, font type, font size, and font styles to
be set. After setting up the first condition, the developer would click the Add button
to add the second condition.
Pages:
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249