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