Creating Conditional Formatting

Using conditional formatting, you can format selected characteristics (such as customer XY) differently. In the executed report, these characteristic values have the formatting you specify and are set apart from the other characteristic values in your group level.

You can apply conditional formatting only to characteristic values in dynamic sections of a data provider. A data provider with a dynamic section is based on a query (or query view) with one or more characteristics in the drilldown.

1. Choose Report → Insert Data Provider to select a data provider with a dynamic section. The selected data provider is automatically embedded in a report section and is displayed together with the associated row patterns in the design area of the Report Designer.
2. In the design area, select a row in the group level of the characteristic for which you want to apply conditional formatting to its characteristic value(s).
3. In the menu bar for the Report Designer, choose Format →Conditional Formatting. The BEx input help dialog appears.
4. In the BEx input help dialog, select a characteristic value for which you want to create the conditional formatting. In the design area, an additional row is displayed for the selected characteristic value beneath the selected characteristic row. This new row has its own row pattern.
5. Select the new row created for the characteristic value and format as required using the formatting functions. You can access these functions in the menu bar and in the toolbar of the Report Designer. You can, for example, color the row, left or right align the row, or add borders to the row.
6. Save the report and execute it. This allows you to check the display of your conditional formatting.
7. To apply conditional formatting for further characteristic values of a data provider, repeat steps 2 to 6.

You have applied conditional formatting for a characteristic value.