✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com

Trends

Wednesday, 4 October 2017


Drilldown from Summary to Detail report in BI Publisher


By on October 04, 2017

  • Inserting Hyperlink
Open the Employee_Details summary report template.
 
Choose the field(e.g. EMPNO) on which hyperlink has to be enabled then right click on the chosen field then Hyperlink



Paste the copied path of the Employee_InDetail report.




 

  • Defining Parameter in RTF template
Parameter has to be passed on to the detail report by appending the highlighted syntax at the end of the detail report URL.
 
Where EMPNO (on the left hand side) is the parameter name created in the detail report and EMPNO (on the right hand side) is the alias name for the column “EMPNO” in the Employee Details summary report.
 
Save the template.
 
The template needs to be refreshed after placing the FORM field. Go to BI_Publisher_LabGuideà Employee_Details àbrowse the template àupload
 
Save the report àView.
 
The output is shown below


 
Click on the EmployeeNo and it will drill down to detail report

Kashif
mkashu: Drilldown from Summary to Detail report in BI Publisher
Review : Kashif | Kashif
Update: October 04, 2017 | Rating: 4.5

Comment for "Drilldown from Summary to Detail report in BI Publisher"

0 comments

Post a Comment

Blog Archive

Labels