Passing Parameters from URL in ad hoc view
Posted on September 12, 2013 at 12:10am
In JasperServer, passing parameters to specific report through URL is working fine
where as in adhoc view same scenario is not working.
Please help me.
VV Nagesh Bodapati
Posted on September 25, 2013 at 6:01am
Please use this for empeding dashboard http://<host>:<port>/<context>/flow.html?_flowId=viewReportFlow&reportUnit=/supermart/Details/CustomerDashboard&hidden_customerID=4012
I hope it will help!
Siva | HCL
Posted on May 14, 2017 at 2:21pm
Hi, Not sure about dashboards and hidden parameters, but I was struggling pass a parameter into a report I had developed from an Ad Hoc view. I had a filter which I set up in the AdHoc view which I created the report from. This is the solution I found:
- export the report (right click>export).
- find the file: TopicJRXML in the zip file which downloads.
- find the parameter name of the relevant filter. Its in the first few lines of the code. In my case the field displayed as 'record_id'......the parameter name was actually 'record_id4_1'
- append the parameter to your URL using the name you found in the Topic file as follows (using my example): ......&record_id4_1=CRM-0000003
That worked for me. I haven't tried anything more complex like multi-selects or ranges, but I think it should work as per the guidance. Its just about finding the correct parameter name. Unfortunately it doesn't tell you when you have the URL wrong, just defaults to the saved version of the report, which I suppose is useful in some ways but not that helpful when trying to get this right.
Hope that helps, might point you in the right direction!