Access 2003 Report With Chart Subreport Parameter Problem....

[Roger]

I have an access report the currently is based on one parameter query.
[sReportDate]. This report ran fine only prompting once for the parameter
when run, and not asking again when printing.

I have added a chart subreport that is based on a different query but uses
the same parameter [sReportDate]. When running this Chart Report by it's
self I am only asked once like I am supposed to be.

When I run the report with the subreport added, I am asked 5 + times for the
same parameter? Why?

I have had several queries based on the "Same" parameter name and am usually
only prompted once, why the difference here in the reports / sub reports.

Thanks,

Rog

 

[Guest]

I've seen this happen to me when I have a calculated control in the header or
footer that restates the parameter limits, and my wording is not exactly the
same. For example, the parameter may be a date range like
BETWEEN [Enter starting date] AND [Enter ending date]
but in the header I use a text box whose control source is ="For the period
" & [Enter beginning date] & " through " & [Enter ending date]

The parameter query used "starting" date, but the header used "beginning"
date. When I've done that I've been prompted for starting date, beginning
date and ending date.

Other times I've had this happen were when the report originally included
sorting and grouping. The data involved in some of the sorting and grouping
was later removed from the report, but the sorting and grouping itself was
not removed. In that case you'd be prompted for the data fields that Access
cannot find.

 

[Guest]

Roger,
Your report is based on a query which has a parameter to search - e.g. ENTER
DATE - your subreport is also based on a query with a parameter to search -
perhaps also ENTER DATE;
Your report and subreport are linked, possibly by the same field DATE
When you run the report, it runs the first query and asks ENTER DATE, then
runs the query for thesubreport, and again asks ENTER DATE for that separate
query
The solution is to alter the second query, removing the ENTER DATE
requirement. If this upsets some other part of your program, then you will
need two queries - one for the other part of your program and another,
identical except for the parameter, to be the subquery for your subreport.