Hi All,
I've created a report that will print out an attendance sheet for instructors to use on a course. The header will be populated with things like location, time/date and the course instructors. The details section will be a list of course attendees and their tombstone information.
Since the course may have multiple instructors, I've added a subreport in the header section to list the instructors in columns. The problem that I've run into is that for every instructor listed in the subreport, it is adding a line in the details section of the main report. Then, when the main report is populated with attendees, they are listed multiple times to fill all of the boxes.
To clarify: If I have eight instructors in the subreport, it creates eight lines in the main report. If I have one attendee assigned to the course, it then populates all eight lines of the main report with that attendee's info.
My question is, can I change something in the way I've applied the subreport or is there a better way of listing the instructors in the header that will cause me fewer problems.
The instructors are also being listed in columns, three across the page before dropping down. That is fairly important to the report design.
Thanks!