Issue with Cross tab in CR 2008 V1
I am having a couple of issues with cross tab table in Crystal Reports (v 22.214.171.1247)
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?
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.