Subreport Using Parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a subreport which runs a query that requests user input.
The user enters a beginning date and an ending date. Data is displayed
based on the dates. When I run the subreport alone, it works beautifully.
However, when I run the main report with subreport, the input boxes keeping
popping up over and over again. (Keep in mind that the main report uses it's
own query.)

The reports are linked using an id field. I have tried various fixes to no
avail. The only successful solution is to hard code the dates in the query,
but I don't like that solution as someone else will be running this report,
and I would rather they not open the query in design view to enter the dates.


Does anyone have an idea?

Outdone--again.
 
The subreport's query is being run for each record in the main report. I
would suggest running the report from a form and having the criteria for both
queries pull dates from text boxes on the form. This provides you with the
added benefit of being able to trap for valid dates, midding dates, etc.
before letting the user run the report.

HTH,
Barry
 
Back
Top