Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Dates as input parameters to a crystal report

Status
Not open for further replies.

gracia123

Programmer
Mar 3, 2008
1
IN
Hi all,

I am using Crystal reports 8.5 to develop my report. I use the the Crystal report Enterprise Version 8.0 to view my
reports in the IE 6.0 Web browser.
I communicate to the Crystal Enterprise through my Active Server Pages.(ASP 3.0)

From my asp page redirect to the url
I use response.redirect

Here is an example URL:

my url request is

Response.Redirect("report.rpt?&prompt0=" & some random value & "&prompt1=" & DateField & "&prompt2 =" &
DateField )

and I use "sf " query string parameter for passing new selection criteria

There are three Parameters defined:

Prompt0 - to accept a Number
Prompt1 - to accept a Date
Prompt2 - to accept a Date

Problem:
Even after passing the input date parameters as the parameter values for the parameter "Prompt1" and "Prompt2" in my Active Server Page, on launch of the Crystal report in the Crystal enterprise Viewer, the Crystal reports' Dialog still prompts the user to give input dates.

Need Solution for:
I should be able to pass the date parameter values from the ASP page and susequently, the crystal dialog should not be prompted to get the input dates.
Kindly suggest a solution.

Thanks in advance!!
Preethi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top