Creating a New Report - 8.2.0 - Jaspersoft Community

Jump to content

We've recently updated our Privacy Statement, available here ×

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

Getting Started with Jaspersoft Studio
Introduction
Installing Jaspersoft Studio
- Requirements
- Available Packages
- Installing a New License File
- Updating Your Workspace
- Compatibility Between Versions
- Accessing the Source Code
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
- User Interface and Design View
- The Design Tab
- The Preview Tab
- The Design Tab
  - The Design Tab
- The Design Tab
  - The Design Tab
  - The Design Tab
- Exporting Reports with Jaspersoft Studio
  - Exporting Reports with Jaspersoft Studio
  - 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
  - Text Elements
  - Text Elements
- Frames
- Working with Spreadsheet Layout
- Frames
- Working with Composite Elements
  - Working with Composite Elements
  - 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
- Expression Types
- Expression Operators and Object Methods
- Using Unicode Characters in Expressions
- Using an If-Else Construct in an Expression
- 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
  - Creating a Native MongoDB Connection
  - Creating a MongoDB JDBC Data Source
- Working with a Google BigQuery Data Adapter
- Working with a Collection of JavaBeans Data Adapter
  - Registering Fields
- Using XML Data Adapters
- Using XMLA/Data Adapters
- Using CSV Data Sources
  - Registration of the Fields for a CSV Data Source
- Connecting to a Web Service Using a JSON Data Adapter
- Using the Empty Record Data Adapter
  - Understanding the Empty Record Implementation
- 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
- Bursting Scriptlet
- Bursting a Report
Working with Tables
- Creating a Table
- Editing a Table
- Table Structure
  - Table Elements
  - Table Cells
- Working with Columns
  - Column Groups
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
- Advanced Formatting of HTML5 Charts
- Setting Advanced Options for HTML5 Charts in Properties View
- Master-detail Chart
Working with Crosstabs
- Working with Crosstabs
- Working with Crosstabs
- Working with Crosstabs
- Working with Crosstabs
Working With the Map Component
Working with TIBCO GeoAnalytics Maps
- Working with TIBCO GeoAnalytics Maps
- Working with TIBCO GeoAnalytics Maps
- Working with TIBCO GeoAnalytics Maps
- Working with TIBCO GeoAnalytics Maps
- 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
Report Templates
- Template Structure
- Creating and Customizing Templates
  - Creating a New Template
  - Customizing a Template
- Saving Templates
- Adding Templates to Jaspersoft Studio
Report Books
- Creating the Report Book Framework
- Creating and Adding Reports to the Report Book
  - Creating a Report for the Report Book
  - Adding a Report to the Report Book
- Refining the Report Book
  - Sorting on Additional Fields
  - Adding Section Introductory Pages
- 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

Creating a New Report

To create a new report:

1.

Go to File > New > Jasper Report or click

on the main toolbar.

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

2.

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

New Report Wizard > Report file

3.

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

4.

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.

5.

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

6.

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.

7.

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

New Report Wizard > Fields

8.

Select the following fields and click the right arrow to add them to your report.

•

ORDERID

•

SHIPNAME

•

SHIPADDRESS

•

SHIPCITY

•

SHIPREGION

9.

Click Next. The Grouping window is displayed. You do not want any grouping for this report.

10.

Click Next and Finish.

Jaspersoft Studio now builds the report layout with the selected fields included as shown.

New Report in the Design Tab

Share

Go to documents

User Feedback

0 Comments

Recommended Comments

There are no comments to display.

×

×

Create New...