You can assign a conditional style to a report element. Conditional styling enables you to define conditions that determine when to apply particular fonts, point size, text style, foreground and background color, vertical or horizontal grids, and drill down procedures to your reports data when the report is run.
To apply conditional styling, first you define a global condition. Then, you apply that condition to a report element.
The following example highlights employee salaries in excess of $25,000.
You can also include variables that enable you to insert a new conditional value each time the report is run. If the next week you wanted to highlight all salaries that exceed $75,000, you would create a variable condition that prompts you for a number each time the report is run.
Note: If you plan to apply a customized style template, you must do so before you define any conditional styling attributes, or those attributes will be overwritten. For additional information on stylesheets, see the Creating Reports With WebFOCUS Language manual.
Conditions are created, applied, and styled in the Edit Condition dialog box.
The Field Properties dialog box opens.
The Condition List dialog box opens.
The Edit Condition dialog box opens.
Conditions are created, applied, and styled in the Edit Condition dialog box.
The Report Options dialog box opens at the Style tab.
The Condition List dialog box opens.
The Condition List dialog box opens.
A global condition applies to any component in a report if you choose to apply a condition. After a condition is defined, you can apply the condition to any object.
Note: You can assign styling after the condition is met. See How to Associate a Style With a Condition in an Object Area, How to Associate a Style With a Condition for a Column, or How to Associate a Style With a Condition for a Report.
Before you begin, review How to Access the Edit Condition Dialog Box for a Report.
Conditions are created, applied, and styled in the Edit Condition dialog box.
The Condition List dialog box opens.
The Edit Condition dialog box opens.
or
or
The condition is now added to the Condition List in the Condition List dialog box, from which it can be applied to one or more columns or to an object area.
Note: To create another condition, repeat steps 4 to 10.
The default condition name (for example, COND0001) appears in the Applying to Condition field box.
The condition you created appears in the Condition Rule box.
You can apply styling to the condition after it is met. See How to Associate a Style With a Condition in an Object Area, How to Associate a Style With a Condition for a Column, or How to Associate a Style With a Condition for a Report.
For related information about conditional styling of data visualization bar graphs, see Visualizing Trends in Reports.
The Condition List dialog box has the following fields/options:
Lists conditions applied or available to be applied to the selected object or report.
Enables you to create a condition in the Edit Condition Dialog Box.
Deletes the selected conditions from the selected object. Select a condition from the Condition list box and press the Delete button.
Edits the criteria for the selected condition. The Edit Condition dialog box opens. For more information, see the Edit Condition Dialog Box.
The Edit Condition dialog box has the following fields/options:
Displays the name of the condition being created or edited. To change the default name (for example, COND0001), highlight the text and type a new name.
Displays a list of the columns that appear in the report.
Displays a list of possible relationships between the selected report column and either a literal value or another field that it will be compared to.
Specifies a literal value or other field to which the selected field is being compared in the When statement. The available choices depend on the option button selected under Compare Type.
Chooses the type of comparison to make to the field selected in the Field section. Select:
Value to compare the selected field to a literal value. Press the Value button for a list of data records.
Another Field to compare the selected field to another field in the data source.
The following Condition List dialog box displays the condition COND0001: Salary is greater than or equal to $30,000.00:
Tip: For an example of conditional styling with data visualization bar graphs, see Visualizing Trends in Reports.
Suppose that you want to highlight certain values in a report. The following example shows how to create a report that highlights Gotham Grinds vendors who have ordered 300 or more units.
The report appears in the browser.
Suppose you want a report that conditionally highlights values. The following example shows how to create a report of the total number of orders for each Gotham Grinds store and highlight those orders placed on a specific day.
Information On Orders Placed On = &date.
How to: |
The following procedures provide information on how to associate style with a condition.
Before you begin, review How to Access the Edit Condition Dialog Box for a Column.
Before you begin, review How to Access the Edit Condition Dialog Box for a Column.
Before you begin, review How to Access the Edit Condition Dialog Box for a Report.
Before you begin, review How to Access the Edit Condition Dialog Box for a Column.
Note: If you change your mind and want to keep the conditional styling, click Cancel on the Style tab. The condition will appear in the Applying to Condition dialog box the next time you access Field Properties dialog box.
Before you begin, review How to Access the Edit Condition Dialog Box for a Report.
Note: If you change your mind and want to keep the conditional styling, click Cancel on the Style tab. The condition will appear in the Applying to Condition dialog box the next time you access Report Options dialog box.
The following procedures provide information on how to edit conditions.
Before you begin, review How to Access the Edit Condition Dialog Box for a Column or How to Access the Edit Condition Dialog Box for a Report.
The Condition List dialog box opens.
The Edit Condition dialog box opens.
or
or
Note: After a condition is changed, all objects that the condition is applied to will be affected.
The Field Properties dialog box opens.
The Condition List dialog box opens, displaying conditions for the column or object.
Note:
The Condition List dialog box opens, displaying conditions for the column or object.
Note:
Before you begin, review How to Access the Edit Condition Dialog Box for a Column.
The Properties dialog box opens, displaying conditions for the column or object.
Note: A condition determines the rule for conditional styling, but not the style. Therefore, you must define the style.
The Field Properties dialog box opens.
Note: Order is significant because conditions are applied in the order listed. For example, if the first and last conditions are both true, the style in the last condition will override the style in the first.
Note: Order is significant because conditions are applied in the order listed. For example, if the first and last conditions are both true, the style in the last condition will override the style in the first.
Before you begin, review How to Access the Edit Condition Dialog Box for an Object Area.
Note: Order is significant because conditions are applied in the order listed. For example, if the first and last conditions are both true, the style in the last condition will override the style in the first.
The Field Properties dialog box opens.
Note: These steps remove the condition from the selected object only. It does not delete the condition. The condition is still available to be added to other objects in the report.
Note: These steps remove the condition from the selected object only. It does not delete the condition. The condition is still available to be added to other objects in the report.
Before you begin, review How to Access the Edit Condition Dialog Box for an Object Area.
Note: These steps remove the condition from the selected object only. It does not delete the condition. The condition is still available to be added to other objects in the report.
You can copy a condition from one column to another.
To copy all formatting characteristics (including font, grid, background color, and conditional styling) from one column to another, click the Match All Styles option.
The Field Properties dialog box opens.
The Condition List dialog box opens.
The Edit Condition dialog box opens.
WebFOCUS |