Skip to content

Latest commit

 

History

History
50 lines (33 loc) · 3.1 KB

README.MD

File metadata and controls

50 lines (33 loc) · 3.1 KB
Raw

Plugins to integrate jasper reports and pentaho

This repository contains the code of a pentaho plugin to integrate jasperreports inside pentaho bussiness server, a Jasper Reports plugin with a datasource to access Pentaho Data Access datasources, and a Jasper Studio Plugin to include a CDA datasource inside Jasper Design

Features:

  • Load a CDA datasource inside Jasper Studio
  • Execute a CDA from a Pentaho Bussiness Server
  • Map the CDA Parameters from any expression
  • Load jrxml and jasper Files inside Pendaho Bussiness Server

Build

Jasper Reports CDA Datasource

Before build the other plugins, is necessary to build the datasource plugin. You can do it executing maven install from the folder pentaho-cda-datasource

Jasper Studio Plugin

  1. Follow the instructions to download the code from Build Sources. The minimum version to compile are Jasper Studio 6.4.1 and Eclipse 4.6+
  2. Clone the code from this repository inside your eclipse workspace
  3. Download the required libraries executing maven process-resources, to make this Tycho should be properly configured.
  4. You can use Tycho to compile the plugin or you can debug directly from eclipse workspace

Pentaho Plugin

From the pentaho-jasperreports-plugin folder execute maven package to build a zip. To install the plugin you can extract the zip file inside pentaho solutions folder. PENTAHO_SERVER_HOME/pentaho-solutions/system

Jasper Studio Usage

  1. Create a new Data Adapter using the Pentaho CDA Connection option DataAdapterWizard01

  2. Set the configuration, if your pentaho server is 5.x+ the 5.x option should be checked. You can test the connection clicking the test button. The cda plugin should be installed inside the pentaho bussiness server DataAdapterWizard02

  3. When you edit a datasource, select the connection you've created and PentahoCdaQuery as language DatasetAndQuery01

  4. Click on browse to select a CDA File. Using double click, you can see a folder's content DatasetAndQuery02

  5. Select a Query, clicking inside the Query table. DatasetAndQuery03

  6. To edit the parameter values, you can click inside the value cell and then click on "..." button DatasetAndQuery04

  7. Click on Read Fields to load all the columns from the datasource DatasetAndQuery06