Cross tabs stops after 47 columns in excel

<p>I have a report that generates columns in a cross tab. This cross tab has many columns and all of them show up in the html emitter but no matter how large I make the master page and the grib cell holding the cross tab it refuses to go past 47 columns when using the excel emitter. My only thought was to use percent when dealing with the master page width which works in html but throws a null pointer exception error in the excel emitter. My question is: is there anyway to allow a cross tab to expand past what seems like some default max size?</p>

Find more posts tagged with

Comments

mwilliams

What is your BIRT version and what Excel emitter are you using?

galloan224

<p>Im currently using Birt 4.3.2 and the emitter is the standard XLS emitter seeing the spudsoft one does not support crosstabs.</p>

mwilliams

I set up an example with 53 columns. It all displayed. What version of Excel do you have? Does your crosstab have multiple measures per column? Or multiple levels of dimensions? Let me know.