cancel
Showing results for 
Search instead for 
Did you mean: 

Destination Excel - header missing

mikedinnis
Participant
0 Kudos

Hi,

Has anyone noticed when sending a scheduled report instance to Excel that the report header is missed off?

I've recently upgraded to BusinessObjects Enterprise XI 3.1 SP2 and am attempting to send a scheduled report to a destination of smtp and of a format of Microsoft Excel (97-2003), not the Data only option. It does correctly send the Excel workbook but the column headers are now missing. I say 'now missing' as they used to be there when I scheduled from Crystal Enterprise 9 which was only last week and the report has not changed.

Is there a setting that can be toggled to include or exclude report header information in exported reports? Is this a known issue with a known fix?

Regards,

Mike

Edited by: Mike Dinnis on Aug 25, 2009 3:10 PM Clarified that this is not the 'data only option'

Accepted Solutions (0)

Answers (2)

Answers (2)

mikedinnis
Participant
0 Kudos

Yeap,

It was this setting that controls if headers are to be shown or not. I guess I should have investigated before posting.

Thanks for reading this and I hope it saves you time in the future.

Mike

mikedinnis
Participant
0 Kudos

Since posting I see that there is an option on the format tab of the schedule action to 'Export page header and page footer'. This can be set to any of: None, Once per report or On each page. I think that this might be the option I was looking for.

Mike