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.
Drill Down Report Passing Same Value Regardless of What Section is Clicked
in Products
Posted
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:
The detail report is a table. I defined:
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.