When you have more than one data exception based on the
same database field in a report output level, the ordering of the
exceptions can impact which exception the data matches.
When you have multiple data exceptions, you may want the
most restrictive exception listed first, since the data is checked
against the first exception before other exceptions in the list are
matched. For example, you could create exceptions in a report that
show the number of open incidents each of your contacts have. You
could create an exception to indicate contacts with five or more
incidents and another exception to indicate contacts with ten or
more incidents. If the first exception is count(incidents.i_id)
> 5
, and the second is count(incidents.i_id) > 10
, then your data would match only the first exception even if a
row had an incident count greater than ten. This occurs because the
first exception has precedence over the second exception. To correct
this, you would reorder the data exceptions.
- Select the data exception you want to move on the design
surface.
- Click the Design tab.
- Click Move Up or Move
Down to move the exception to the position you want.
Tip: You can also reorder exceptions by dragging
them in the exceptions report section on the design surface.