automate hiding the report footer

[Guest]

My report is displaying data sections based on a user id with totals at the
end of each section and at the end of the report; the report footer totals it
for all users. What I'd like to do is take a command and see if the first
user id for the report is different than the last user id for the report; if
it is display the report footer but if it is not to indicate there's only one
user section, hide the report footer (because the report footer would then
match the section totals and it's redundant data).

 

[fredg]

My report is displaying data sections based on a user id with totals at the
end of each section and at the end of the report; the report footer totals it
for all users. What I'd like to do is take a command and see if the first
user id for the report is different than the last user id for the report; if
it is display the report footer but if it is not to indicate there's only one
user section, hide the report footer (because the report footer would then
match the section totals and it's redundant data).

Add an unbound control to the UserID Group Header.
Set it's Control Source to
= 1
Set it's Running Sum property to Over All.
Name this control "CountGroups"
You can make this control Not Visible.

Code the Report Footer Format event:
Cancel = [CountGroups] = 1

 

[Guest]

This worked perfectly; thanks for the suggestion.

My report is displaying data sections based on a user id with totals at the
end of each section and at the end of the report; the report footer totals it
for all users. What I'd like to do is take a command and see if the first
user id for the report is different than the last user id for the report; if
it is display the report footer but if it is not to indicate there's only one
user section, hide the report footer (because the report footer would then
match the section totals and it's redundant data).

Add an unbound control to the UserID Group Header.
Set it's Control Source to
= 1
Set it's Running Sum property to Over All.
Name this control "CountGroups"
You can make this control Not Visible.

Code the Report Footer Format event:
Cancel = [CountGroups] = 1