Open Intelligence

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