Recurring Parameter Prompt

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

Guest

I have a report that uses a sub-report. For the main part of the report, a
popup requests the user to enter a chargerate. For the sub-report part
another popup requests the entry of a loadrate. The report works fine. It
consists of multiple pages. The problem is that the loadrate prompt recurs
with the change of each page. Once all pages have been viewed, it doesn't
recur; but the same thing happens again if I choose to print the report.
What's causing that and how can I fix it? If I run the sub-report alone I
only have to enter the loadrate once. This only happens when I run the main
report that has the sub-report in it. The chargerate prompt for the main part
of the report also comes up only once.
 
The only way to solve this is to add a LoadRate field to the report's main
query and have the prompt occur there. Then use the link master / link
child fields to pass the load rate to the sub report.
 
I would avoid all parameter prompts in favor of pulling values from controls
on forms. Entering values at prompts is not very functional and is prone to
errors etc.
 
You're probably right on this, but we're sort of experimenting with different
chargerates and loadrates at this point. That's why I've made it a manual
entry. Would you suggest I have the entry occur at an input form box?
 
I would almost always use a control on a form. This allows you to see
multiple criteria values at once, set defaults, use combo or list boxes,
take advantage of calendar controls, check integrity of entries,.........
 
Duane, I think I am doing just what you suggest. My form uses combo boxes and
a calendar control to enter information. There are default values and I even
use some information to check for errors (which migh be checking for
integrity). The only boxes that don't have defaults or multiple criteria are
the loadrate and chargerate. As I mentioned, we're experimenting with what
value works out the best, so we are currently changing them slightly each
month. Are you telling me that we simply must live with the annoying popup
that asks for the same information that has already been inputted? This
typically happens as you page through the report. When you get to a certain
page, the popups ask you to input the loadrate, chargerate, and date again.

Still need help!
 
A recurring parameter might be due to a subreport or a control bound to an
expression that can't be resolved.
 
Thanks a lot. I finally got it to work by locating all the sub-report queries
and linking them to the main report controls.

Ray S.
 
Back
Top