Filters and Subreports

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I have a main report with a subreport. I have a form with
buttons that opens this report/subreport. The buttons
corresponds with weeks in a month. So when you click on
the button, it opens the desired report with the correct
filter applied. However, I really want the filter applied
to the subreport not the main report. Is this possible???

My reasoning is that the information stays the same on the
main report; Customer ID, Location, Manager. On the
Subreport systems that require service are grouped
together by type of system. These systems are serviced at
different times in the month. Would it be possible to
apply the filter, that directs the report on which reports
to display, directly to the subreport?

When I apply the filter to the main report, it creates a
report for each criteria not regarding that some weeks
there may not be a system that requires service. Thus, I
end up with multiple reports that have just the Customer
ID, Location, and Manager listed. I don't want to view
the reports that don't have systems listed for that week...

Any help that can be provided would be greatly
appreciated! Thanks!!
 
Hi Tina.
Why not include the filter in the query for your
subreport, with other words, in you subreport in the
criteria for the data field enter [YourFilterForm].
[YourDateName] (change to the appropriate names).
Hope this helps.
Fons
 
Back
Top