Description

This training will introduce you to the functionalities and possibilities of the Jasper Report tool, an Open Source report generation solution. You will learn how to design, structure and publish sophisticated documents that will allow you to effectively analyze your organization's data and activities.

Who is this training for ?

For whom ?

This course is intended for consultants, project managers and analysts wishing to implement a reliable open source reporting solution.

Prerequisites

Training objectives

Install the Jasper Report solution and the iReport tool

Configure the data source of a report

Understand the basic structure and objects that make up a Jasper Reports report

Design a simple report from a data source

Develop a more advanced report with crosstabs and subreports

Run and publish a report to the web

Training program

• Presentation
  • The interests of reports.
  • Problems of generating reports.
  • State of the art, Open Source solutions.
  • L 'JaperSoft offer: JasperReport, iReport, Query Designer.
  • Reminders of the basics of XML.
  • The usefulness of XML for using the Jasper Reports solution.
• Jasper Report, getting started
  • Prerequisites and installation procedure.
  • Tools overview: iReport overview.
  • Supported data sources.
  • Declaring data sources.
  • SQL queries, sorts and filters.
  • Analysis of sample reports.
  • Report generation process states.
  • Compilation.
  • Main elements of a file.
  • jrxml.
  • Practical work Installation of the solution Jasper Report, iReport and demos.
  • Configuring a data source from a database.
• Report design
  • Structure of a report: sections, bands, columns.
  • Fields in a report: declaration, types, rules.
  • The different elements: text, image, graphic shapes.
  • Parameters, expressions and variables.
  • Formatting a report.
  • Formatting a report.
  • Styles and templates.
  • Practical work Designing a simple report from a data source.
• Advanced design elements
  • Groups: principle, nesting, page breaks.
  • Subreports: principle, sizing, referencing.
  • Graphs and pivot tables: datasets, dataset run, OLAP.
  • Practical work Design of an advanced report with crosstabs and sub-reports.
• Publication of reports
  • The JasperServer solution: iReport plugin, Report repository.
  • JasperServer installation procedure.
  • Web server and database configuration.
  • Running reports.
  • Import and export functions.