Oracle Analytics Publisher

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

Categories

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

BIP RTF template passing colum width at run time

Received Response
575
Views
4
Comments
Ambily-Oracle
Ambily-Oracle Rank 4 - Community Specialist
edited May 18, 2024 11:03PM in Oracle Analytics Publisher

Summary

BIP RTF template passing colum width at run time

Content

We are using an RTF template to create a BIP report where the output is expected in excel. We do have almost 60 columns in the report and hence the column size has come very small. When we get the output in excel user has to increase the column width. We have to use RTF template only as we have a requirement to create column dynamically. For these dynamic columns we are specifying the width using expression split-column-width. Is there any way to do the same for static columns, like passing the width as a parameter in input XML. Please help .

Answers

  • Yogen
    Yogen Rank 5 - Community Champion

    Only solution to this is to use xsl-fo template. You can convert your rtf template into xslfo, then manually modify the  xml file for xslfo template to customize almost any formatting needs.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    We cannot control excel column width using RTF template, but you can try fixed width but heigth 100% in cell proprty. This will wrap the text in EXCEL if it exceed in width

    At the table level, specify fixed width:

    Example

    <fo:table start-indent="-0.35pt" xdofo:table-summary="Template Table 1" xdofo:row-header-count="0">

                         <fo:table-column column-width="100pt"/>

                       

    At the inline specify the height as 100%:

    <fo:inline xml:space="preserve" height="100%" font-family="Calibri" white-space-collapse="false" font-size="11.0pt"><xsl:value-of select=".//INVOICE_STATUS" xdofo:field-name="INVOICE_STATUS"/>  </fo:inline>

    Regards,

    Brajesh

  • Ambily-Oracle
    Ambily-Oracle Rank 4 - Community Specialist

    Thanks, I tried this already. But there I had to hard code the width in xsl-fo. I am looking for something like auto width. Depending on data size the column width should increase, is it possible to achieve the same using xsl-fo?

  • Babu Chalamalasetti
    Babu Chalamalasetti Rank 1 - Community Starter

    Hello @Ambily-Oracle

    Encountering the same issue. How to overcome this. Appreciate your help!