By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

display parameters on report?

P: n/a
I've got a report. The user is prompted for two parameters when it opens, a
start date and a finish date (the report displays all courses between those
dates).

How can I get the parameters that the user entered to display on the report.
I can't use max and min of the resulting record set, becuase there often
(usually) won't be courses on the dates specified, just _between_ them.

Cheers, Jo
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Jo,

Use an intermediate or "Launcher" form with textboxes for the parameters and
a command button for the print command. Let your original "Print" command
call this form rather than the report. Leave the form open as you open the
report. in the criteria lines where you now prompt for the parameters, let
each parameter refer back to the textboxes:

Like forms!frmLauncher!ParamText1

HTH
--
-Larry-
--

"Jo Davis" <j@j.com> wrote in message
news:42***********************@news.aaisp.net.uk.. .
I've got a report. The user is prompted for two parameters when it opens, a start date and a finish date (the report displays all courses between those dates).

How can I get the parameters that the user entered to display on the report. I can't use max and min of the resulting record set, becuase there often
(usually) won't be courses on the dates specified, just _between_ them.

Cheers, Jo

Nov 13 '05 #2

P: n/a
Oops! I left out the most important part.

In your report design create textboxes that will refer back to the textboxes
on the Launcher just as the criteria lines did.

HTH
--
-Larry-
--

"Larry Daugherty" <La********************@verizon.net> wrote in message
news:dI3Yd.62861$EL5.40341@trnddc05...
Hi Jo,

Use an intermediate or "Launcher" form with textboxes for the parameters and a command button for the print command. Let your original "Print" command
call this form rather than the report. Leave the form open as you open the report. in the criteria lines where you now prompt for the parameters, let each parameter refer back to the textboxes:

Like forms!frmLauncher!ParamText1

HTH
--
-Larry-
--

"Jo Davis" <j@j.com> wrote in message
news:42***********************@news.aaisp.net.uk.. .
I've got a report. The user is prompted for two parameters when it
opens, a
start date and a finish date (the report displays all courses between

those
dates).

How can I get the parameters that the user entered to display on the

report.
I can't use max and min of the resulting record set, becuase there often
(usually) won't be courses on the dates specified, just _between_ them.

Cheers, Jo


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.