BIP RTF template passing colum width at run time

Question

Summary

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 .

Babu Chalamalasetti · Answer

Hello @Ambily-Oracle

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

Brajesh Shukla-95078 · Answer

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

At the inline specify the height as 100%:

Regards, Brajesh

Ambily-Oracle · Answer

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?