TIBCO Jaspersoft Studio User Guide

• Chapter 1 Getting Started with Jaspersoft Studio
  • 1.1 Introduction to Jaspersoft Studio
  • 1.2 Installing Jaspersoft Studio
    • 1.2.1 Software Requirements
    • 1.2.2 Hardware Requirements
    • 1.2.3 Available Packages
    • 1.2.4 Updating Your Workspace to Jaspersoft Studio 6.2 and Higher
    • 1.2.5 Compatibility Between Versions
    • 1.2.6 Accessing the Source Code
• Chapter 2 Creating a Simple Report
  • 2.1 Creating a New Report
  • 2.2 Adding and Deleting Report Elements
    • 2.2.1 Adding Fields to a Report
    • 2.2.2 Deleting Fields
    • 2.2.3 Adding Other Elements
  • 2.3 Previewing a Report
  • 2.4 Creating a Project Folder
• Chapter 3 User Interface and Design View
  • 3.1 Eclipse Interface
    • 3.1.1 Learning More About Eclipse
  • 3.2 User Interface Components
  • 3.3 The Design Tab
  • 3.4 Understanding Bands
    • 3.4.1 Band Types
  • 3.5 Specifying Report Properties
    • 3.5.1 Columns
    • 3.5.2 Advanced Options
  • 3.6 Exporting Reports with Jaspersoft Studio
    • 3.6.1 Compiling the Report
    • 3.6.2 Preview and Exporting
    • 3.6.3 Choosing Report Templates for PDF
• Chapter 4 Report Elements
  • 4.1 Common Element Properties
    • 4.1.1 The Palette
    • 4.1.2 Element Properties
  • 4.2 Inserting, Selecting, and Positioning Elements
    • 4.2.1 Inserting Elements
    • 4.2.2 Selecting Elements
    • 4.2.3 Positioning Elements
    • 4.2.4 Positioning Elements in Containers
  • 4.3 Formatting Elements
  • 4.4 Graphic Elements
    • 4.4.1 Line
    • 4.4.2 Rectangle and Ellipse
    • 4.4.3 Images
    • 4.4.4 Padding and Borders
  • 4.5 Text Elements
    • 4.5.1 Static Text
    • 4.5.2 Text Fields
  • 4.6 Frames
  • 4.7 Inserting Page and Column Breaks
  • 4.8 Working with Composite Elements
    • 4.8.1 Creating and Editing Composite Elements
    • 4.8.2 Exporting and Importing Composite Elements
  • 4.9 Anchors, Bookmarks, and Hyperlinks
    • 4.9.1 Anchors and Bookmarks
    • 4.9.2 Hyperlinks
    • 4.9.3 Hyperlink Types
    • 4.9.4 Creating a Hyperlink
  • 4.10 Advanced Elements and Custom Components
  • 4.11 Custom Visualization Component
• Chapter 5 Fields
  • 5.1 Understanding Fields
  • 5.2 Registration of Fields from a SQL Query
  • 5.3 Registration of JavaBean Fields
  • 5.4 Fields and Text Fields
  • 5.5 Data Centric Exporters
    • 5.5.1 Configuring a Report's Metadata for PDF 508 Tags
    • 5.5.2 Configuring a Report's Metadata for Use With the JSON Data Exporter
• Chapter 6 Parameters
  • 6.1 Managing Parameters
  • 6.2 Default Parameters
  • 6.3 Using Parameters in Queries
    • 6.3.1 Using Parameters in a SQL Query
    • 6.3.2 Using Parameters with Null Values
    • 6.3.3 IN and NOTIN Clauses
    • 6.3.4 Relative Dates
    • 6.3.5 Passing Parameters from a Program
  • 6.4 Parameters Prompt
• Chapter 7 Variables
  • 7.1 Defining or Editing a Variable
  • 7.2 Base Properties of a Variable
  • 7.3 Other Properties of a Variable
    • 7.3.1 Evaluation Time
    • 7.3.2 Calculation Function
    • 7.3.3 Increment Type
    • 7.3.4 Reset Type
    • 7.3.5 Incrementer Factory Class Name
  • 7.4 Built-In Variables
  • 7.5 Tips & Tricks
• Chapter 8 Expressions
  • 8.1 Expression Types
  • 8.2 Expression Operators and Object Methods
  • 8.3 Using an If-Else Construct in an Expression
  • 8.4 Using Unicode Characters in Expressions
  • 8.5 Using Java as a Language for Expressions
  • 8.6 Using Groovy as a Language for Expressions
  • 8.7 Using JavaScript as a Language for Expressions
