Creating a New Report

This documentation is an older version of Jaspersoft Studio User Guide 8.2.0. View the latest documentation.

Getting Started with Jaspersoft Studio
- Introduction
- Installing Jaspersoft Studio
Creating a Simple Report
- Creating a New Report
- Adding and Deleting Report Elements
- Previewing a Report
- Creating a Project Folder
User Interface and Design View
- The Design Tab
- The Preview Tab
- The Design Tab
- The Design Tab
- Exporting Reports with Jaspersoft Studio
Report Elements
- Common Element Properties
- Inserting, Selecting, and Positioning Elements
- Formatting Elements
- Working with Advanced Properties
- Graphic Elements
- Text Elements
- Frames
- Working with Spreadsheet Layout
- Frames
- Working with Composite Elements
- Anchors, Bookmarks, and Hyperlinks
- Advanced Elements and Custom Components
- Custom Visualization Component
Fields
- Understanding Fields
- Registration of Fields from a SQL Query
- Registration of JavaBean Fields
- Fields and Textfields
- Data Centric Exporters
Parameters
- Managing Parameters
- Default Parameters
- Using Parameters in Queries
- Parameters Prompt
- Parameter Sets
Variables
- Defining or Editing a Variable
- Base Properties of a Variable
- Other Properties of a Variable
- Built-In Variables
- Tips & Tricks
Expressions
- Using Unicode Characters in Expressions
- Using Java as a Language for Expressions
- Using Groovy as a Language for Expressions
- Using JavaScript as a Language for Expressions
Fonts
- Working with Font Extensions
Data Adapters
- Creating and Editing Data Adapters
- Using Data Adapters in Reports and Datasets
- Working with Database JDBC Connections
- Working with a MongoDB Data Adapter
- Working with a Google BigQuery Data Adapter
- Working with a Collection of JavaBeans Data Adapter
- Using XML Data Adapters
- Using XMLA/Data Adapters
- Using CSV Data Sources
- Connecting to a Web Service Using a JSON Data Adapter
- Using the Empty Record Data Adapter
- Using the Random Data Adapter
- Working with the JRDataSource Interface
- A Look at TIBCO Spotfire Information Links
Creating Queries
- Using the Dataset and Query Dialog
- Working with the Query Builder
Accessing JasperReports Server from Jaspersoft Studio
- Connecting to JasperReports Server
- Configuring a Project for JasperReports Server
- Publishing a Report to JasperReports Server
- Publishing a Report Template
- Creating and Uploading a Topic for Ad Hoc Views
- Managing Repository Objects through Jaspersoft Studio
- Working with Domains
- Understanding the repo Syntax
- Adding a Date/Time Stamp to Scheduled Output
Working with JasperReports IO
- JasperReports IO Repository File System
- JasperReports IO Report Execution Contexts
- Testing Reports with JasperReports IO
Datasets and Subdatasets
- Creating an Example Subdataset
Report Bursting and Report Splitting
- Report Splitting
Working with Tables
- Creating a Table
- Editing a Table
- Table Structure
- Working with Columns
Working with Charts
- Creating a Simple Chart
- Setting Chart Properties
- Spider Charts
- Chart Themes
- Chart Customizers
HTML5 Charts in Commercial Editions
- Overview of HTML5 Charts
- Example of a Simple HTML5 Chart
- Example of a Pie Chart
- Example of a Tile Map Chart
- Example of a Time-Series Spline Chart
- Example of a Tree Map Using Multiple Levels and Advanced Formatting
- Example of a Scatter Chart Using Advanced Configuration
- Dual-Axis, Multi-Axis, and Combination Charts
- Creating Hyperlinks in HTML5 Charts
  - Working with Report Units
- Advanced Formatting of HTML5 Charts
- Setting Advanced Options for HTML5 Charts in Properties View
- Master-detail Chart
Working with Crosstabs
Working With the Map Component
Working with TIBCO GeoAnalytics Maps
Working With HTML5 Map Components
- Chart Data Set
Working with Subreports
- Creating a New Report via the Subreport Wizard
- Understanding Subreports
- Creating drill-down report
Report Templates
- Template Structure
- Creating and Customizing Templates
- Saving Templates
- Adding Templates to Jaspersoft Studio
- Report Splitting
Report Books
- Creating the Report Book Framework
- Creating and Adding Reports to the Report Book
- Refining the Report Book
- Configuring the Table of Contents
- Report Book Pagination
- Publishing the Report Book
Properties and Configuration
- Units of Measure in Jaspersoft Studio
- Cleaning Cached Data
- Disabling Usage Statistics
- Export and Import
- Setting Compatibility with Earlier Versions of JasperReports Library
- Working with Java in Eclipse
- Using Data Snapshots
Concepts of JasperReports
- JRXML Sources and Jasper Files
- Data Sources and Print Formats
- Project Folder Types and Report Execution Contexts
- Using JasperReports Extensions in Jaspersoft Studio
- A Simple Program
Glossary
About This Guide

To create a new report:

Go to File > New > Jasper Report or click

The New Report Wizard window displays the Report Templates page. Jaspersoft Studio includes a number of pre-installed templates; you can also create your own. See Report Templates for more information.

New Report Wizard

Select the Coffee template and click Next. The New Report Wizard shows the Report file page.

New Report Wizard > Report file

Navigate to the folder you want the report in and name the report. To create a new folder, see Creating a Project Folder.

Click Next.

The New Report Wizard displays the Data Source page. This is where you choose the data that will fill the report.The drop-down menu shows the pre-installed data adapters as well any data adapters you have added. The following adapters are pre-installed:

•

One Empty Record - Empty rows: Data adapter that lets you create a report without data. You might use this option to define the layout of a report and connect it to a data source later.

•

Sample DB - Database JDBC Connection: Data adapter that connects to an SQL database provided with the Jaspersoft Studio installation. If you are getting your data from a JDBC database, you must also supply an SQL query.

You can create a data adapter separately or click New... to create a data adapter directly from this dialog. Adapters can be created globally (embedded in the workspace) or local to a specific project. Using a local adapter makes it easier to deploy the report to JasperReports Server. See Creating and Editing Data Adapters for more information.

Choose Sample DB - Database JDBC Connection. With a JDBC connection, the Data Source dialog shows the database schema on the left and your query on the right.

New Report Wizard > Data Source

Enter the query SELECT * FROM ORDERS on the right. Note that you can view your query in three different ways: as text, as an outline, or as a diagram.

Click Next. The Fields window is displayed. The Dataset list shows all the discovered fields.