I am having problem in exporting the crystal report into Excel. We have crystal reports with mutliple groups in it. but for some reason we should not show the group headers. we set the group headers hight, width to zero. crystal reports works fine, but when we export the crystal report to excel only all the columns , rows are messed up. As per the forums suggestion  I used the export option of Data only. But this time the problem is it is showing my group headers. We dont want to show group headers in Excel. Can any help us how to resolve this issue. Thanks in advance.

 

Thank You

Thota

 

I think U can better hide or suppress the group headers instead of setting the height and width to Zero.

Try hide or suppress using appropriate formula..

 

Regards,