The following topics explain the advanced functions of the BI Publisher.
Conditional Formatting
With BI Publisher, it is easy to use conditional formatting to highlight table cells or entire table rows using conditional formatting.
Example
Highlight invoices with an amount over $10,000.
Highlighting a Table Cell
- After you create a table, place the cursor in the cell where want to apply conditional formatting.
Note: The cell must be either text or a Data Field.
- Click Conditional Format. The BI Publisher Properties window open on the Properties tab.
- From the Data field drop-down list select the data element that you want to evaluate to determine the conditional highlighting. This does not need to be the same data field in the cell that you are trying to highlight.
- Specify whether that Data Field is a Number or Date/Text Field.
- Enter the conditions for this Data Field using the pertinent drop-down list.
- For each condition, specify the formatting that you want to be applied when that condition is met.
Only two conditions can be entered by using this window. If you have more than two conditions, you can click on the Advanced tab and copy/paste the conditions already entered to create additional conditions. Ensure that you copy an entire "if" statement, up to and including the "<?end if?>"
Example
<?if:number(INV_AMOUNT)>10000?><?attribute@incontext:background-color;'#FFB9B9'?><?end if?>
Highlighting an Entire Table Row
To highlight an entire table row, follow the preceding instructions; however, ensure that you select Apply to Entire Table Row.