Rollups in page header and footer

[Dale Fye]

I have a report that contains records that include a [Classification] with
values (Unclassified, FOUO, Confidential, SECRET, ...).

Each record displays this value at the top of the detail section for the
record, but I also need to include a textbox or caption on the top and bottom
of each page indicating the maximum security classification for that page,
and in the reports header, I need one that gives me the maximum
classification for the report.

I could just hard code it to the maximum value possible, but would prefer to
have the report make that determination, as a filtered report might only
contain unclassified data, and I wouldn't want that marked SECRET.

Any help would be greatly appreciated.

 

[Duane Hookom]

It would be very difficult to do this by Page unless the records in a Page
were the result of some grouping.

To get the maximum possible value, you would need to identify what
determines maximum possible value. Databases are dumb. They would assume the
maximum would be the one that would sort last alphabetically.

 

[Dale Fye]

Duane,

I should have mentioned that I have a table (tbl_Classifications) that has
the ClassID, Classification, and Sort_Order, so I could include the
SortOrder in the Query. I knew that you could do a count or a sum by
grouping in a forms footer, thought there might be a similiar way to do
something in the reports page footer.

I've done some pretty neat stuff with formatting reports, but have never
really had a need to put anything (at least not something calculated) in a
page footer

Thanks for the response.

It would be very difficult to do this by Page unless the records in a Page
were the result of some grouping.

To get the maximum possible value, you would need to identify what
determines maximum possible value. Databases are dumb. They would assume
the
maximum would be the one that would sort last alphabetically.
--
Duane Hookom
Microsoft Access MVP

I have a report that contains records that include a [Classification]
with
values (Unclassified, FOUO, Confidential, SECRET, ...).

Each record displays this value at the top of the detail section for the
record, but I also need to include a textbox or caption on the top and
bottom
of each page indicating the maximum security classification for that
page,
and in the reports header, I need one that gives me the maximum
classification for the report.

I could just hard code it to the maximum value possible, but would prefer
to
have the report make that determination, as a filtered report might only
contain unclassified data, and I wouldn't want that marked SECRET.

Any help would be greatly appreciated.

 

[Duane Hookom]

You could possibly do page max if your page records could be identified as a
group.

Do you understand how to find the max in your report or are you still
looking for assistance?

--
Duane Hookom
Microsoft Access MVP

Duane,

I should have mentioned that I have a table (tbl_Classifications) that has
the ClassID, Classification, and Sort_Order, so I could include the
SortOrder in the Query. I knew that you could do a count or a sum by
grouping in a forms footer, thought there might be a similiar way to do
something in the reports page footer.

I've done some pretty neat stuff with formatting reports, but have never
really had a need to put anything (at least not something calculated) in a
page footer

Thanks for the response.

It would be very difficult to do this by Page unless the records in a Page
were the result of some grouping.

To get the maximum possible value, you would need to identify what
determines maximum possible value. Databases are dumb. They would assume
the
maximum would be the one that would sort last alphabetically.
--
Duane Hookom
Microsoft Access MVP

I have a report that contains records that include a [Classification]
with
values (Unclassified, FOUO, Confidential, SECRET, ...).

Each record displays this value at the top of the detail section for the
record, but I also need to include a textbox or caption on the top and
bottom
of each page indicating the maximum security classification for that
page,
and in the reports header, I need one that gives me the maximum
classification for the report.

I could just hard code it to the maximum value possible, but would prefer
to
have the report make that determination, as a filtered report might only
contain unclassified data, and I wouldn't want that marked SECRET.

Any help would be greatly appreciated.

 

[Dale Fye]

I've figured something out that takes care of a single value that I will use
for the entire report in both the page header and footer. Thanks for your
assistance.

Dale

You could possibly do page max if your page records could be identified as
a
group.

Do you understand how to find the max in your report or are you still
looking for assistance?

--
Duane Hookom
Microsoft Access MVP

Duane,

I should have mentioned that I have a table (tbl_Classifications) that
has
the ClassID, Classification, and Sort_Order, so I could include the
SortOrder in the Query. I knew that you could do a count or a sum by
grouping in a forms footer, thought there might be a similiar way to do
something in the reports page footer.

I've done some pretty neat stuff with formatting reports, but have never
really had a need to put anything (at least not something calculated) in
a
page footer

Thanks for the response.

It would be very difficult to do this by Page unless the records in a
Page
were the result of some grouping.

To get the maximum possible value, you would need to identify what
determines maximum possible value. Databases are dumb. They would
assume
the
maximum would be the one that would sort last alphabetically.
--
Duane Hookom
Microsoft Access MVP


:

I have a report that contains records that include a [Classification]
with
values (Unclassified, FOUO, Confidential, SECRET, ...).

Each record displays this value at the top of the detail section for
the
record, but I also need to include a textbox or caption on the top and
bottom
of each page indicating the maximum security classification for that
page,
and in the reports header, I need one that gives me the maximum
classification for the report.

I could just hard code it to the maximum value possible, but would
prefer
to
have the report make that determination, as a filtered report might
only
contain unclassified data, and I wouldn't want that marked SECRET.

Any help would be greatly appreciated.