How do I include headers when automating a report from BusinessObject 11.5

Hi All,

Ive design a report in Crystal 9 and I export it out using the export wizard selecting MS Excel 97-2000 (data only). When I view the report in excel, it has everything I need (most importantly, the headers). When I automated the report to run each morning via my BusinessObjects 11.5, the header info is missed out, how do I get the header to appear on the automated report?
daiwhyteAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
How did you schedule it?

WHen I have exported reports one of the options is to include the headers.  Perhaps that is turned off in the BO export.

mlmcc
0
 
MIKESoftware Solutions ConsultantCommented:
Not sure what you mean by "automate"...?

Do you mean "schedule" the report to run automatically and export to excel automatically?

0
 
daiwhyteAuthor Commented:
Sorry, yes your right, schedule.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
MIKESoftware Solutions ConsultantCommented:
I believe you have to set the format of the HEADER itself to allow it to export...check the formatting...
0
 
daiwhyteAuthor Commented:
CRXIuser2005, where to do I check the formatting?
0
 
daiwhyteAuthor Commented:
MIMCC, thanks thats the one!
0
All Courses

From novice to tech pro — start learning today.