Skip to Content
Dec 13, 2018 at 12:54 AM

Passing user response parameters from Webi to Crystal Reports

76 Views Last edit Feb 05, 2019 at 03:50 PM 2 rev


Version: SAP BusinessObjects 4.2 SP6

We have a web intelligence summary report which has Document and Year as prompt text. We also have a detail level report in Crystal reports for Enterprise which is off the same universe as summary webi report with same prompts.

What I'm trying is to link these 2 reports by passing the user selected prompt values from webi to crystal without user entering them again. .

I created a test webi detail report and I have got webi summary to webi detail working perfectly fine. I used that link and changed the cuid to crystal report cuid and sType from wid to rpt. The crystal report opens but the prompt values are not passed which is forcing me to re enter them again not what I expected.

The link below is what I use in my webi summary

="<a href=\"../../opendoc/openDocument.jsp?iDocID=abcfghlasdcinasd&sIDType=CUID&sType=rpt&lsSpsYear="+URLEncode((UserResponse("Year")))+"&lsMpmDocument="+URLEncode((UserResponse("Document")))+"\" title=\"\" target=\"_blank\" nav=\"doc\">Link</a>"

My question: Is this possible or has anyone got it working?

Thanks for your time!!

Kumar Kesireddy