Introduction

JasperReports is an open source Java reporting tool that can write to a variety of targets, such as: screen, a printer, into PDF, HTML, Microsoft Excel, RTF, ODT, comma-separated values (CSV) or XML files. It can be used in Java-enabled applications, including Java EE or web applications, to generate dynamic content.

Jaspersoft Studio is an Eclipse-based report designer for JasperReports Library and JasperReports Server; it's available as an Eclipse plug-in or as a stand-alone application. Jaspersoft Studio allows you to create sophisticated layouts containing charts, images, subreports, crosstabs, and more. You can access your data through a variety of sources including JDBC, TableModels, JavaBeans, XML, Hibernate, Big Data (such as Hive), CSV, XML/A, as well as custom sources, then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice. 

TIBCO JasperReports® Server builds on TIBCO JasperReports® Library as a comprehensive family of Business Intelligence (BI) products, providing robust static and interactive reporting, report server, and data analysis capabilities. These capabilities are available as either stand-alone products, or as part of an integrated end-to-end BI suite utilizing common metadata and provide shared services, such as security, a repository, and scheduling. The server exposes comprehensive public interfaces enabling seamless integration with other applications and the capability to easily add custom functionality.

What you will learn

This course is designed for students who already have at least a basic knowledge of SQL query language. Anybody without the prerequisite may follow the class, but need to expect not to fully grasp the concept present in the class.

Course Duration : 3 days

Module 1 : Getting Started With Jaspersoft Studio

1.1  Introduction to Jaspersoft Studio
1.2  Installing Jaspersoft Studio
 

Module 2  :  Creating A Simple Report

2.1  Creating a new report
2.2  Adding and deleting report elements
2.3  Previewing report
2.4  Creating a project folder
 

Module 3  : User Interface And Design View

3.1  Eclipse interface
3.2  User interface components
3.3  The design tab
3.4  Understanding bands
3.5  Specifying report properties
3.6  The preview tab
3.7  Exporting reports
 

Module 4  : Report Elements

4.1    Common element properties
4.2    Inserting, selecting and positioni9ng elements
4.3    Formatting elements
4.4    Working with advanced properties
4.5    Graphic elements
4.6    Text element
4.7    Frames
4.8    Inserting page and column breaks
4.9    Working with spreadsheet layout
4.10  Working with composite elements
4.11  Anchors, bookmarks, and hyperlinks
4.12  Advanced elements and custom components
 

Module 5  :  Fields

5.1  Understanding Fields
5.2  Registration of Fields from an SQL Query
5.3  Fields and Text Fields
5.4  Data Centric Exporters
 

Module 6  :  Parameters

6.1  Working With Parameters
6.2  Default Parameters
6.3  Using Parameters in Queries
6.4  Parameters Prompt
6.5  Parameter Sets
 

Module 7  :  Variables

7.1  Defining or Editing a Variable
7.2  Base Properties of a Variable
7.3  Other Properties of a Variable
7.4  Built-In Variables
7.5  Tips & Tricks

Module 8  :  Expressions

8.1  Expression Types
8.2  Expression Operators and Object Methods
8.3  Using an If-Else Construct in an Expression
8.4  Using Unicode Characters in Expressions
 

Module 9  :  Fonts

9.1  Font extensions reference
 

Module 10  :  Data Adapters

10.1  Creating and Editing Data Adapters
10.2  Using Data Adapters in Reports and Datasets
10.3  Working with Database JDBC Connections
10.4  Working with XML Data Adapters
 

Module 11  :  Creating Queries

11.1  Using the Dataset and Query Dialog
11.2  Working with the Query Builder
 

Module 12  :  Accessing Jasperreports Server From Jaspersoft Studio

12.1  Connecting to JasperReports Server
12.2  Configuring a Project for JasperReports Server
12.3  Publishing a Report to JasperReports Server
12.4  Working with JasperReports Server Templates
12.5  Creating and Uploading a Topic for Ad Hoc Views
12.6  Managing Repository Objects through Jaspersoft Studio
12.7  Creating and Uploading Chart Themes
12.8  Working with Domains
12.9  Understanding the repo: Syntax
12.10  Adding a Date/Time Stamp to Scheduled Output in JasperReports Server
 

Module 13  :  Working With Jasperreports Io

13.1  JasperReports IO Repository File System
13.2  JasperReports IO Report Execution Contexts
13.3  Testing Reports with JasperReports IO
 

Module 14  :  Datasets And Subdatasets

14.1  Understanding Datasets and Dataset Runs
14.2  Subdatasets
14.3  Dataset Runs
14.4  Creating an Example Subdataset
 

Module 15  :  Working With Tables

15.1  Creating a Table
15.2  Editing a Table
15.3  Table Structure
15.4  Working with Columns
 

Module 16  :  Working With Charts

16.1  Creating a Simple Chart
16.2  Setting Chart Properties
16.3  Spider Charts
16.4  Chart Themes
16.5  Chart Customizers
 

Module 17  :  Html5 Charts In Commercial Editions

17.1  Overview of HTML5 Charts
17.2  Example of a Bar Chart Using Simple Configuration
17.3  Example of a Pie Chart
17.4  Example of a Tree Map Using Multiple Levels and Advanced Formatting
17.5  Example of a Scatter Chart Using Advanced Configuration
17.6  Example of a Column-Spline Chart
17.7  Creating Hyperlinks in HTML5 Charts
17.8  Advanced Formatting of HTML5 Charts
 

Module 18  :  Working With Crosstabs

18.1  Example of Creating a Crosstab
18.2  Working with Crosstab Properties
18.3  Using the Crosstab Editor
18.4  Working with Crosstab Parameters
 

Module 19  :  Working With The Map Component

19.1  Working with Map Properties
19.2  Viewing Authentication Properties
19.3  Working with Markers
19.4  Working with Paths
19.5  Properties for Markers and Paths
 

Module 20  :  Working With Subreports

20.1  Creating a New Report via the Subreport Wizard
20.2  Understanding Subreports
 

Module 21  :  Report Templates

21.1  Template Structure
21.2  Creating and Customizing Templates
21.3  Saving Templates
21.4  Adding Templates to Jaspersoft Studio
 

Module 22  :  Report Books

22.1  Creating the Report Book Framework
22.2  Creating and Adding Reports to the Report Book
22.3  Refining the Report Book
22.4  Configuring the Table of Contents
22.5  Report Book Pagination
22.6  Publishing the Report Book