Versions Compared

Old Version 5

changes.mady.by.user Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Hugo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

Introduction

The JasperReports Userview Menu is a userview plugin that allows more complex reporting requirements through integration with JasperReports. By using JasperReports report definitions, sophisticated reports with custom layouts and graphs can be generated and viewed directly within a userview, with optional export to PDF and Excel.

...

What is JasperReports?

JasperReports is one of the most popular open source reporting engines. It is written in Java to be cross-platform, and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
http://community.jaspersoft.com/project/jasperreports-library

...

What is iReport Designer?

iReport is a powerful graphical design tool for report designers and power users to define reports for execution using the JasperReports engine.
http://community.jaspersoft.com/project/ireport-designer
There are community and enterprise versions for both JasperReports and iReport Designer, depending on your needs.

How to Use the JasperReports Userview Menu

1. Design Report

...

Using the iReport Designer

...

  1. Download and install iReport Designer from http://community.jaspersoft.com/project/ireport-designer.
  2. Get started with iReport Designer to design your report. Documentation on getting started is available at http://community.jaspersoft.com/wiki/getting-started-ireport-designer.

  3. Once the report has been designed, switch to the XML View to view the source XML definition. Copy this the XML. You can also save the report as a .jrxml file and open the file to copy the contents.

2. Add the JasperReports Menu in the Userview

  1. In the Joget Workflow web console, launch the Userview Builder for the desired userview in your app.
  2. Drag the JasperReports Menu element into the desired menu location in the userview.

3. Configure the JasperReports Menu

Click on Edit , and configure the properties in the property dialog, as follows: 



Configure JasperReports

Custom ID

Optional ID to represent this element; otherwise, else a system generated ID will be created. Recommended that this is entered as this ID (It is recommended that you enter this ID as it will be seen in the userview URL.)

Label

Label Name displayed in the userview menu

Default Output

Preselected output (Only HTML is available at this time.)

Export Options

Check to allow Allows the report to be exported into to PDF and/or Excel formats when checked

JasperReports Definition (JRXML)

The XML definition of the report designed using iReport Designer . (Copy the XML from the “XML View” tab in iReport , or directly from the .jrxml file contents.)


Configure Datasource

Datasource

This is an The option of either Default Datasource (which uses the current Joget database), or Custom Datasource (which allows you to key in custom database connection details. )


Configure Custom Database

JDBC Driver

The JDBC driver for the desired database

JDBC URL

The JDBC connection URL to the desired database

JDBC Username

The database Database connection username

JDBC Password

The database Database connection password


UI

Custom Header

Optional custom header content to be displayed at the top of the report .

Custom Footer

Optional custom footer content to be displayed at the bottom of the report


Configure Report Parameters

Image Added
Parameters allow you to pass in value to your JasperReport's parameter by using Hash Variables. 

4. View the JasperReports Menu

Once the configuration has been done, the report will be generated when the userview Userview menu page is accessed.