Bound controls in Page Header section of Access 97 report

[osofuchi]

I have a question about how Bound controls in the Page Header section
of an Access 97 report are handled. Let's assume we have a result set
consisting of invoice details for a given client, with multiple
products and multiple invoices. Suppose we want to have a page header
that lists the invoice number for the page as well as the product name.
Each product gets its own invoice number, and there may be multiple
sales of the product on an invoice. We place a control bound to the
invoice number field in the query in the page header, and another bound
control with the product name in the page header.

My question: When Access is populating these controls with values, does
it simply select the first record in the set of records on that page to
fetch the values from?

We have sorted and grouped the records by invoice number, then product
name, with footers only, with "Force New Page" set to "After Section"
for the invoice number group footer.

How does the flow of operations proceed when generating this report?
I'm assuming it's something like this:

Access first fetches the result set for the query. Then it sorts the
data according to our sort expressions. It then processes the groups
in the query, generating headers and footers. It then processes the
groups, selecting the first record in the group to use for the page
header. It generates the page header, then adds to the page the group
header, followed by the details section for the group. If the group
spans more than one page, it uses the first record on each page to
populate the page header. When the group is finished, it inserts the
group footer and , if necessary, inserts a page break if the group
according to "Force New Page".

It seems that when using bound controls in a page header, one would
have to assume that all records on the page would share any values used
in the controls, or the header might be inaccurate.

Thanks in advance,

Nick Keller
Software Developer/Analyst
Mercury Media

 

[Marshall Barton]

I have a question about how Bound controls in the Page Header section
of an Access 97 report are handled. Let's assume we have a result set
consisting of invoice details for a given client, with multiple
products and multiple invoices. Suppose we want to have a page header
that lists the invoice number for the page as well as the product name.
Each product gets its own invoice number, and there may be multiple
sales of the product on an invoice. We place a control bound to the
invoice number field in the query in the page header, and another bound
control with the product name in the page header.

My question: When Access is populating these controls with values, does
it simply select the first record in the set of records on that page to
fetch the values from?

We have sorted and grouped the records by invoice number, then product
name, with footers only, with "Force New Page" set to "After Section"
for the invoice number group footer.

How does the flow of operations proceed when generating this report?
I'm assuming it's something like this:

Access first fetches the result set for the query. Then it sorts the
data according to our sort expressions. It then processes the groups
in the query, generating headers and footers. It then processes the
groups, selecting the first record in the group to use for the page
header. It generates the page header, then adds to the page the group
header, followed by the details section for the group. If the group
spans more than one page, it uses the first record on each page to
populate the page header. When the group is finished, it inserts the
group footer and , if necessary, inserts a page break if the group
according to "Force New Page".

It seems that when using bound controls in a page header, one would
have to assume that all records on the page would share any values used
in the controls, or the header might be inaccurate.

The page header is supposed to get its bound control values
from the first detail data record on the page. Similarly,
the page footer and the last record on the page. This is
handy when creating a phone book style report.

If you want all items on the page to have the same field
value as displayed in the page header, then you should
create a group on the field and force a new page for the
group.