Post Author: bh1
CA Forum: General
have a report designed from SQL that reports on pupils who have passed
their 50, 100, and 150 metres swimming badges. If they have passed then
a 1 is displayed in the column, if they havenu2019t a 0 is displayed. The
Passed column is a formula field that will show a 1 (meaning Pass) if
they have passed all three (50,100 and 150) and a zero if they havenu2019t.
The report is grouped by Team and Tutor.
Team 1 (GROUP1)
Tutor Dave Harding (GROUP2)
Pupil ID Name 50m 100m 150m Passed
145 Ian Jones 0 1 0 0
243 Trevor Smith 1 1 1 1
456 Dave Davies 1 0 0 0
Each page is formatted so that a different tutor will be displayed,
with a list of his/her pupils. I have suppressed the Detail section to
only show pupils who ARENu2019T up to date so it will only display pupils
where the Passed column is 0.
The problem that I am having is that I want to suppress the Group
Header for the Team and Tutor if there are no pupils to display. I am
having trouble suppressing these sections as they are grouped. Can