Strange report/subreport problem

[Wayne-I-M]

I have a report with a subreport

The main report has a group header for name, id, etc
It also refers to a text box in the subreport's footer.

But no matter what I do the text box in the main form's group header refers
to the next record - this is strange as this means the 1st header refers to
the last record

I have never seen this before

Any ideas ?

 

[Dale Fye]

Version?

Where is the subform (group header or detail section)?

Have you tried putting the textbox in the groups footer to see what happens,
or in the details section?

I cannot say I have ever tried to put textbox in a group header that
referred to a value in a subreport. Assuming that the subreport is in the
details section, I would think that it has not been formatted yet when the
group header is being formatted, so any reference to that control would
probably refer to the previous instance of that control.

I am a bit surprised that the textbox in the first group header actually has
data from the last record. Although I recall running a function which was
supposed to generate a sequential number (have subsequently learned about the
running sum) for the report, and it always came back with numbers that
reflected running through the function twice (once for each page, then a
second time for each page).

 

[Dale Fye]

I generally use Page X of Y at the bottom of each page, I assume that may be
what caused it.

Which may also account for why Wayne's report is picking up the results of
the "last" subreport in the textbox on the first page of the report.

 

[Wayne-I-M]

Yes, you are right.

Still don't why though.

I took off the "this is page of page etc" and it solved the problem.

Like I said, don't know why - not sure I like that though. I like to know
everything that goes on with a DB I have created. Will google it in the
morning and get to the bottom of it

Thanks though for you help
--
Wayne
Manchester, England.

I generally use Page X of Y at the bottom of each page, I assume that may be
what caused it.

Which may also account for why Wayne's report is picking up the results of
the "last" subreport in the textbox on the first page of the report.

 

[Dale Fye]

Wayne,

Is it now showing the correct information in the textbox in the group
header, even though the subform is in the details section?