Analyze with Excel not picking up fields from page header

[deduct]

I have a report that contains a text box with the data source of CORPCODE. When I preview the report, it properly displays the CORPCODE in the page header (which I have set to display on "all pages&quot.

Problem is when I use the "analyze with Excel" tool button, the resulting Excel worksheet creates a column for CORPCODE, but all cells in that column are blank. The remaining columns are properly populated with fields from the detail. This report is not useful because the user can not determine to which CORPCODE the detail lines relate.

I get the same results with Office 97 and Office 2000.

Any ideas?

 

[Darrylles]

Hiya,

Sorry - I've got a question.

What does 'analyse with Excel' give you from a report?
Why do it?
Really - I'm interested.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[deduct]

What: 'Analyze with Excel' is supposed to create a worksheet from the report.

Why: Because my users want it. I try to give my users that they WANT (not always what is 'best'). They have their reasons, and it is not my job to argue with their reasons.

Karl

"No questions are stupid questions, when you are still learning."