Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher - RTF cell borders based on condition

Received Response
106
Views
1
Comments
Nagmani Morab
Nagmani Morab Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

BI Publisher - RTF cell borders based on condition

Content

Hi,

We have created an RTF template in BI Publisher which outputs an excel file. In the excel output we need the cell borders/gridlines based on some condition. For eg. we need borders for only subtotals and total and the remaining rows should be without any border.

Please share the syntax for it.

Regards

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi

    Do you not have the sub total and toal rows defined in the RTF template already? If so, you can add the borders you need by using a table (even a single celled table) around the values.

    That said, I would recommend using a table for everything in the RTF template so that it 'translates' to an excel sheet with cells more completely.

    Regards

    Tim