Crystal report export to excel, page header issue using asp.net visual studio 2008 sp

[MFiaz]

I have a Crystal report it has dynmic information on page header when I export to excel,

only first page header shows in excel. I am using asp.net visual studio 2008 sp1.

if I export it to others format like pdf, word etc... its working fine

lets assume

page header contanis

department name = 'Operations'
date = 16-06-2010

employee name code
xyz 1
eee 2
cxy 3

here cxy is related to department 'accounts'

if we see this data in pdf or word

it will show correctly

department name = 'Operations'
date = 16-06-2010

employee name code
xyz 1
eee 2


department name = 'Accounts'
date = 16-06-2010

employee name code
cxy 3

[Mike_O]

Hey MFiaz,

Have you tried exporting it straight from the report, rather than involving Crystal automation? I suggest to try and get it working that way first.

Also, when you export and you're looking at the resulting Excel file, this header that you're trying to set up, is it in the Header/Footer section of the page setup, or is it just some contents on top of the sheet? I'm thinking that might give you a hint.

Mike