Subreports and date parameters

A

Ary

I have a report with four sub-reports included. The report draws from a query
which includes parameters [From Date] and [To Date].

My problem is that the sub-reports have a single date field, and I need them
to display all records for anything in the date range specified in the main
report. I've tried several things with no luck, including having the same
parameters in the subreports (which ended up prompting me for the same
parameters a total of five times each, that's not exactly efficient). I can't
figure out how to join the subreport to the main report in such a way that I
am only prompted for each parameter once and have the range filter in all
records included in the subreports where the date is equal to or between the
dates specified in the parameters.

Thanks for any help anyone has to offer!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top