page header -export issue

[mirage10]

Cyrstal reports 10, sql server 2000.

Hi,
I have a report with 2 page headers on the report. pageheader -a is a formula.
-b is text. both are not suppressed by any condition.

when i export to excel 97-2000 data only -

only the page header b exports.
i have interchanged the contents of the page headers - only page header b is exporting. page header a doesnot export.

Can someone advise??

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[mirage10]

I also tried with just one page header - putting both the contents in one page header..
whichever is in the second row only is exporting.. first row doesnot export.

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[synapsevampire]

Makes sense since you're selecting data only and the page header is where column headings are expected to be located.

By data only, Crystal tries to produce a columnar file structure, and you expect something else.

Try posting requirements and someone may be able to explain how the create it.

-k