logo资料库

TIBCO Jaspersoft® Studio 5.2官方用户指导学习教程.pdf

第1页 / 共220页
第2页 / 共220页
第3页 / 共220页
第4页 / 共220页
第5页 / 共220页
第6页 / 共220页
第7页 / 共220页
第8页 / 共220页
资料共220页,剩余部分请下载后查看
Chapter 1 Getting Started with Jaspersoft Studio
1.1 Introduction to Jaspersoft Studio
1.2 User Interface
1.3 Hardware Requirements
1.4 Software Requirements
1.5 Accessing the Source Code
1.6 Report Structure in Jaspersoft Studio
1.6.1 The Report Lifecycle
1.6.2 Understanding Bands
1.6.3 Band Types
1.6.4 Specifying Report Properties
1.6.5 Columns
1.6.6 Advanced Options
1.7 Measure Units in Jaspersoft Studio
1.7.1 Configuration
1.7.2 Changing the Field Measure Unit
1.7.3 Alias and Autocomplete
1.7.4 Approximations
1.8 Exporting reports with Jaspersoft Studio
1.8.1 Compiling the Report
1.8.2 Preview and Exporting
Chapter 2 Concepts of JasperReports
2.1 JRXML Sources and Jasper Files
2.2 Data Sources and Print Formats
2.3 Expressions
2.3.1 The Type of an Expression
2.3.2 Expression Operators and Object Methods
2.3.3 Using an If-Else Construct in an Expression
2.4 Using Java as a Language for Expressions
2.5 Using Groovy as a Language for Expressions
2.6 Using JavaScript as a Language for Expressions
2.7 Using JasperReports Extensions in Jaspersoft Studio
2.8 A Simple Program
Chapter 3 Report Elements
3.1 Basic Element Attributes
3.2 Inserting, Selecting, and Positioning Elements
3.2.1 Inserting Elements
3.2.2 Selecting Elements
3.2.3 Positioning Elements
3.3 Formatting Elements
3.4 Graphic Elements
3.4.1 Line
3.4.2 Rectangle and Ellipse
3.4.3 Images
3.4.4 Padding and Borders
3.5 Text Elements
3.5.1 Static Text
3.5.2 Text Fields
3.6 Using Frames
3.7 Inserting Page and Column Breaks
3.8 Anchors, Bookmarks, and Hyperlinks
3.8.1 Anchors and Bookmarks
3.8.2 Overview of Hyperlink configuration
3.8.3 Hyperlink Types
3.8.4 Defining Hyperlinks
3.8.5 Hyperlink Parameters
3.8.6 Hyperlink Tooltips
3.8.7 Working with Report Units
3.9 Hyperlinks in HTML5 Charts
3.9.1 Creating Hyperlinks in HTML5 Charts
3.9.2 Working with Bucket Properties and Hidden Measures
3.10 Subreports
3.11 Advanced Elements and Custom Components
Chapter 4 Creating a Simple Report
4.1 Creating a New Report
4.2 Adding and Deleting Report Elements
4.2.1 Adding Fields to a Report
4.2.2 Deleting Fields
4.2.3 Adding Other Elements
4.3 Previewing a Report
4.4 Creating a Project Folder
Chapter 5 Connecting Jaspersoft Studio to JasperReports Server
5.1 Prerequisites
5.2 Connecting Jaspersoft Studio to JasperReports Server
5.3 Publishing a Report to JasperReports Server
5.4 Creating a Topic for JasperReports Server Ad Hoc Views
Chapter 6 Working with Fields
6.1 Understanding Fields
6.2 Registration of Fields from a SQL Query
6.3 Registration of JavaBean Fields
6.4 Fields and Textfields
Chapter 7 Report Templates
7.1 Template Structure
7.2 Creating and Customizing Templates
7.2.1 Creating a New Template
7.2.2 Customizing a Template
7.3 Saving Templates
7.3.1 Creating a Template Directory
7.3.2 Exporting a Template
7.3.3 Creating a Template Thumbnail
7.4 Adding Templates to Jaspersoft Studio
Chapter 8 Using Parameters
8.1 Managing Parameters
8.2 Default Parameters
8.3 Using Parameters in Queries
8.3.1 Using Parameters in a SQL Query
8.3.2 Using Parameters with Null Values
8.3.3 IN and NOTIN Clauses
8.3.4 Relative Dates
8.3.5 Passing Parameters from a Program
8.4 Parameters Prompt
Chapter 9 Variables
9.1 Defining a New Variable or Editing an Existing One
9.2 Base Properties of a Variable
9.3 Other Properties of a Variable
9.3.1 Evaluation Time
9.3.2 Calculation Function
9.3.3 Increment Type
9.3.4 Reset Type
9.3.5 Incrementer Factory Class Name
9.4 Built-In Variables
9.5 Tips & Tricks
Chapter 10 Data Sources
10.1 Data Adapters
10.2 Creating and Using Database JDBC Connections
10.2.1 ClassNotFoundError
10.2.2 URL Not Correct
10.2.3 Parameters Not Correct for the Connection
10.3 Working with Your JDBC Connection
10.3.1 Fields Registration
10.3.2 Filtering Records
10.4 Understanding the JRDataSource Interface
10.5 Data Source Types
10.5.1 Using Collection of JavaBeans Data Sources
10.5.2 Fields of a JavaBean Set Data Source
10.5.3 Using XML Data Adapters
10.5.4 Registration of the Fields for an XML Data Source
10.5.5 XML Data Source and Subreports
10.5.6 Using XML/A Data Adapters
10.5.7 Registration of fields in XML/A Providers
10.5.8 Using CSV Data Sources
10.5.9 Registration of the Fields for a CSV Data Source
10.5.10 Using JREmptyDataSource
10.5.11 Using HQL and Hibernate Connections
10.5.12 Using a Hadoop Hive Connection
10.5.13 Implementing a New JRDataSource
10.5.14 Using a Custom JasperReports Data Source with Jaspersoft Studio
10.6 Importing and Exporting Data Sources
Chapter 11 Using Tables
11.1 Creating a Table
11.2 Editing a Table
11.2.1 Editing Table Styles
11.2.2 Editing Cell Contents
11.2.3 Editing Table Data
11.3 Table Structure
11.3.1 Table Elements
11.3.2 Table Cells
11.4 Working with Columns
11.4.1 Column Groups
Chapter 12 Working with Charts
12.1 Datasets
12.1.1 Creating a Dataset
12.2 Creating a Simple Chart
12.3 Setting Chart Properties
12.4 Spider Charts
12.5 Chart Themes
12.5.1 Using the Chart Theme Designer
12.5.2 Editing Chart Theme XML
12.5.3 Creating a JasperReports Extension for a Chart Theme
12.5.4 Applying a Chart Theme
Chapter 13 Additional Chart Options in Commercial Editions
13.1 Overview of HTML5 Charts
13.2 Simple HTML5 Charts
13.2.1 Creating an HTML5 chart
13.2.2 Editing HTML5 Charts
13.2.3 Creating Hyperlinks
13.3 Scatter Charts
13.4 Dual-Axis, Multi-Axis, and Combination Charts
Chapter 14 Using the Dataset and Query Dialog and the Query Builder
14.1 Using the Dataset and Query Dialog
14.2 Working with the Query Builder
14.2.1 Query Outline View and Diagram View
14.2.2 Selecting columns
14.2.3 Joining tables
14.2.4 Data selection criteria (WHERE conditions)
14.2.5 Acquiring fields
14.2.6 Data Preview
Glossary
Index
JASPERSOFT STUDIO USER GUIDE RELEASE 5.6 http://www.jaspersoft.com
Copyright © 2014 Jaspersoft Corporation. All rights reserved. Printed in the U.S.A. Jaspersoft, the Jaspersoft logo, Jaspersoft iReport Designer, JasperReports Library, JasperReports Server, Jaspersoft OLAP, Jaspersoft Studio, and Jaspersoft ETL are trademarks and/or registered trademarks of Jaspersoft Corporation in the United States and in jurisdictions throughout the world. All other company and product names are or may be trade names or trademarks of their respective owners. This is version 0514-JSS56-04 of the Jaspersoft Studio User Guide.
TABLE OF CONTENTS Chapter 1 Getting Started with Jaspersoft Studio 1.1 Introduction to Jaspersoft Studio 1.2 User Interface 1.3 Hardware Requirements 1.4 Software Requirements 1.5 Accessing the Source Code 1.6 Report Structure in Jaspersoft Studio 1.6.1 The Report Lifecycle 1.6.2 Understanding Bands 1.6.3 Band Types 1.6.4 Specifying Report Properties 1.6.5 Columns 1.6.6 Advanced Options 1.7 Measure Units in Jaspersoft Studio 1.7.1 Configuration 1.7.2 Changing the Field Measure Unit 1.7.3 Alias and Autocomplete 1.7.4 Approximations 1.8 Exporting reports with Jaspersoft Studio 1.8.1 Compiling the Report 1.8.2 Preview and Exporting Chapter 2 Concepts of JasperReports 2.1 JRXML Sources and Jasper Files 2.2 Data Sources and Print Formats 2.3 Expressions 2.3.1 The Type of an Expression 2.3.2 Expression Operators and Object Methods 2.3.3 Using an If-Else Construct in an Expression 2.4 Using Java as a Language for Expressions 2.5 Using Groovy as a Language for Expressions 2.6 Using JavaScript as a Language for Expressions 2.7 Using JasperReports Extensions in Jaspersoft Studio 9 9 9 11 11 12 12 12 13 13 14 16 17 17 17 18 18 19 19 19 19 21 21 25 26 27 27 29 30 31 32 32 3
Jaspersoft Studio User Guide 2.8 A Simple Program Chapter 3 Report Elements 3.1 Basic Element Attributes 3.2 Inserting, Selecting, and Positioning Elements 3.2.1 Inserting Elements 3.2.2 Selecting Elements 3.2.3 Positioning Elements 3.3 Formatting Elements 3.4 Graphic Elements 3.4.1 Line 3.4.2 Rectangle and Ellipse 3.4.3 Images 3.4.4 Padding and Borders 3.5 Text Elements 3.5.1 Static Text 3.5.2 Text Fields 3.6 Using Frames 3.7 Inserting Page and Column Breaks 3.8 Anchors, Bookmarks, and Hyperlinks 3.8.1 Anchors and Bookmarks 3.8.2 Overview of Hyperlink configuration 3.8.3 Hyperlink Types 3.8.4 Defining Hyperlinks 3.8.5 Hyperlink Parameters 3.8.6 Hyperlink Tooltips 3.8.7 Working with Report Units 3.9 Hyperlinks in HTML5 Charts 3.9.1 Creating Hyperlinks in HTML5 Charts 3.9.2 Working with Bucket Properties and Hidden Measures 3.10 Subreports 3.11 Advanced Elements and Custom Components Chapter 4 Creating a Simple Report 4.1 Creating a New Report 4.2 Adding and Deleting Report Elements 4.2.1 Adding Fields to a Report 4.2.2 Deleting Fields 4.2.3 Adding Other Elements 4.3 Previewing a Report 4.4 Creating a Project Folder Chapter 5 Connecting Jaspersoft Studio to JasperReports Server 5.1 Prerequisites 5.2 Connecting Jaspersoft Studio to JasperReports Server 5.3 Publishing a Report to JasperReports Server 5.4 Creating a Topic for JasperReports Server Ad Hoc Views 4 32 35 36 37 37 37 37 38 40 41 41 41 41 42 42 42 43 44 44 45 45 47 48 49 49 49 50 51 54 59 63 65 65 69 69 72 72 73 74 77 77 77 79 82
Chapter 6 Working with Fields 6.1 Understanding Fields 6.2 Registration of Fields from a SQL Query 6.3 Registration of JavaBean Fields 6.4 Fields and Textfields Chapter 7 Report Templates 7.1 Template Structure 7.2 Creating and Customizing Templates 7.2.1 Creating a New Template 7.2.2 Customizing a Template 7.3 Saving Templates 7.3.1 Creating a Template Directory 7.3.2 Exporting a Template 7.3.3 Creating a Template Thumbnail 7.4 Adding Templates to Jaspersoft Studio Chapter 8 Using Parameters 8.1 Managing Parameters 8.2 Default Parameters 8.3 Using Parameters in Queries 8.3.1 Using Parameters in a SQL Query 8.3.2 Using Parameters with Null Values 8.3.3 IN and NOTIN Clauses 8.3.4 Relative Dates 8.3.5 Passing Parameters from a Program 8.4 Parameters Prompt Chapter 9 Variables 9.1 Defining a New Variable or Editing an Existing One 9.2 Base Properties of a Variable 9.3 Other Properties of a Variable 9.3.1 Evaluation Time 9.3.2 Calculation Function 9.3.3 Increment Type 9.3.4 Reset Type 9.3.5 Incrementer Factory Class Name 9.4 Built-In Variables 9.5 Tips & Tricks Chapter 10 Data Sources 10.1 Data Adapters 10.2 Creating and Using Database JDBC Connections 10.2.1 ClassNotFoundError 10.2.2 URL Not Correct 10.2.3 Parameters Not Correct for the Connection 10.3 Working with Your JDBC Connection 10.3.1 Fields Registration 85 85 87 88 90 91 91 93 93 95 96 96 97 99 99 101 101 103 104 104 105 106 106 108 109 113 113 113 114 114 115 115 116 116 116 117 119 119 121 123 124 124 124 125 5
Jaspersoft Studio User Guide 10.3.2 Filtering Records 10.4 Understanding the JRDataSource Interface 10.5 Data Source Types 10.5.1 Using Collection of JavaBeans Data Sources 10.5.2 Fields of a JavaBean Set Data Source 10.5.3 Using XML Data Adapters 10.5.4 Registration of the Fields for an XML Data Source 10.5.5 XML Data Source and Subreports 10.5.6 Using XML/A Data Adapters 10.5.7 Registration of fields in XML/A Providers 10.5.8 Using CSV Data Sources 10.5.9 Registration of the Fields for a CSV Data Source 10.5.10 Using JREmptyDataSource 10.5.11 Using HQL and Hibernate Connections 10.5.12 Using a Hadoop Hive Connection 10.5.13 Implementing a New JRDataSource 10.5.14 Using a Custom JasperReports Data Source with Jaspersoft Studio 10.6 Importing and Exporting Data Sources Chapter 11 Using Tables 11.1 Creating a Table 11.2 Editing a Table 11.2.1 Editing Table Styles 11.2.2 Editing Cell Contents 11.2.3 Editing Table Data 11.3 Table Structure 11.3.1 Table Elements 11.3.2 Table Cells 11.4 Working with Columns 11.4.1 Column Groups Chapter 12 Working with Charts 12.1 Datasets 12.1.1 Creating a Dataset 12.2 Creating a Simple Chart 12.3 Setting Chart Properties 12.4 Spider Charts 12.5 Chart Themes 12.5.1 Using the Chart Theme Designer 12.5.2 Editing Chart Theme XML 12.5.3 Creating a JasperReports Extension for a Chart Theme 12.5.4 Applying a Chart Theme Chapter 13 Additional Chart Options in Commercial Editions 13.1 Overview of HTML5 Charts 13.2 Simple HTML5 Charts 13.2.1 Creating an HTML5 chart 6 126 127 128 128 129 130 132 133 135 136 137 138 139 140 141 142 144 146 147 147 155 155 157 158 159 159 160 161 161 163 163 164 165 170 171 174 175 176 176 177 179 179 184 184
13.2.2 Editing HTML5 Charts 13.2.3 Creating Hyperlinks 13.3 Scatter Charts 13.4 Dual-Axis, Multi-Axis, and Combination Charts Chapter 14 Using the Dataset and Query Dialog and the Query Builder 14.1 Using the Dataset and Query Dialog 14.2 Working with the Query Builder 14.2.1 Query Outline View and Diagram View 14.2.2 Selecting columns 14.2.3 Joining tables 14.2.4 Data selection criteria (WHERE conditions) 14.2.5 Acquiring fields 14.2.6 Data Preview Glossary Index 188 190 191 195 199 199 201 201 203 204 205 206 206 207 217 7
Jaspersoft Studio User Guide 8
分享到:
收藏