Use the Exception Builder to change the formatting for objects in your report and highlight specific data values based on some condition. For example, if you are analyzing the sale amount of various products, you may wish to highlight any sale amount under $100.
For detailed information on how to access the Exception Builder and how to use an exception in a correlated subquery, see Formatting Exceptions.
To add an exception:
Define the condition for the exception in the Condition field. To add a condition, you can:
Double-click a column or operation to enter it into the Condition field.
The types of operations that you can use in as you define the exception in the Condition field appear under the Operations pane on the right-hand side of the Exception Builder. (For example, numeric functions, file functions, and operators). To view the available options for each type of operation, click on the plus sign (+) next to the operation, or double-click the operation.
For help on the numeric, miscellaneous, and file functions, access the Production Reporting Language online help. (Go to the Source window, press [F1], and go to functions in the index.)
Click Font to define the font name, font size, font style, text color, background color, and script.
For example, you could specify that any sale amount less than $100 appear bold and in red. A preview of how the exception will display in your report appears under Sample.
Select Suppress Output to exclude any data values to which the exception applies.
For example, you could select Suppress Output to specify that any sale amount less than $100 should not print in the report.
If you suppress that output to exclude data values that meet the exception, Format is disabled.
Select Priority Notification to integrate the exception with EPM Workspace.
When you publish a report flagged with the Priority Notification option to EPM Workspace and a user runs the report in the Browse module, an exception is produced. EPM Workspace uses this exception to notify users who are interested in the report, and to place a high-priority icon next to the report.
Note that if you create more than one exception, the notification message only addresses the last exception that you created.
Select Overwrite Existing Exception File Prior to Run to overwrite the existing exception file prior to running a report.
As an example, assume that you previously published a report to EPM Workspace that had an exception, and you subsequently deleted the exception. If you do not overwrite the existing exception file, when you re-publish the report, the deleted exception might still appear in the report. If you overwrite the exception file, however, the old file with the exception is cleared, and the exception will not appear in the published EPM Workspace report.
This option is available only if Priority Notification is selected.
Click OK to exit from the Exception Builder.
When you preview your report, the data values the meet the exception display and print according to the format you defined in the Exception Builder.
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.