Exporting Crystal to Excel with crosstab

[PatKiernan]

Hello All,

I have a crystal report that has a crosstab in the report header. The report basically accounts for parts usage of a time period. I have been able to export to Excel successfully in the past. Just recently I opened my date parameter to account for the past 12 months. This would give me 12 columns and a total column. When I export to Excel with 12 months of data I lose the last month and the total column even though it populates in Crystal. If I make the date range for 10 months, no problem, 11 or 12 months and I lose columns in Excel
Any thoughts?

Any help would be greatly appreciated.

Pat

 

[kenhamady]

Try flipping your report to Landscape and Legal size before you export and see if that makes a difference. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com