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 Queries

Jaspersoft Studio provides tools to help you define report fields and create a proper query (if a query is needed to fetch the report data). You'll find these tools in the Dataset and Query dialog.

It also provides a drag-and-drop query builder for easily creating SQL queries. This allows users who aren't familiar with SQL to quickly join tables and produce complex data filters and where conditions. SQL Builder also provides a way for skilled users to explore the database and list the metadata such as schemas and available tables.

This chapter contains the following sections:

•

Using the Dataset and Query Dialog

•

Working with the Query Builder

Share

Go to documents

User Feedback

0 Comments

Recommended Comments

There are no comments to display.

×

×

Create New...