Solved

Subreport - Limit to current report ContractID

Posted on 2014-03-07
2
435 Views
Last Modified: 2014-03-07
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
Comment
Question by:Karen Schaefer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 38

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39912964
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
 

Author Closing Comment

by:Karen Schaefer
ID: 39912992
thanks that did the trick
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question