Drill-Down JasperReports, QueryReports, and ChartReports
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.
2 comments October 5th, 2006
