Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date field[reports]![mainreport].[fieldname], but the criteria is a Between....and.....dates and the subreport only picks up the first day of the month entered. How do I refer to that criteria in the subreport criteria so the user only has to enter the date range a single time?
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!