Add conditional styles to your report to better identify exceptional or unexpected results. A conditional style is a format, including such things as cell shading or font color, that is applied to objects if a specified condition is true.
For example, you want to automatically highlight in green departments in your organization that meet their budget quotas and highlight in red the departments that go over budget. Creating conditional styles quickly and easily color-codes information in your reports so that you can find areas that need attention.
You can apply multiple conditional styles to objects. For example, you can apply one style for data formats in specific cells and another style for the overall report. If multiple styles set the same property, such as font color, the last style in the list is applied.
You can also create a conditional style once and reuse it on multiple objects in your report. And you can specify the order in which styles are applied. In addition, you can use existing local classes as your conditional styles.
You can create the following types of conditional styles.
Description Type
Highlights straight numerical data, such as revenues and losses.
Numeric Range
Highlights data from specific dates and times.
Date/Time Range
Highlights data from specific dates. For example, you can highlight sales data for specific periods of a fiscal year.
Date Range
Highlights data from specific times.
Time Range
Highlights data falling between set intervals.
Interval
Highlights specific alphanumeric items in a report. For example, you may want to highlight all instances of a specific word or phrase, such as Equipment. String criteria are case-sensitive.
String
If multiple string conditions are met, only the style of the first condition is applied.
Creates conditional styles that use calculations or expressions.
Advanced
If multiple advanced conditions are met, only the style of the first condition is applied.
Steps to Create a New Conditional Style
1. Click the object for which you want to define a conditional style, and then click the conditional styles button .
Tip: You can also right-click the object and click Style, Conditional Styles, or in the Properties pane, double-click the Conditional Styles property.
2. Click the add button and click New Conditional Style.
3. Select the data item that you want to use to determine the condition.
Depending on the type of data item you select, Report Studio selects the type of conditional style that you can use.
4. Type a name for the conditional style.
5. If you want to define a value, date/time, date, time, or interval condition, do the following:
● Click the new button and type or select a value to define a threshold.
The value appears under the Range column, and two ranges are created.
● For each range, under Style, click one of the predefined styles that you want to apply to the range, or click the edit style button and create a new style.
Tip: You can also define a style for the cells in your report that have missing values.
● Repeat to add other values.
Tip: Under Style, pause the pointer over each range to see the condition produced for each range.
● If you want to move a value above or below a threshold, click the arrow button next to the value.
For example, you insert a threshold value of five million. By default, the ranges are less than or equal to five million and greater than file million. Moving the five million value above the threshold changes the ranges to less than five million and greater than or equal to five million.
6. If you want to define a string condition, do the following:
● Click the new button and select how to define the condition.
● If you want to select one or more individual values, click Select multiple values and click the values you want.
● If you want to type specific values, click Enter values and type the values you want.
● If you want to specify your own criteria, such as begins with the letter A, click Enter string criteria and specify your condition.
● For each condition, under Style, click one of the predefined styles that you want to apply, or click the edit style button and create a new style. Specify the style to apply to remaining values by clicking one of the predefined styles beside Remaining values (including future values).
● Specify the order in which to evaluate the conditions.
Conditions are evaluated from top to bottom and the first condition that is met is applied.
Steps to Reuse an Existing Conditional Style
1. Click the data item for which you want to define a conditional style, and then click the conditional styles button .
Tip: You can also right-click the item and click Style, Conditional Styles, or in the Properties pane, double-click the Conditional Styles property.
2. Click the add button , click Use Existing Conditional Style, and select the style you want to use.
Steps to Create an Advanced Conditional Style
1. Click the data item for which you want to define a conditional style, and then click the conditional styles button .
Tip: You can also right-click the item and click Style, Conditional Styles, or in the Properties pane, double-click the Conditional Styles property.
2. Click the add button and click Advanced Conditional Style.
3. Type a name for the conditional style.
4. Click the new button and specify the expression that defines the condition.
5. For each condition, under Style, click one of the predefined styles that you want to apply, or click the edit style button and create a new style. Specify the style to apply to remaining values by clicking one of the predefined styles beside Remaining values (including future values) .
6. Specify the order in which to evaluate the conditions.
Conditions are evaluated from top to bottom and the first condition that is met is applied.
Chapter 5: Working with Existing Reports
After you created a report, you can