Grouping & subreports

[Guest]

I have a report that groups instructors and lists the courses they taught &
what their grade distribution was for each course. Eng 104 and Eng 107 are
considered part of Level 100

I have brought in a sub-report that is appearing in the LEVEL footer, using
LEVEL as the the master/child connection.

So what I WANT is for the detail of the report to list all the Eng 100
classes & then the subreport to appear after all that to list the entire
level's grade distrubution.

What I GET is for example:
Eng 104 and all its grade distribution info
Then I get the Sub report showing the entire level's grade distribution
Then I get ENG 107 and all its grade distribution info
Then I get the Sub report showing the same thing it did 2 lines up
and so on...

how do I get the Sub report to only show up once at the end of all the
courses listed for that level instead of after every course

 

[Steve Schapel]

Donna,

It sounds like your Grouping is based on the course? How have you
defined the LEVEL footer, and what data is in the report's Record Source
to define the 100 Level? I expect you would get the results you want if
your grouping is based on the Level.