Reportheader with dynamic label

[Carl Seys]

The report I made is grouped by "Status" of "orders".

In the pageheader, there is a label for which the .caption is definded at the moment of formatting depending the value of the "Status".

So far so good, execpt : at the FIRST page in the header
two possibities go wrong :
- when page & total pages are printed in the header : the label.caption is shown for the value of "Status" from the LAST record
- when total pages is not in the header : the label is empty on the first page.
The label in the following pages are correct.

Strange not ?

Any suggestion ?

 

[PaddyIrishMan]

The quickest solution I can think of would be:
Your are probably determining the status to generate the report for via a control on a form - i.e. select the status from a combo box, click a button & the report is generated for the status selected in the combo.
If this is the case, then I'd replace your label on the report with a text box, then set the controlsource for the text box to the control on the form.

i.e. =YourFormName.YourControlName

regards,
Patrick