By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Hide a certain group footer

P: n/a
I am trying to output a report in which I show the total number of
people if groupfooter is "STAFF" but not if it is "ATTENDEES". The
report will say:

STAFF:
Staff1.......
Staff2......
Total staff members: 2

ATTENDEES:
Attendee1.....
Attendee2....
Attendee3.....
Attendee4....

How do I hide the groupfooter for ATTENDEES? Please help. Thanks a
lot.
Jun 27 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a

<ca**********@hotmail.comwrote in message
news:b6**********************************@l17g2000 pri.googlegroups.com...
I am trying to output a report in which I show the total number of
people if groupfooter is "STAFF" but not if it is "ATTENDEES". The
report will say:

STAFF:
Staff1.......
Staff2......
Total staff members: 2

ATTENDEES:
Attendee1.....
Attendee2....
Attendee3.....
Attendee4....

How do I hide the groupfooter for ATTENDEES? Please help. Thanks a
lot.
In the onFormat event of the groupfooter section, check the value and set
me.Visible to true of false. The event procedure name is based on the
section number and not the group name. This numbering can change if you add
or remove sections causing you program to fail.
Jun 27 '08 #2

P: n/a
Thanks for replying, Ron. How do I check the value? I cannot seem to
find the property that gives the value of the group footer, say I had
a PersonType field which had either STAFF or ATTENDEE. What would I
check for in the group footer?
Me.PersonType.????

Thanks again.

Jun 27 '08 #3

P: n/a

<ca**********@hotmail.comwrote in message
news:b7**********************************@j1g2000p rb.googlegroups.com...
Thanks for replying, Ron. How do I check the value? I cannot seem to
find the property that gives the value of the group footer, say I had
a PersonType field which had either STAFF or ATTENDEE. What would I
check for in the group footer?
Me.PersonType.????

Thanks again.
Check the value of the control that group is using. then set the group
footer's property based on that value.

if me![PersonType] = "STAFF" then
Me.Section(4).Visible = False ' Hide section if STAFF
else
Me.Section(4).Visible = True ' Show section if Not STAFF
endif

Section(4) is generated by the Expression Builder. The value (4) may be
different for your report and can change if you add or remove sections.
Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.