Drill-Down JasperReports, QueryReports, and ChartReports
October 5th, 2006
OpenReports provides the ability to add drill down capabilites to JasperReports and QueryReports through the use of the executeReport.action. The basic concept is to add a link to the report pointing to the executeReport.action and providing the parameters needed to run the report.
To add a drill-down link to a QueryReport, you must create a QueryReport Template and add an HREF column to your report. Take a look at CustomerListWithTemplate.vm for a detailed example of a QueryReport Template with multiple drill-down links.
In a JasperReport, it would be a hyperlinkReferenceExpression pointing to the executeReport.action URL. The OPENREPORTS_EXPORT_TYPE parameter can be added to the expression so that the appropriate export type is passed to the drill-down report. This technique works with JasperReports exported to PDF or HTML formats.
OpenReports Professional also provides to ability to create drill-downChartReports that give users the ability to drill down on a specific bar, segment, or slice in Bar, Ring, or Pie charts. Drill-down ChartReports can be defined entirely from the OpenReports Professional administration console without the need for a report template.
Entry Filed under: All
2 Comments
1. Cobus Benard | April 17th, 2007 at 3:31 pm
Any chance of getting a more newbie related guide to this – I’m completely lost at the moment regarding the uploading – am I correct in saying that you can only upload .jasper files, or can I upload .vm files? If .vm is possible, how – my setup simply ignores the file I try to upload.
2. Meiren | March 20th, 2008 at 8:09 pm
What you said here is exactly what I need, could you please give more details on how the drill down is done in Jasper, other than configure the hyperlink in jasper report, what do you need to do in Open report to pass the parameter to the jasper report?
Another question, can you modify the setting for jasper report inside open report?
Thanks in advance.
Trackback this post