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


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

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"


Post a Comment

Blog Archive