Formatting Output Values in BI Publisher: How to Make Values Bold and Underline Using an RTF Template




How to Make Output Values Bold and Underline in BI Publisher (RTF Template)

How to Make Output Values Bold and Underline in BI Publisher (RTF Template)

Hi there! If you’re developing an Analytics Publisher Report using RTF in BI Publisher, you might come across a requirement where you need to make certain parts of the output values bold and underline. In this blog post, we’ll guide you through the process of achieving this formatting in your RTF template.

Step-by-Step Guide

  1. Open your RTF template in a compatible editor such as Microsoft Word.
  2. Select the part of the string that you want to format as bold and underline. This would typically be a column value like Col_B.
  3. Apply the formatting to the selected text by choosing the “Bold” and “Underline” options from the font formatting toolbar.
  4. Save the RTF template.

Here’s an example of how the modified code snippet should look like in your RTF template:

    <?xdofx: if COL_A = 1 then
      ‘Document Invoice value is $' || <?xdofx: '<u><b>' || Col_B || '</b></u>'?> || ‘ check document’
    else if
      ‘Please find the attachment for Invoice details’
    end if?>
  

By enclosing the Col_B value within the <?xdofx: ?> tags and applying the <u> and <b> HTML tags, you can dynamically format the specified portion of the string as bold and underline. When the report is generated, the selected part will be displayed with the desired formatting.

Make sure to save the template and test it with sample data to ensure that the formatting is applied correctly in the generated report output.

With these steps, you can easily make output values bold and underline in your BI Publisher reports, enhancing the visual presentation of your data.

We hope you found this blog post helpful! If you have any questions or further inquiries, feel free to leave a comment below.

Happy reporting!


Leave a Reply