Combine multiple reports into one...?

[ZBKAI189]

My DB tracks quality assurance inspections. Each inspection can have 1, 2, or 3 nonconformities. Accordingly, there are 3 possible reports that can run as the final report. The argument/condition of the final report is formatted such that (noncon1=true and all others are false, open report 1... noncon1 and noncon2=true and all others are false, open report 2, etc).

Is there a way to open the appropriate report for all inspections at once? That is, inspection1 had 3 nonconformities (therefore, final report3)... inspection5 only had 1 (therefore, final report1)... can I open both reports and merge them into one?

 

[HiTechCoach]

I would try using a report with the three reports inserted as sub reports.

I woudl fiorst try to make it so that each of the three reports only have data in them if the are needed. This would mean that the record source would have to fitlyer the records. Setting the sub report control's property for can shrink = Yes will make then automatically not show. No VBA code needed,

If this is not possible, then you could add code to the report to make the sub reports visible as needed.