Drill Down Report Passing Same Value Regardless of What Section is Clicked

[michael.christ_1]

Hi.  Community Edition 6.19.0.  I created a main report that displays a pie chart.  The data source returns two values: VENDOR_ID and CNT.  For the hyperlink properties I defined:

• Link Target: Blank
• Link Type: ReportExecution
• Parameters:
  • _report: location of detail report
  • VENDOR_ID: $F{VENDOR_ID}

The detail report is a table. I defined:

• Input Control named VENDOR_ID
• Parameter named VENDOR_ID

I updated the SQL to include $P{VENDOR_ID}

Here's the problem.  When I run the main report I indeed can drill to the detail.  BUT no matter which pie slice I click, the same value is passed to the detail.  That value seems to be the last VENDOR_ID returned in the main report.

Does anyone have any ideas why the hyperlink to the detail report does not contain the value of the pie slice I click on?

Update: I solved this issue.  The solution is to click the hyperlink button that displays in the pie chart window and NOT in the properties window.

[Tom C]

You are setting the hyperlink for the entire chart. You need to instead set the hyperlink for the chart measure in order pass the slice value for that particular measure to a drill down report.

Refer to:

https://community.jaspersoft.com/wiki/html5-charts-measure-and-bucket-properties

 

Examples:

https://community.jaspersoft.com/wiki/how-do-i-set-chart-hyperlinks-html5-charts

https://community.jaspersoft.com/wiki/video-passing-multiple-values-pie-chart-slice-highcharts-through-hyperlink

 

[sadakar]

Would this be of any help ? an older post, but details the same concept that you are looking for. 

https://jasper-bi-suite.blogspot.com/2014/04/drill-down-functionality-example-on.html