Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Thursday, March 27, 2014

Inter Panel Communication in Jasper Dashboard by passing parameter from one panel to other panel OR Drill down frames with in Single Dashboard page by passing parameter(s)

Hi Guys,
Jasper by default doesn't provide drill down functionality with in the frames on dashboard.
Here is way how to achieve this functionality.

R&D links from Jasper Community 


1) http://community.jaspersoft.com/questions/537996/drill-down-reports

2) http://community.jaspersoft.com/questions/537752/materials-dashboardmashboard-webinar

3) community-static.jaspersoft.com/sites/default/files/questions/webinar_extending_dashboards_20110308.pdf

4) http://community.jaspersoft.com/wiki/creating-interactive-dashboards-using-javascript


Example :
Report 1: Displaying a pie chart with parameter (parameters : gender)
Report 2: Details of each slice of pie chart in bar chart (parameters : gender, states)


Environment :
Jasper Server 5.5 pro
iReport : 5.5 pro
Database : Postgresql foodmart

Functionality :
Let's say your input control is 'F' for gender in report 1 and when you click on state CA slice of pie chart then the Report 2 should catch the gender and state parameters from Report 1 and display the data next to this report.
i.e., Drilling down the reports in single dashboard page with parameters passing.
Technique of using contentFrame_frame_2 as Hyperlink target with Report Execution as Hyperlink Type.

Report 1 Query :
SELECT distinct
state_province,
sum(unit_sales)
FROM customer c,
sales_fact_1997 sf7
where c.customer_id=sf7.customer_id and gender=$P{gender}
group by state_province

Report 1 Pie Chart Hyperlink properties
Hyperlink target : contentFrame_frame_2
Hyperlink type : ReportExecution

_report "/Sadha/Test/IPC2"
gender $P{gender}
state $F{state_province}
viewAsDashboardFrame "true"

Images for Report-1







Report 2 Query :
SELECT distinct city,sum(total_children) from customer where gender=$P{gender} and state_province=$P{state} group by city


Report 2 Sample Image


Dashboard Final Output:


NOTE:
1) No need of adding any js code as given in the link.
2) Just need to write "Hyperlink target"=contentFrame_frame_2
3) Hide the parameters where ever required. i.e., Un check visible.