Crystal Report Excecl Export issue

[Former Member]

We are doing some maintanence activity on the reports migrated from crystal report 8.0 to crystal report 9.0. We have pade header set and when we export this report to excel format page header comes with every page. We want it to be once on the excel at the top. Can we set page header to display once on excel. We don't want report header Please note.

[Former Member]

It has been awhile since I used CR9, but this should be an option when you are doing the export.

[Former Member]

what you can do is is select the export to xls

select options

and uncheck the export page header page footer.

then it wont export the header at all

if you can figure out a way to conditionally supress an addtional report header you can place what you want to export in there and it only displays when it is exported.

not sure how its can be done.