getting parameters into crystal reports

IainK · Jul 27, 2001

Hello there!

I am trying to create a template in crystal reports (v. 7) which I can use to display relevant data from the database. I have a dhtml forms webpage where a user can specify the parameters of the report they wish to see (ie, company, reports type, date).

Ideally after selecting the paramters, the user could click submit and it would take them to the Crystal Reports page which will have uploaded the relevant info.

Essentially what I need to know is - how can I identify and use the paramters chosen in a normal dhtml webpage - in crystal reports, so the relevant data will be shown.

Cheers,
- Iain

PS Please tell me if I can clarify this in any way (I am somewhat new to this!)

AEldridge · Jul 27, 2001

Upgrading to either CR8 or CR8.5 will make this much easier as you simply pass the parameters to the report on the URL:

http://myserver/myreport?param0='foo'&param1=123

Not sure how you do this in CR7 - you will probably have to do some ugly work with the automation server via ASP.

Cheers, Alan Eldridge
Melbourne, Australia

IainK · Jul 27, 2001

Cheers - I'm looking into version 8.

In the mean time - do you have any ideas on what I would need to do with regards to asp on the automation server?

- Iain

balves · Jul 27, 2001

There's a full example zip file at:

http://support.crystaldecisions.com/updates/

The filename is: simpxmps.zip

You take the parameters off of the ASP page, and either pass them to the report, or replace the entire WHERE clause of the report. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer

IainK · Jul 30, 2001

for future reference...

to access a report depending on the paramters put into a dhtml form, the form properties were altered so 'submit' pointed to a page called 'getpage.asp'. this cleaned up the info a redirected the browser to the correct cystal reports page.

'getpage.asp' looks like this:

***

<%
Dim table2

table2 = Request.Querystring("table&quot

%>

<HTML>

<head>
<META HTTP-EQUIV="Refresh" CONTENT="1; URL= <% = table2%>">

</head>

<BODY>

<A> Redirecting to <% = table2%></A>
<p>
</BODY>

</HTML>

***

Hope this helps anyone with a similar problem!

Cheers,

- Iain K

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!

getting parameters into crystal reports

IainK

Programmer

AEldridge

Vendor

IainK

Programmer

balves

Programmer

IainK

Programmer

Similar threads

Part and Inventory Search

Sponsor