Exporting from Crystal Management Console to Excel

[HeathHol]

Hi -

I am trying to figure out why I can not see the page headers when I export my report data from the crystal management console to excel.

The data appears but there are no column headings.

Any help will be greatly appreciated.

HeathHol

 

[EricJP]

You need to look at the "Schedule / Format". If you're using the "Microsoft Excel Data only", you'll need to change it to "Microsoft Excel". Then, check to see what the 'Export page headers and page footers:' is set to, you may want "On each page"

Also, on the source report, you'll want to make sure the fields are touching each other or else you get extra blank columns.

Hope this helps.