Page tree
Skip to end of metadata
Go to start of metadata

You apply conditional formatting much like you do standard column formatting with the extra step of creating the condition by which the formatting is applied. 

To create a condition, complete the following steps:

  1. Run your report, so it opens in the  Report Viewer

  2. Click the header or field of the column you want to format. 

  3. Hover over the  Formatting icon   and select  Formatting from the context-menu. 

  4. Click the  Conditional Formatting tab. The  Conditional Formatting options appear. 

  5. In the  Apply to box, select the part of the column you want to apply the formatting to. 

  6. Click the  Add button. This adds a line item in the  Conditions List. 

  7. Fill in the following information: 

    • Operator: Use the drop down menu to define how the condition is compared to the column data. 

    • Condition: Enter the condition criteria. 

    • Format: Select the formatting applied to fields meeting the defined condition. Take care setting the button states. 

  8.   Repeat if needed to add multiple conditions to a column. If you have multiple conditions, you may want to reorder them, to ensure they do not conflict with each other. Use the Upward icon and the  Downward icon to move conditions in the hierarchy. 

  9. If needed, click  Previous Column or  Next Column to change the conditional formatting for an adjacent column. 

  10. Click the  OK button. The condition is applied to the column. 

  • No labels