Passing Parameters from a Salesforce.com Object into a Crystal Report

[Former Member]

We use CrystalReports.com with Salesforce.com.

I would like to know if there is a way to build a link which when clicked in Salesforce.com would take certain information from the Salesforce page the user is currently on, such as an Account Number and then pass that as a parameter to the Crystal Report that I am linking them to.

This was mentioned 4-5 years ago in the forums (I looked first) and I hope that since then, the functionality has been added.

Thanks in Advance.

[angelica_mariscal]

I am wondering the same thing. Any answers yet??

[steve_norton]

Hello,

You can pass parameter values into a crystal report using something like this:

https://bi.ondemand.com/show/?lsSMyParamName=MyParamValue

The "MyParamName" and "MyParamValue" needs to be url encoded if there are any spaces or special characters.

The "lsS" prefix on the param name tells us that it is indeed some parameter in the report.

Cheers

Steve

[Former Member]

Bruno,

The openDocument method should allow you to pass parameters to your crystal report. The article at http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/f036a563-6364-2b10-aeba-ca88df5c686c may be what you are looking for.

[Former Member]

Great article, thanks - however what I am looking for is actually the REVERSE of what that article describes.

I want to click on a link in Salesforce.com, such as a link on the Account page and then have the link open a crystal report, passing the Account ID as a parameter INTO the crystal report so that the end-user does not have to do a lookup in a parameter for that crystal report themselves.

[Former Member]

I believe the same concept can be done as the account id is a parameter that should be able to be passed. I will try to test this out, but the account id is likely just a parameter, or possibly part of the URL.