Report asks for parameter twice for every chart that I have in it

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

Guest

I have produced a report that is based on a parameter query. I created the
parameter to ask for "town "and "city". I grouped the data in my report based
on another feid. I have also added calculated controls and a chart to each
group within the report. For every chart that is in the report I am promted
to enter the parameter twice. I must do this when I open the report, print
the report(times every copy), send a .snp, and scroll through pages of the
report. How do I stop this while still qurying my report?????
 
Kick your development up a notch by not using parameter prompts in queries.
Use references to controls on forms for your criteria.
 
Can you explain a little more

Duane Hookom said:
Kick your development up a notch by not using parameter prompts in queries.
Use references to controls on forms for your criteria.
Click to expand...
 
Always allow users to enter values into controls on forms for setting
criteria. For instance, you might have a form "frmRptDates" with two text
boxes "txtStart" and "txtEnd". Users can enter values into the text boxes
and run a query that has a criteria like:

Between Forms!frmRptDates!txtStart And Forms!frmRptDates!txtEnd
 
Back
Top