Use exceptions to change the formatting for report objects and to highlight specific data values based on some condition. For example, if you could highlight sale amounts under $100.
The Exceptions tab displays all of the exceptions created for the selected column. For multiple exceptions, the exception displayed at the top of the list has the highest priority. If a data value meets the conditions of more than one exception, for example, the formatting options for the higher exception is applied. To change an exception's priority, select the exception and click Move Up or Move Down.
To add a new exception, click Add. You can also click Edit to change the information on an existing exception, Copy to create a copy of an exception, or Remove to delete an exception. When you click Add, the Exception Builder appears.
If you enter a column or expression on which you have created a group break into the Details section of the layout, you cannot create an exception for that column or expression. As a result, the Exceptions tab does not appear in the object properties for the column or expression. If you create an exception that references another column and then delete the referenced column from your query, you will get an error when you try to run the report since the referenced column no longer exists.