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