I have a report with a subreport embedded on the Main report. I would like to allow the users to filter the subreport records on a date field in the subreport . Is that possible? How could that be accomplished?
The Main report is named [ProjectDetailsSaveEstimate]
The Subreport is named [SaveDetailReport]
In the Subreport is a field named [SaveDate]
I want to allow the user to create a date range for [SaveDate] displaying only those records in each Subreport [SaveDetailReport] that fall into the selected date range.
I tried to create a query for the subreport but when I ran the Main Report it kept prompting multiple times for the start and end date of the range and did not work.
Thanks for any assistance.