Skip to Content
Former Member
Apr 23, 2007 at 08:06 PM

Problem Suppressing Group


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

anybody help?