BIP RTF template passing colum width at run time

Ambily-Oracle

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 .

Yogen

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

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

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

Hello @Ambily-Oracle

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