I created a cross-tab report having multiple summarized fields which is calculated fields and used only for the summary total display(used to calculate summary at different levels). So I suppressed all the columns except one which keeps the sum of all the suppressed fields in the same row. When I exported to pdf from the crystal report viewer it works as expected. But when I exported to Excel it is a total mess.
It keeps a blank cell for each suppressed field. Is there any way to remove this blank cells while exporting. All the fields are same height and are horizontaly left aligned.
I tried to export this into excel in data only format, it gives me error like * Error detected by export DLL: The report contains data that spans more than the maximum number of allowed columns in MS-Excel. Retry specifying a larger column width.*
Is there any better way to format cross-tab to keep excel useful?
Please post your thoughts.