Detailed report linking in Webi using hyperlinks!

[bhavikd]

I needed some help with report linking in Webi, I'd appreciate if any of you could take a look at it & give your suggestions. I'm trying to link from a Full Client BO report to a Webi detailed report.

Full Client Report: LINK_FROM
Webi Report: LINK_TO

LINK_FROM Prompts: CF, PF, RF
LINK_TO Prompts: CF, PT, RT

What I'm trying to do is: user enters the values in the prompts on the LINK_FROM report, a summary report is displayed. I need to create a downloadable button on the LINK_FROM report which when clicked directly takes me to the detailed report for the prompt values entered in the full client (LINK_FROM)report. For eg: CF= 8810, PF = 1997, RF = 1, when the user enters these values in the LINK_FROM report, it displays the report, now the user wants to see the detailed report for the same values, so he clicks on the downloadable button which takes him to the detailed report for the same values.

1)I have been successful to display the detailed report when I hard code the values in the html script behind the button:

'<A HREF=&quot;

http://abc/wi/bin/iswi.dll/WIGenera...&lsSRT=1&lsCBR=-1&quot;target=widocview>Click

Me 2</A>'

2) I can also go to the prompt screen of the detailed report, but I need to by pass that and go directly to the report. The script used here is:

'<A HREF=&quot;

http://abc/wi/bin/iswi.dll/WIGenera...RF&quot;&lsCBR=-1&quot;target=widocview>Click

Me 3</A>'

or the user response function in the script:
'<A HREF=&quot;

http://abc/wi/bin/iswi.dll/WIGenera...F&quot;)&lsCBR=-1&quot;target=widocview>Click

Me 3</A>'

Also I tried some other thnigs. One thing to note is we are trying to create this by creating the variable at the report level & not by creating an object in the universe. So, that means, I create the button on the master report by creating a new cell & right clicking on the mouse, selecting variable, clicking on the formula tab & then writing the html script there. I believe this is the way of doing it. I'd appreciate if any of you could take a look and give any suggestions.
Thanks

 

[miaoli6005]

Hello there,

Have you got it to work finally? My name is Miao, and I am currently doing EXACTLY the same thing -- trying the pass prompted values between two reports using hyperlinks. I couldn't get it to work and really really like some help. I thank you in advance. My problem is that if I used @variable to reference the LINK_FROM report's prompt/parameter value: &lsSPT='@variable('PF')', I will get the value but the value is quoted, and my LINK_TO report was unable to take quoted strings as parameter values. I couldn't get the syntax &quot&lsSPT=UserResponse(&quot;LINK_FROM_QUERY&quot;,&quot;PF&quot to parse at all. Are you on an oracle database? I am. I would really appreciate it if you can give me some suggestions. Again thank you very much.
I can be reached at miao.li@lazard.com