Unable to render or show more than 100 columns in MS Excel when i used Crosstab

[venurocknroll]

Hi Alllll,

It would be very appreciate if you can help me in this typical situation.

I have completed report desiging with the help of crosstab. It is working fine, able to show more than 3000 columns on screen, but not able to show those columns in MS Excel. MS Excel is showing only 100 columns.

 

We are able to show all list of columns in MS excel when i used Java Plugin instead of Crosstab, But our requirement is Crosstab. We need to use Crosstabs. We are able to see all those list of columns on Screen of the Jasper Server, but giving problem when i am generating that report in MS Excel with Crosstabs.

 

It is very long landscape report. How can i solve this problem.

Please assist me,

 

Thanks && Regards

    Venu.K

Post Edited by venurocknroll at 12/07/2010 11:18