Adding Hyperlinks between two Ad Hoc table reports and passing parameters

[boredinahotelgmail.com]

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())

 

 

 

[kkumlien]

Currently hyperlinks are not supported in Ad Hoc Crosstabs and Tables, but only Charts. Editing Ad Hoc Reports in Studio is not supported either and is bound to produce unpredictable results.

It is recommended to embed the Ad Hoc Views directly (rather than the Ad Hoc Reports) with Visualize.js and use JavaScript "click events" to implement a drill through between the two Views – potentially displayed in the same page. Some hyperlink examples here:

https://tibcosoftware.github.io/js-visualize/#hyperlinks-3

A direct link for the first one in the list "Pass values": https://jsfiddle.net/gh/get/jQuery/3.4.1/tibcosoftware/JS-visualize/tree/master/ahv-hyperlink/pass-values/

It doesn't create a link but it shows how to capture the click event. The other examples there show actual drill-through's, but on Charts. The two approaches can be combined to obtain what you need.