Chapter 1 Getting Started with Jaspersoft Studio
1.1 Introduction to Jaspersoft Studio
1.2 User Interface
1.3 Hardware Requirements
1.4 Software Requirements
1.5 Accessing the Source Code
1.6 Report Structure in Jaspersoft Studio
1.6.1 The Report Lifecycle
1.6.2 Understanding Bands
1.6.3 Band Types
1.6.4 Specifying Report Properties
1.6.5 Columns
1.6.6 Advanced Options
1.7 Measure Units in Jaspersoft Studio
1.7.1 Configuration
1.7.2 Changing the Field Measure Unit
1.7.3 Alias and Autocomplete
1.7.4 Approximations
1.8 Exporting reports with Jaspersoft Studio
1.8.1 Compiling the Report
1.8.2 Preview and Exporting
Chapter 2 Concepts of JasperReports
2.1 JRXML Sources and Jasper Files
2.2 Data Sources and Print Formats
2.3 Expressions
2.3.1 The Type of an Expression
2.3.2 Expression Operators and Object Methods
2.3.3 Using an If-Else Construct in an Expression
2.4 Using Java as a Language for Expressions
2.5 Using Groovy as a Language for Expressions
2.6 Using JavaScript as a Language for Expressions
2.7 Using JasperReports Extensions in Jaspersoft Studio
2.8 A Simple Program
Chapter 3 Report Elements
3.1 Basic Element Attributes
3.2 Inserting, Selecting, and Positioning Elements
3.2.1 Inserting Elements
3.2.2 Selecting Elements
3.2.3 Positioning Elements
3.3 Formatting Elements
3.4 Graphic Elements
3.4.1 Line
3.4.2 Rectangle and Ellipse
3.4.3 Images
3.4.4 Padding and Borders
3.5 Text Elements
3.5.1 Static Text
3.5.2 Text Fields
3.6 Using Frames
3.7 Inserting Page and Column Breaks
3.8 Anchors, Bookmarks, and Hyperlinks
3.8.1 Anchors and Bookmarks
3.8.2 Overview of Hyperlink configuration
3.8.3 Hyperlink Types
3.8.4 Defining Hyperlinks
3.8.5 Hyperlink Parameters
3.8.6 Hyperlink Tooltips
3.8.7 Working with Report Units
3.9 Hyperlinks in HTML5 Charts
3.9.1 Creating Hyperlinks in HTML5 Charts
3.9.2 Working with Bucket Properties and Hidden Measures
3.10 Subreports
3.11 Advanced Elements and Custom Components
Chapter 4 Creating a Simple Report
4.1 Creating a New Report
4.2 Adding and Deleting Report Elements
4.2.1 Adding Fields to a Report
4.2.2 Deleting Fields
4.2.3 Adding Other Elements
4.3 Previewing a Report
4.4 Creating a Project Folder
Chapter 5 Connecting Jaspersoft Studio to JasperReports Server
5.1 Prerequisites
5.2 Connecting Jaspersoft Studio to JasperReports Server
5.3 Publishing a Report to JasperReports Server
5.4 Creating a Topic for JasperReports Server Ad Hoc Views
Chapter 6 Working with Fields
6.1 Understanding Fields
6.2 Registration of Fields from a SQL Query
6.3 Registration of JavaBean Fields
6.4 Fields and Textfields
Chapter 7 Report Templates
7.1 Template Structure
7.2 Creating and Customizing Templates
7.2.1 Creating a New Template
7.2.2 Customizing a Template
7.3 Saving Templates
7.3.1 Creating a Template Directory
7.3.2 Exporting a Template
7.3.3 Creating a Template Thumbnail
7.4 Adding Templates to Jaspersoft Studio
Chapter 8 Using Parameters
8.1 Managing Parameters
8.2 Default Parameters
8.3 Using Parameters in Queries
8.3.1 Using Parameters in a SQL Query
8.3.2 Using Parameters with Null Values
8.3.3 IN and NOTIN Clauses
8.3.4 Relative Dates
8.3.5 Passing Parameters from a Program
8.4 Parameters Prompt
Chapter 9 Variables
9.1 Defining a New Variable or Editing an Existing One
9.2 Base Properties of a Variable
9.3 Other Properties of a Variable
9.3.1 Evaluation Time
9.3.2 Calculation Function
9.3.3 Increment Type
9.3.4 Reset Type
9.3.5 Incrementer Factory Class Name
9.4 Built-In Variables
9.5 Tips & Tricks
Chapter 10 Data Sources
10.1 Data Adapters
10.2 Creating and Using Database JDBC Connections
10.2.1 ClassNotFoundError
10.2.2 URL Not Correct
10.2.3 Parameters Not Correct for the Connection
10.3 Working with Your JDBC Connection
10.3.1 Fields Registration
10.3.2 Filtering Records
10.4 Understanding the JRDataSource Interface
10.5 Data Source Types
10.5.1 Using Collection of JavaBeans Data Sources
10.5.2 Fields of a JavaBean Set Data Source
10.5.3 Using XML Data Adapters
10.5.4 Registration of the Fields for an XML Data Source
10.5.5 XML Data Source and Subreports
10.5.6 Using XML/A Data Adapters
10.5.7 Registration of fields in XML/A Providers
10.5.8 Using CSV Data Sources
10.5.9 Registration of the Fields for a CSV Data Source
10.5.10 Using JREmptyDataSource
10.5.11 Using HQL and Hibernate Connections
10.5.12 Using a Hadoop Hive Connection
10.5.13 Implementing a New JRDataSource
10.5.14 Using a Custom JasperReports Data Source with Jaspersoft Studio
10.6 Importing and Exporting Data Sources
Chapter 11 Using Tables
11.1 Creating a Table
11.2 Editing a Table
11.2.1 Editing Table Styles
11.2.2 Editing Cell Contents
11.2.3 Editing Table Data
11.3 Table Structure
11.3.1 Table Elements
11.3.2 Table Cells
11.4 Working with Columns
11.4.1 Column Groups
Chapter 12 Working with Charts
12.1 Datasets
12.1.1 Creating a Dataset
12.2 Creating a Simple Chart
12.3 Setting Chart Properties
12.4 Spider Charts
12.5 Chart Themes
12.5.1 Using the Chart Theme Designer
12.5.2 Editing Chart Theme XML
12.5.3 Creating a JasperReports Extension for a Chart Theme
12.5.4 Applying a Chart Theme
Chapter 13 Additional Chart Options in Commercial Editions
13.1 Overview of HTML5 Charts
13.2 Simple HTML5 Charts
13.2.1 Creating an HTML5 chart
13.2.2 Editing HTML5 Charts
13.2.3 Creating Hyperlinks
13.3 Scatter Charts
13.4 Dual-Axis, Multi-Axis, and Combination Charts
Chapter 14 Using the Dataset and Query Dialog and the Query Builder
14.1 Using the Dataset and Query Dialog
14.2 Working with the Query Builder
14.2.1 Query Outline View and Diagram View
14.2.2 Selecting columns
14.2.3 Joining tables
14.2.4 Data selection criteria (WHERE conditions)
14.2.5 Acquiring fields
14.2.6 Data Preview
Glossary
Index