Grouping & subreports

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

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
 
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.
 
Back
Top