Pass parameters via URL to Crystal Reports

[kate8]

Hi everyone,
I have been trying to figure this out, but there is no clues at all.

I have several Crystal Reports that need to be accessed from another application. When people click the link from another application, the reports will get these parameters from URL and use them for creating reports. My problem is that how the crystal reports can get those parameters from URL.
Is that have to be done in the Report Server?

Thank you so much for any suggestions or helps!!!

 

[Turkbear]

Hi,
This was possible in early versions of CR but I do not know if it is still supported..Here is some info from an early doc:

http://www.buoyantsolutions.net/PUBLIC/DOWNLOAD/ce8_urlcommands.pdf

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kate8]

Turkbear,

Thanks a lot for you respond!!

My version is 2008, I will find out if it supports this functionality or not. Also I am not quite sure how CR can get the values from URL, how that Prompt# parameter work. The document show how to attach values to URL, but I can not tell how Prompt parameter work in the CR.

Could you explain it a little bit? Thank you!!

 

[Turkbear]

Hi,
In this example:

http://myServer/myVirtualDirectory/viewrpt.cwr?id=152&apstoken=A1B2&promptex-sample="hello"

There is a report published with an ID of 152 which has a string parameter named sample - the URL provides a value of 'hello" for that parameter. Any other parameters can be added to the URL with their values supplied in the same way;

http://myServer/myVirtualDirectory/...ample="hello"&promptex-newparamname="goodbye"

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kate8]

Hi Turkbear,

Thank you so much!! I got this part now, but before getting into this step, I have another issue. When user click the link to the report, they have to enter User Name and Password before they can see the report.
We just have the 2008 install, we had version 9 before, someone set it up long time ago. How can I set up the login bypass, then users can open the report directly? I checked the CMC, but couldn't find the setting for this purpose.There is a .java file in the server, but I am not sure if I should modified it without causing any problems.

Again, thank you for all your help!!!

 

[Turkbear]

Hi,
In the CMC there should be, on the Report properties page, a place to enter the database logon info and to indicate that that should be used each time. If, however, you open the report in CR and republish it , that info may be erased and need to be reentered in that same place. ( There was , in XI and earlier, an ability to specify what gets updated when a report is republished and the database logon info could be deselected so republishing does not alter the existing data)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kate8]

Thank you, Turkbear!!
Maybe I didn't explain my question clearly. The login is not for database, is for enterprise Server. I just found a solution from another thread.

http://myServer/myVirtualDirectory/...assword=admin&wid=123aasd&id=1122&acctNum=123

now when user click the link, will be able to open the report without enter user name & pwd, but acctNum does not pass to the report. I have a parameter with the same name "acctNum" in the report. How can the value of acctNum be passed to the report?

Thank you!!

 

[Turkbear]

Hi,Revise your URL to this:

I'm not sure about this part of your URL:

http://myServer/myVirtualDirectory/viewrpt.cwr?apsuser=admin&apspassword=admin

&;wid=123aasd&id=1122&acctNum=123

but try this instead:

http://myServer/myVirtualDirectory/...apspassword=admin&id=123&promptex-acctNum=123

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kate8]

Hi Turkbear,

It is working!!!
Thank you so much!!! You save my day, not only today. I have been strugling for this issue for days.

The part "&;wid=123aasd" is my missed typing. But I did not use "promptex" for my parameter. Now the report got the value passed.

Thank you!!
You have a good day!

 

[Turkbear]

Hi,
Glad to help..

Just a note for the future:
Not a good idea to pass admin user info by a URL, so create a new user that just has READ rights to the enterprise and use it for all reports ( the database login is hidden so no issue there)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kate8]

Thank you again, Turkbear!!!
I have thought about it. Great idea!!