I've created 2 different ad hoc tables via the web designer, but want to be able to click on a cell in one and have it open the other and pass it a value for the filter. To do that I've opened the adhoc report in JasperStudio and added this Hyperlink:
The $F{_detail_level__Site} appears to be the value I want in the initial report to be passed in as the Site_1 value in the other report. I've verified that if I manually enter a known value that the paramter in the target report works. But when I try to use the field reference then the URL that ends up being opened on click is
Adding Hyperlinks between two Ad Hoc table reports and passing parameters
in Products
Posted
I've created 2 different ad hoc tables via the web designer, but want to be able to click on a cell in one and have it open the other and pass it a value for the filter. To do that I've opened the adhoc report in JasperStudio and added this Hyperlink:
"https://zrs.zenguru.info/jasperserver-pro/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2Freports%2FZENguru_Reports&reportUnit=%2Freports%2FZENguru_Reports%2FLocal_Admins_Report&standAlone=true&Site_1=$F{_detail_level__Site}"
The $F{_detail_level__Site} appears to be the value I want in the initial report to be passed in as the Site_1 value in the other report. I've verified that if I manually enter a known value that the paramter in the target report works. But when I try to use the field reference then the URL that ends up being opened on click is
https://zrs.zenguru.info/jasperserver-pro/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2Freports%2FZENguru_Reports&reportUnit=%2Freports%2FZENguru_Reports%2FLocal_Admins_Report&standAlone=true&Site_1=((java.lang.String)field__detail_level__Site.getValue())
How do I get it to pass the value of the field instead of ((java.lang.String)field__detail_level__Site.getValue())