automate hiding the report footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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).
Click to expand...

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
 
This worked perfectly; thanks for the suggestion.

fredg said:
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).
Click to expand...

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
Click to expand...
 
Back
Top