Reports/Subreports

[Guest]

I have a form that allows users to run multiple reports based on the criteria
they select on the form. Some of these reports have subreports. I need to
find a way for the criteria selected to apply to both the report and the
subreport in the report. Currently only the report runs off the criteria and
the subreport includes all data, not just the criteria selected data.

 

[David Lloyd]

One approach would be to use fields (hidden, if necessary) on the primary
report and have the subreport(s) reference these fields to filter the data.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a form that allows users to run multiple reports based on the
criteria
they select on the form. Some of these reports have subreports. I need to
find a way for the criteria selected to apply to both the report and the
subreport in the report. Currently only the report runs off the criteria
and
the subreport includes all data, not just the criteria selected data.

 

[Guest]

Thanks David. Unfortunately, that did not work for this database, but by
moving some things around in the report, I was able to eliminate the need for
the subreport allowing the criteria selected to do the job the way it was
envisioned. Everything is working fine now.