Supporting table with more than 63 columns in RTF template

Question

Summary

Content

We are working on an RTF template to get and excel report which has many number of columns. The columns can go till 1000, and the number will be decided at run time, we are using dynamic column creation with split–column–header logic. Since we have the limitation that we cannot create a table with more than 63 columns, I tried to do the work around as suggested here.

http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplesoft-fi-l/xml-publisher-rtf-template-maximum-columns-3873031

Here we do create a first table with say 2 columns, and within each column will create the table with 63 columns of actual data. When I tried this and saw the excel report using BI plugin, I observed an extra column getting created between the individual tables. I assume this comes as the individual table sit within cells of parent table. Is there any way to avoid this extra column? Any suggestion will be of great help.

Saran Kumar Suru · Answer

Thank you for your response, it was helpful

Abhilash K - Deloitte USI · Answer

I do not think any workaround worked me for this one. I had to tell my users that if you have a lot of columns to be shown on a report, I suggest they go for an excel or csv extract. It simply would not make a lot of sense to force ourselves to use rtf and keep those pdf outputs with congested columns. if you were to use that rtf layout for excel outputs, i would still keep them under 50 if i could.

Saran Kumar Suru · Answer

Hi Meghana,

When i try this using sub templates, still the additional columns with blank data is appearing between individual tables from subtemplates.

Would you please let me know how you have avoided this?