Excel Limitation Problem

Hi,

I am using BIRT Cross Tab Reports and I have faced some issues while displaying report in excel format.

The excel 2003 has a limitation for 255 columns. So if the cross tab report contains more than 255 columns I will get an exception. In BIRT is it possible to copy the extra columns (that exceeds 255) in a separate sheet while generating reports in excel format?

Thanks,
Devidas

Find more posts tagged with

Comments

mwilliams

Hi Devidas,<br />
<br />
I don't think there is anything that can be done with BIRT to make that happen. You'll probably have to just make sure you limit the data to be able to fit in 255 columns. I could be wrong though. You may file a bug at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a> and see if they know of a workaround for you to use.

Devidas

Michael,

Thank you for the response. Could you please let me know if you come across any work around for this problem? I am using dynamic cross tab report and the number of columns would be known only at run time.

Thanks,
Devidas