[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Subreport - Limit to current report ContractID

I have a Main Report with a subreport that should display the totals for the current record only (contractID)  

I am using the Master/child link, however, the subreports seems to display all values.

I even tried limiting the query of the subreport using a variable - without success.

What is the best approach to display only those values on the subreport that matches the current record on the Mainreport?
0
Karen Schaefer
Asked:
Karen Schaefer
1 Solution
 
PatHartmanCommented:
The master/child links are used by Access to filter the contents of a subreport.  If they are not working, delete the subreport, save the report, compact and repair and then add the subreport back making sure to properly set the master/child links.
0
 
Karen SchaeferAuthor Commented:
thanks that did the trick
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now