Use exceptions to change the formatting for report objects 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.
To format an exception:
Double-click an object in the report layout, or right-click the object and select Object Properties.
Select the Exceptions tab.
The Exceptions tab displays all the exceptions created for the selected column. When you create more than one exception, the exception displayed at the top of the list has the highest priority. If a data value meets the conditions of multiple exceptions, SQR Production Reporting Studio applies the formatting options of the highest exception. To change the priority of an exception, select the exception and click Move Up or Move Down.
Click Add to add an exception
You can also click Edit to change the information on an exception, Copy to create a copy of an exception, or Remove to delete an exception.
Define the condition for the exception.
Since SQR Production Reporting Studio writes the condition directly to the Production Reporting source file, the condition must be legal in Production Reporting.
Valid operations for the condition appear under the Operations pane (for example, numeric functions, file functions, and operators). To view the options for each type of operation, click the plus sign (+) next to the operation, or double-click the operation. (For more information on Production Reporting operations, see Volume 2 in the Hyperion SQR Production Reporting Developer's Guide)
Click Format to define the format to apply to the exception.
A format can include a font name, font size, font style, text color, background color, and script. A preview of how the exception will display in your report appears in the Sample area of the dialog box.
Select Suppress Output to exclude data values to which the exception applies.
Select Priority Notification to integrate the exception with Oracle Enterprise Performance Management Workspace, Fusion Edition.
When you publish a report flagged with Priority Notification to the EPM Workspace, and a user runs the report, 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.
If you create more than one exception, the notification message only addresses the last exception 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 the Exception Builder.
When you preview your report, the data values that meet the exception display and print according to the formatting you defined.
If you create more than one exception, the notification message will only address the last exception that you created.
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.