how to create complex reports with more than 63 columns
Hello,
I've been working lately on bi publisher reports with multiple columns ( exceeding 63 columns).
Usually I prefer using RTF templates over the basic bi publisher layout editor or excel template for flexibility and access to put in some code. For example to add if else statement , naming different sheets etc …
However I ‘m running frequently into the MS word table limitation of 63 columns. For reference I’m creating report with roughly 70-80 columns. I've exploring some alternatives and workaround but nothing seems to fit perfectly.
First I tried moving to another doc editor but from what I've found bi publisher and RTF are tailored for MS word so this approach will demand more adaptation for not so much in return.