I have a cross tab that works perfectly and looks correct in Crystal. The format looks like this:
When I export it to Excel, the first Total is in a column by itself, then the Row#1 Name is on the next line, next column over and takes 2 columns. Then I have two blank columns. Then everything looks good until I get to the end - the last 3 entries each take 2 columns (all the others took only 1). I hope that makes sense. I am just wondering why I have these extra columns and if there is anything I can do to force to format better. I have played around with page size, the fields in the Page headers lining up correctly; just about anything you would normally do to get a Crystal report to export to Excel cleanly but it hasn't helped.
TIA!
~RLG
Code:
| Column #1 Name Total
[b]Total[/b] Count of @Order_Type Count of @order_type
Row #1 Name Count of @Order_Type Count of @order_type
Row #2 Name Count of @Order_Type Count of @Order_type
When I export it to Excel, the first Total is in a column by itself, then the Row#1 Name is on the next line, next column over and takes 2 columns. Then I have two blank columns. Then everything looks good until I get to the end - the last 3 entries each take 2 columns (all the others took only 1). I hope that makes sense. I am just wondering why I have these extra columns and if there is anything I can do to force to format better. I have played around with page size, the fields in the Page headers lining up correctly; just about anything you would normally do to get a Crystal report to export to Excel cleanly but it hasn't helped.
TIA!
~RLG