Passing parameters via a URL 2

[samps1]

Hi all,

What I am wondering is if it is possible to pass parameters to a report via a URL using Crystal Enterprise and Crystal Reports version 10?

Thanks

 

[Turkbear]

Hi,
Yes..
This one for instance:

[URL unfurl="true"]http://MyCE10Server/viewrpt.cwr?id=147654&apsname=Guest&apsauthtype=secEnterprise&promptex-APP_NO=23&promptex-COPY=0[/URL]

Runs a report ( ID 147654) with 2 parameters ( APP_NO and COPY)..

 

[samps1]

Where can I get the Report ID number?

Thanks for you help

 

[Turkbear]

Hi,
After publishing to the CE system, find the report's folder ( IN the CMC ), right-click on the report name and look at the Properties..The ID will be listed.

 

[samps1]

Can you use a different report view than viewrpt.cwr?

So far things are working great. Thanks for the help Turkbear!

 

[Turkbear]

Hi,
Actually viewrpt.cwr is a command, not a view.

In the URL you can specify the viewer :
If HTML use as posted
For Java add
&init=java
for ActiveX add
&init=actx


to the url posted.

 

[chris777]

Minor addition: The parameter collection is a zero based array and if you don't want to specify the name, but know the order Crystal expects the paramters you can use promptex0= &promptex1=

There is a PDF on url commands for Crystal. Go to their support site and search for "ce8_urlcommands.pdf." The document is written for v8 but is still correct for v10.



Chris
Data Intelligence Group

http://www.digus.com