Jasper Server is not able to send more than 100 columns to the MS Excel Sheet

[venurocknroll]

Hi Alll,

 

I am traying to generate long and long report which consists more than 1000 fields. I have implemented it by using crosstabs. Published it on Jasper Server and ran the JRXML, it was generated On screen output. Now i am trying to generate output in MS Excel sheet fornat. But it is showing only 100 columns. But we are able to see all list of columns using ODT Excel sheet. I want to generate MS Excel sheet with full list of columns.

We are not able to see those list of columns when we tried to run that report in MS Excel.

 

Please assist us if you know the reasson...

 

 

Thanks && Regards

    Venu.K