Solved

Sub-Report

Posted on 2003-11-25
4
306 Views
Last Modified: 2008-03-06
I have a sub-report in a main report that pulls off the same query. The problem is that the query asks the user to input a date so it will only pull the records on that date.
So when the report opens it asks the user to enter a date and instead of just once it asks multiple times because of the sub-report. If I run the report without the sub-report it only asks once but with the subreport it asks 5 times. How can I link the entered date of the main report to the sub-report. I've tried to link it on the Link Child Fields and the Link Master fields but it won't work. The column that I'm trying to link is the AsOfDate.
0
Comment
Question by:Code_Buzz
  • 3
4 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9818737
Hey Code_Buzz!

  Copy the main report query
  Remove the date parameter
  Link the subreport to the Mainreport by the other links + this date.
 
  and that should do it.

regards
Jack
0
 
LVL 32

Accepted Solution

by:
jadedata earned 500 total points
ID: 9818755
It might be good to launch this report from a form where this AsOfDate will be available for evaluation.
Use the form control (forms!launchform.txtAsofDate) as the parameter
All the queries involved that use this date would be able to see and evaluate this at runtime.

This instead of the "ghost" parameter you are using now.
0
 

Author Comment

by:Code_Buzz
ID: 9818878
You the man!!!
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9818898
thanx for the question!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

770 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