cancel
Showing results for 
Search instead for 
Did you mean: 

pass multiple values through enterprise hyperlink in crytsal

former_member195446
Participant
0 Kudos

Hi experts,

i was able to pass single values from one report to another report through hyperlink

"/OpenDocument/opendoc/openDocument.jsp" +

"?sIDType=CUID" +

"&iDocID=AQiJ5DSXlltOrUriAmPm_iA" +

"&sType=rpt" +

"&sOutputFormat=H" +

"&sWindow=Same" +

"&lsS={@Level}"

here instead of lsS i have used lsM for multiple values but its not working

Please let me know how to resolve this?

Thank You,

Prasad

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member203168
Active Participant
0 Kudos

Hi,

A multi-valued parameter has to be passed as a comma delimited string.  To get this from the input parameter to the main report, you'll create a formula that looks something like this:

StringVar strParam := '';

NumberVar paramSize := ubound({?MyMultiParam});

for i := 1 to paramSize do

(

  strParam := strParam + {?MyMultiParam}[i];

  if i < paramSize then strParam := strPara + ',';

)

strParam

This will parse the array of parameter values and create a comma delimited string.  Use this formula to send the parameter values to the URL.

refer below link for more information.

OpenDocument Link not working as expected | SCN

--Praveen Guntuka

former_member195446
Participant
0 Kudos

HI Praveen,

i have created this formula in second report and trying to use the formulas in hyperlink code but i was not able to do that

can you please tell me where should i create exactly

former_member203168
Active Participant
0 Kudos

Hi,

if you place the formula after &lsm[Parameter_Name], whether this is working on not?

for a test purpose, use static values instead of formula

&lsm[Parameter_Name] = [LOV1],[LOV2],[LOV3]


and check whether this is working or not.


Please check below document for your reference;

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0daee1d-0e38-2d10-0c91-8bb4ab5aa...


URL Reporting


--Praveen G


P.S:Multiple prompt values, separated by a comma.If the target is a Crystal report, each value must be enclosed in square brackets and separated by commas. If the target is a Web Intelligence document, multiple values must be separated by semi-colons.