exporting column headers in "manual" cross-tab report

[mperera]

Hi,

I have created a manual cross-tab report (because I needed % calculations, and hard-coding the columns seemed to be the only way to do this). That part worked great. I have approximately 70 columns, so the designer, they are in the group footer, on multiple lines (since they would not fit across one line). What I need to do is export the data into a spreadsheet, where each "row" spans only one line. I am able to do this if I export the data (without column headers) into a character-separated values file, and then open this file in excel. The problem arises when I want to include the column headers (which are just text fields on the report). If I export the file as a character-separted values file, it exports the column headers as columns, rather than a single row. Is there a way to add the column headers to my report and have them export properly as a header row, rather than columns? If so, which section of the report designer do they need to go into, and how do I export the data?

I can't seem to just export the data into excel from Crystal, because each record (or group) spans multiple lines, and I need it to be on one line.

Thanks for any input!

 

[kenhamady]

If you use Excel "Extended" you can try Tabular format which puts it all on one line. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/