Open document with multiple values

[former_member190895]

Hi All,

I have a requirement in which I have one input text which is converted to hyperlink text. On clicking on this link I have to open a new report. However i need to pass parameter with multiple values to the child report. I'm using an object which has multiple values in the open document syntax. But its giving me an #multi value error.

[Former Member]

Hi Mantu,

Passing multiple values to child report can be done by using parameter lsM; whereas lsS is used to pass single value.

If there would have been any issue in parameter passing then you would have recieved an error message on child report or a blank child report.

In agreement with Victor, I suspect the values are getting passed succesfully to the child report; however, you are trying to display multiple values of an object in a single cell in your child report.

To make sure if multiple values have been passed, edit the child report and check the SQL. In case of successful passing, you should get multiple values with IN operator in Where clause.

Are you using any formula in child report? If yes could you please share the formula and the report structure.

Are you trying to do some calculations in a free standing cell?

Regards,

Yuvraj

[Former Member]

Hi Mantu,

to me it sounds like you are not (yet) having an issue with the link, but rather with displaying multiple values in one cell. How to accomplish this depends on your specific setup, e.g. solutions thinkable are using UserResponse, ReportFilter, or converting rows into one cell:

bi.scribe: Converting rows into a single cell (comma separated list) in WebI

Best regards,

Victor

[arijit_das]

Multiple values for a parameter are passed as a comma separated format. You can not pass an object having multiple values for a cell as a parameter value.

For details about lsM parameter check http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_opendocument_en.pdf

[former_member225163]

Just a thought, please try using URLEncode() function. Keep the UserResponse(Prompt) with in URLEncode(). This may help you..

Thanks,

Bala