Hi Everyone,
In this post, we will see how to add a BIP Report as a Drill Down report to another BIP Report.
Step1: Create Drill down BIP report as usual
Step2: In the main Report, In sql code add the following as new field
'https://<host>:443/xmlpserver/reportpath.xdo??_xiasynch=&_xpf=&_xpt=0&_dFlag=false&_edIndex=0&_dIndex=0&_rToken=&_ranDiag=false&_xdo=%report_path.xdo&_xmode=4&xdo%3Axdo%3A_params<parametername>_div_input='||<parametervalue from code>||'&_params<parameter2>='||<parameter 2 value from code>||'&_xt=<ReportName without extension>&_xf=html&_xautorun=true&_linkToReport=true'
Oracle doc link: Accessing Reports via a URL
Step3: In the Main report xpt, edit, on the column where hyperlink has to appear
select properties > Misc > URL - give the DM field where step2 is there
No comments:
Post a Comment