473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

display parameters on report?

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
2 1645
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Mark Flippin | last post by:
This is for a reporting problem using: Access 2000 SQL Server 2000 Both at SP3 I've a stored procedure in SQL Server 2000 which builds a result set from a disparate set of tables, utilizing...
10
by: Adis | last post by:
Asp.Net Visual Studio 2003 SQL Server. Hi, Obtaining Data Based Upon Multiple Selections From a ListBox... I have database in Sqlserver and ListBox (Multiple Selection Mode) in my Visual...
0
by: Mariana | last post by:
Hello, I am exporting reports in pdf format from .net 2005 . The export is working fine; however the user values of stored procedure parameters does not show in the report. What do I need to do in...
1
by: mviz | last post by:
I have a RS dataset that contains XML data, but when this data is displayed on the browser it shows as a string. I need help to display this data as a formatted XML document in browser. I have...
14
by: lmttag | last post by:
Hello. We're developing an ASP.NET 2.0 (C#) application and we're trying to AJAX-enable it. We're having problem with a page not showing the page while a long-running process is executing. So,...
1
by: Reef81 | last post by:
Does anyone know a way to have the search parameters displayed in the query or report? For example, if I set up a parameter to search all entries in my table, is there a way to have the search...
1
by: Lewe22 | last post by:
I have a complicated report with numerous parameters which will on occasion return no records. What i want to do is have a new report display when this happens which includes the company logo etc....
3
by: S_K | last post by:
Hi and thanks in advance for your help. I have a Reporting Services report that I need to display in an ASP.NET web page using the ReportViewer. However I can't link the Reporting Services...
2
WyvsEyeView
by: WyvsEyeView | last post by:
I have a form on which users select various search parameters and then click a View button to display a report of the results. I would like to display the search parameters used on the report itself...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.