Subreport parameters

[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

 

[Eric Butts]

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

 

[David Bolduc]

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

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

.