• Chapter 9 Fonts
  • 9.1 Font Extensions Reference
    • 9.1.1 The Fonts Page
    • 9.1.2 The Font Family Dialog
    • 9.1.3 Font Sets
  • 9.2 Example of Using Font Extensions
    • 9.2.1 Creating Font Extensions and Font Sets
    • 9.2.2 Using Font Extensions in a Report
  • 9.3 Deploying Font Extensions to JasperReports Server
• Chapter 10 Data Adapters
  • 10.1 Creating and Editing Data Adapters
    • 10.1.1 Creating a Data Adapter
    • 10.1.2 Importing and Exporting Data Adapters
    • 10.1.3 Copying a Data Adapter
  • 10.2 Using Data Adapters in Reports and Datasets
    • 10.2.1 Data Adapter For a Report
    • 10.2.2 Data Adapters and Report Deployment
    • 10.2.3 Default Data Adapter
  • 10.3 Working with Database JDBC Connections
    • 10.3.1 Creating a Database JDBC Connection
    • 10.3.2 Troubleshooting a Database JDBC Connection
    • 10.3.3 Using a Database JDBC Connection
  • 10.4 Working with a MongoDB Data Adapter
    • 10.4.1 Creating a Native MongoDB Connection
    • 10.4.2 Creating a MongoDB JDBC Data Source
  • 10.5 Working with a Native Cassandra Connection
    • 10.5.1 Creating a Native Cassandra Data Adapter
    • 10.5.2 Using a Cassandra Connection
  • 10.6 Working with a Collection of JavaBeans Data Adapter
    • 10.6.1 Implementing the Factory Class for a Collection of JavaBeans
    • 10.6.2 Creating a Data Adapter from a Factory Class
    • 10.6.3 Registering the Fields
  • 10.7 Working with XML Data Adapters
    • 10.7.1 Creating a Node Set for an XML Document
    • 10.7.2 Creating an XML Data Adapter
    • 10.7.3 Registration of Fields for an XML Data Adapter
    • 10.7.4 XML Data Adapters and Subreports
  • 10.8 Working with XML/A Data Adapters
    • 10.8.1 Registration of fields in XML/A Providers
  • 10.9 Working with CSV Data Adapters
    • 10.9.1 Registration of the Fields for a CSV Data Adapter
  • 10.10 Using the Empty Record Data Adapter
    • 10.10.1 Understanding the Empty Record Implementation
  • 10.11 Working with the JRDataSource Interface
    • 10.11.1 Understanding the JRDataSource Interface
    • 10.11.2 Implementing a New JRDataSource
    • 10.11.3 Using a Custom JasperReports Data Source with Jaspersoft Studio
  • 10.12 A Look at TIBCO Spotfire Information Links
• Chapter 11 Creating Queries
  • 11.1 Using the Dataset and Query Dialog
  • 11.2 Working with the Query Builder
    • 11.2.1 Query Outline View and Diagram View
    • 11.2.2 Selecting Columns
    • 11.2.3 Joining Tables
    • 11.2.4 Data Selection Criteria (WHERE Conditions)
    • 11.2.5 Acquiring Fields
    • 11.2.6 Data Preview
• Chapter 12 Accessing JasperReports Server from Jaspersoft Studio
  • 12.1 Connecting to JasperReports Server
    • 12.1.1 Advanced Connection Settings
    • 12.1.2 Using Single Sign-on with JasperReports Server
  • 12.2 Publishing a Report to JasperReports Server
    • 12.2.1 Publishing Report Resources
    • 12.2.2 Choosing a Data Source for a Published Report
    • 12.2.3 Example of Publishing a Report
  • 12.3 Working with JasperReports Server Templates
    • 12.3.1 Creating a Custom JasperReports Server Template
    • 12.3.2 Report Template Styles in Jaspersoft Studio
  • 12.4 Creating and Uploading a Topic for Ad Hoc Views
  • 12.5 Managing Repository Objects through Jaspersoft Studio
    • 12.5.1 Adding, Modifying and Deleting Resources
    • 12.5.2 Running a Report
    • 12.5.3 Editing a Report
  • 12.6 Creating and Uploading Chart Themes
  • 12.7 Working with Domains
  • 12.8 Understanding the repo: Syntax
  • 12.9 Adding a Date/Time Stamp to Scheduled Output in JasperReports Server
• Chapter 13 Working with Tables
  • 13.1 Creating a Table
  • 13.2 Editing a Table
    • 13.2.1 Editing Table Properties
    • 13.2.2 Editing Table Styles
    • 13.2.3 Editing Cell Contents
    • 13.2.4 Editing Table Data
    • 13.2.5 Editing Table Source
  • 13.3 Table Structure
    • 13.3.1 Table Elements
    • 13.3.2 Table Cells
  • 13.4 Working with Columns
    • 13.4.1 Table Properties for Managing Columns
    • 13.4.2 Working with Individual Columns
    • 13.4.3 Column Groups
