I have a fairly simple Access report. It has a report header, no page header and in the detail section it displays a field from the query the main report (PaymentsandRecordings) is based on, then there are two reports, one for Payments (PaymentsSubreport) and Recordings (RecordingsSubreport) which bring in data based upon the field from the main report.
I am trying to suppress these subreports when there is no data. I have used HasData procedure, Can Shrink attribute, and have done this on the SubReport Format, and the Detail Format properties. Nothing is working. I am using Access 2010.