Is it possible for each individual record in a report to have different subreports visible at the same time?
I have a report that is divided up in to subreports but each individual record has a different combination of subreports defined by a query.
the query looks like this:
RecId, Surname, Subject1, Subject2, Subject3
1, Smith, English, Maths, Science
2, Jones, Art, Drama, English
3, Doe, Science, PE, History
The report should look like:
Report1 - Surname, Smith
Section1 - English
Section2 - Maths
Section3 - Science
Report2 - Surname, Jones
Section1 - Art
Section2 - Drama
Section3 - English
My current thinking is to insert all possible subreports on top of each other for all three sections (with labels like: Sec1Maths, Sec2Maths,
Sec3Maths, Sec1English, Sec2English, Sec3English, Sec1Science, Sec2Science, Sec3Science, etc) and make them all invisible. Then add
some code that will automatically identify which subject is listed in the subject columns of the query (which have already been added to the
report as textboxes) and combine the subject name as part of string which is used to identify which subreport is made visible.