• Chapter 14 Working with Charts
  • 14.1 Creating a Simple Chart
  • 14.2 Setting Chart Properties
  • 14.3 Spider Charts
  • 14.4 Chart Themes
    • 14.4.1 Using the Chart Theme Designer
    • 14.4.2 Editing Chart Theme XML
    • 14.4.3 Creating a JasperReports Extension for a Chart Theme
    • 14.4.4 Applying a Chart Theme
• Chapter 15 HTML5 Charts in Commercial Editions
  • 15.1 Overview of HTML5 Charts
  • 15.2 Simple HTML5 Charts
    • 15.2.1 Creating an HTML5 chart
    • 15.2.2 Editing HTML5 Charts
    • 15.2.3 Creating Hyperlinks
    • 15.2.4 Setting Advanced Options for HTML5 Charts
  • 15.3 Scatter Charts
  • 15.4 Dual-Axis, Multi-Axis, and Combination Charts
  • 15.5 Hyperlinks in HTML5 Charts
    • 15.5.1 Creating Hyperlinks in HTML5 Charts
    • 15.5.2 Working with Bucket Properties and Hidden Measures
    • 15.5.3 Working with Report Units
• Chapter 16 Working with Crosstabs
  • 16.1 Example of Creating a Crosstab
  • 16.2 Working with Crosstab Properties
  • 16.3 Using the Crosstab Editor
    • 16.3.1 Formatting Columns, Rows, and Cells
    • 16.3.2 Editing Row or Column Group Properties
    • 16.3.3 Adding and Deleting Row and Column Groups
    • 16.3.4 Working with Measures
  • 16.4 Working with Crosstab Parameters
• Chapter 17 Working With the Map Component
  • 17.1 Working with Map Properties
  • 17.2 Viewing Authentication Properties
  • 17.3 Working with Markers
    • 17.3.1 Marker Properties
    • 17.3.2 Adding Markers Manually
    • 17.3.3 Adding Markers Using the Map
    • 17.3.4 Adding Markers Using a Dataset
    • 17.3.5 Modifying Markers
  • 17.4 Working with Paths
    • 17.4.1 Defining Path Styles
    • 17.4.2 Defining a Path Manually
    • 17.4.3 Defining a Path Using a Dataset
    • 17.4.4 Modifying Paths and Path Styles
  • 17.5 Properties for Markers and Paths
• Chapter 18 Working with TIBCO GeoAnalytics Maps
  • 18.1 Configuring a Basic Map
  • 18.2 Using Expressions for Properties
  • 18.3 Understanding Layers
  • 18.4 Working with Markers
    • 18.4.1 Static Markers
    • 18.4.2 Dynamic Markers
  • 18.5 Working with Paths
• Chapter 19 Working with Subreports
  • 19.1 Creating a New Report via the Subreport Wizard
  • 19.2 Understanding Subreports
    • 19.2.1 Subreports
    • 19.2.2 Subreport Elements
    • 19.2.3 The Expression Property
    • 19.2.4 Specifying the Data Source
    • 19.2.5 Subreport Parameters
• Chapter 20 Report Templates
  • 20.1 Template Structure
  • 20.2 Creating and Customizing Templates
    • 20.2.1 Creating a New Template
    • 20.2.2 Customizing a Template
  • 20.3 Saving Templates
    • 20.3.1 Creating a Template Directory
    • 20.3.2 Exporting a Template
    • 20.3.3 Creating a Template Thumbnail
  • 20.4 Adding Templates to Jaspersoft Studio
• Chapter 21 Report Books
  • 21.1 Creating the Report Book Framework
  • 21.2 Creating and Adding Reports to the Report Book
    • 21.2.1 Creating a Report for the Report Book
    • 21.2.2 Adding a Report to the Report Book
  • 21.3 Refining the Report Book
    • 21.3.1 Sorting on Additional Fields
    • 21.3.2 Adding Section Introductory Pages
  • 21.4 Configuring the Table of Contents
  • 21.5 Report Book Pagination
  • 21.6 Publishing the Report Book
• Chapter 22 Preferences and Configuration
  • 22.1 Properties
  • 22.2 JasperReports Samples
  • 22.3 Units of Measure in Jaspersoft Studio
    • 22.3.1 Configuration
    • 22.3.2 Changing the Field Unit of Measure
    • 22.3.3 Alias and Auto-complete
    • 22.3.4 Approximations
  • 22.4 Export and Import
    • 22.4.1
  • 22.5 Setting Compatibility with Earlier Versions of JasperReports Library
• Appendix A Concepts of JasperReports
  • A.1 JRXML Sources and Jasper Files
    • A.1.1 The Report Lifecycle
  • A.2 Data Sources and Print Formats
  • A.3 Using JasperReports Extensions in Jaspersoft Studio
  • A.4 A Simple Program
• Glossary
• Index