Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue with Cross tab in CR 2008 V1


I am having a couple of issues with cross tab table in Crystal Reports (v

1. Exporting to Excel messes up the columns. I am fitting cloumns in the cross tab along with headers and footers with "size and position" option such that 1 column should fir in 1 column in excel. But when I export the report to excel, some cells get merged and the positioning goes off. This works with regular tables in CR, but cross tab is giving problems.

2. All Key figures in the rows part are converted to text when exported to excel. Only summarized fields are exported as numbers. Is there a setting to get numbers from rows as numbers in excel?



Former Member
Former Member replied

To get a crosstab to come through somewhat gracefully in Excel it's important to use the "Excel (data only) option and then uncheck the "Simplify page headers" and check the "Export object formatting" option. It doesn't look great but at least everything is in the right colummns. Then you could just do a macro in Excel to clean it up and make it look pretty.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question