Boolean Fields and Conditional Regions

• Boolean fields are stored in the database as true or false values. When included in reports, the values typically are required to show as Yes or No. This is achieved by applying conditional formatting, where the value is hidden unless the condition is true.

  1. In the template, add two fields: orseReports.true and orseReports.false. Use font size 9.5 and avoid any whitespace.

  2. Select each individually and click Conditional Region.

  3. In the BI Publisher Properties dialog box, set the data type to Date/Text and the Data field values to Equal to true for orseReports.true and Equal to false for orseReports.false.

     The fields are contained within C and EC markers. Double-clicking the C marker (or right-clicking and opening the BI Publisher Properties dialog box) allows the properties to be edited.

  4. Further conditional logic can be applied if required, in the Advanced tab, for example:

     <?xdofx:replace(seasonalProduct,'false','No')?>
     <?xdofx:decode(seasonalProduct,'true','Yes','false','No','')?>
     <?xdofx:decode(seasonalProduct,'true',orseReports.true,'false',orseReports.false,'')?>