Hi,
Version - Crystal XI
I am having trouble with exporting my Field Headings in Excel 97-2000 - Data Only format. Excel is messing up the order of the Field Headings. My headings are in PH and some have 3 lines of text, some 2 and some just 1.
Excel always puts the fields with 3 lines of text first, followed by 2 and then 1. This is messing up the order in Excel. How can this be fixed? Looked everywhere not finding a solution.
I have a lot of fields on the report so I can't squeeze the field heading in one line. Below is an example
DESCRIPTION----SHORT ----LOCATION------REC
--------------------NAME-----------------------CHANGE
--------------------------------------------------DATE
When these fields are exported to Excel, the order changes to this
REC-------SHORT-------DESCRIPTION----LOCATION
CHANGE---NAME
DATE
Would really appreciate an answer for this problem.
Thanks!
E
Version - Crystal XI
I am having trouble with exporting my Field Headings in Excel 97-2000 - Data Only format. Excel is messing up the order of the Field Headings. My headings are in PH and some have 3 lines of text, some 2 and some just 1.
Excel always puts the fields with 3 lines of text first, followed by 2 and then 1. This is messing up the order in Excel. How can this be fixed? Looked everywhere not finding a solution.
I have a lot of fields on the report so I can't squeeze the field heading in one line. Below is an example
DESCRIPTION----SHORT ----LOCATION------REC
--------------------NAME-----------------------CHANGE
--------------------------------------------------DATE
When these fields are exported to Excel, the order changes to this
REC-------SHORT-------DESCRIPTION----LOCATION
CHANGE---NAME
DATE
Would really appreciate an answer for this problem.
Thanks!
E