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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!