Subreport parameters

  • Thread starter Thread starter David Bolduc
  • Start date Start date
D

David Bolduc

I have a report with two subreports which creates an
invoice for billing. I have one subreport placed in the
Client ID Footer and the other in the Report footer. The
report along with the two subreports using a parameter
based on the order date. This allows me to select the
month in which I would like the orders to print. When I
open the report, it prompts me several times for the
beginning and end dates. Is there a way to just have to
enter this parameter once for the entire report?

Thank you in advance,
David Bolduc
 
Hi,

I'm pretty sure it's prompting several times because the subReport is in
the Client Footer.

In essence, for each Client the subReport runs..... your subReport
apparently has a parameter, then it's going to prompt each time.

Why not have whatever parameter equal to a value on the Main Report,
Example:

- In the Report Header have textbox controls "txtBegin" and "txtEnd"
with the control source equal to
[Enter Beginning Date]
and
[Enter Ending Date]

- In your SubReports wherever you have the parameter prompter enter
=Reports![the main report]![txtBegin]
=Reports![the main report]![txtEnd]


Thereby, when you run the Report you are prompted only one time for the
above.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
 
I understand what you are saying, but how do you get the
text control to lnk to the order date field?
-----Original Message-----
Hi,

I'm pretty sure it's prompting several times because the subReport is in
the Client Footer.

In essence, for each Client the subReport runs..... your subReport
apparently has a parameter, then it's going to prompt each time.

Why not have whatever parameter equal to a value on the Main Report,
Example:

- In the Report Header have textbox
Click to expand...
controls "txtBegin" and "txtEnd"
with the control source equal to
[Enter Beginning Date]
and
[Enter Ending Date]

- In your SubReports wherever you have the parameter prompter enter
=Reports![the main report]![txtBegin]
=Reports![the main report]![txtEnd]


Thereby, when you run the Report you are prompted only one time for the
above.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

.
Click to expand...
 
Back
Top