Data Sources and Print Formats - 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

Data Sources and Print Formats

Without a means of supplying content from a dynamic data source, even the most sophisticated and appealing report would be useless. JasperReports gives you two ways to specify fill data for the output report: parameters and data sources. Both kinds of data are presented by means of a generic interface named JRDataSource.

Data Source and Parameter Flows for Report Creation

JRDataSource allows a set of records organized in tables (rows and columns) to be read. It enables JasperReports to fill a report with data from an explicit data source, using a JDBC connection (already instanced and opened) to whichever relational database you want to run an SQL query on (which is specified in the report).

If the data don't meet your requirements, you may need to specify values to condition the report’s execution; you can create name/value pairs to pass to the print engine. These pairs are named parameters, and they have to be preventatively declared in the report. Through fillManager, you can join a jasper file and a data source in a JasperPrint object. This object is a meta-print that can create a real print after you export it in the format of your choice through appropriate classes that implement the JRExporter interface.

JasperReports give you pre-defined exporters, such as those for creating files formatted as pdf, xls, CVS, XML, RTF, ODF, text, HTML and SWF. Through the JRViewer class, you can view the print directly on the screen and print a hard copy.

Share

Go to documents

User Feedback

0 Comments

Recommended Comments

There are no comments to display.

×

×

Create New...