EspressReport User's Guide

Q. Quick Start Guide
Q.1. Overview
Q.1.1. EspressReport Architecture
Q.2. Key Features
Q.3. Designer Quick Start
Q.3.1. Start Report Designer
Q.3.2. Set Up Data Sources
Q.3.2.1. Setup A Database Connection
Q.3.2.1.1. Setup a JDBC Connection
Q.3.2.1.2. Setup an ODBC Connection
Q.3.2.2. Create a Query
Q.3.2.2.1. Add Query Parameters
Q.3.2.3. Create a Data View
Q.3.2.3.1. Query a Data View
Q.3.3. Report Mapping
Q.3.3.1. Simple Columnar Layout
Q.3.3.2. Summary Break Layout
Q.3.3.3. Crosstab Layout
Q.3.3.4. Master & Details Layout
Q.3.4. Basic Report Formatting
Q.3.4.1. Move and Align Report Elements
Q.3.4.2. Data Formatting
Q.3.4.3. Set Dual Colors
Q.3.4.4. Inserting Elements
Q.3.4.4.1. Insert an Image
Q.3.4.4.2. Insert a Title
Q.3.4.4.3. Insert a Line
Q.3.4.5. View Report Elements in Report Explorer
Q.3.4.6. Set Section Options
Q.3.5. Formulas & Scripting
Q.3.5.1. Add a Formula
Q.3.5.2. Add a Script
Q.3.5.3. Add an Aggregation
Q.3.6. Drill Down
Q.3.7. Sub-Reports
Q.3.8. Working with Charts
Q.3.8.1. Insert a Chart & Map Data
Q.3.8.2. Customize Chart Properties
Q.4. API Quick Start
Q.4.1. Set Up Environment
Q.4.2. Run a Report
Q.4.2.1. Application
Q.4.2.2. Applet
Q.4.2.3. Servlet
Q.4.2.4. JSP
Q.4.2.5. Page Viewer
Q.4.3. Create a Report Programmatically
Q.4.3.1. Map Summary Break ColInfo
Q.4.3.2. Apply Template
Q.4.4. Modify Data Source of a Report
Q.4.4.1. Modify Data Source and Query of a Report (with SubReport)
Q.4.4.2. Modify Data Source and Query of a Parameterized Report (with Parameterized SubReport)
Q.4.5. Modify Report Elements
Q.4.6. Parameterized Reports
Q.4.6.1. Pass in Parameter values
Q.4.6.2. Pass in Parameter values using getAllParameters
Q.4.6.3. Use getParameterPage() and ParamReportGeneratorServlet
Q.4.7. Deploy/Export Drill-Down
Q.4.8. More on Servlets
Q.4.8.1. Write to File (PDF)
Q.4.8.2. Stream Chart (DHTML)
Q.4.9. Launch Report Designer
1. Designer Guide
1.1. Overview / Introduction
1.1.1. EspressReport Documentation
1.1.2. New Features List V6.6
1.1.2.1. New Report Features
1.1.2.2. New Chart Features
1.2. Architecture & Installation
1.2.1. EspressReport Architecture
1.2.2. Installation
1.2.3. Configuration
1.2.3.1. Increasing maximum memory heap size for applets
1.2.4. Starting EspressManager
1.2.4.1. EspressManager Configuration Interface
1.2.4.2. Starting EspressManager as a Servlet
1.2.4.2.1. Deploying EspressManager as a Servlet in Tomcat
1.2.5. Starting Report Designer
1.2.5.1. Connecting to EspressManager Running as a Servlet
1.2.6. Backward compatibility patches
1.3. Working with Data Sources
1.3.1. The Data Source Manager
1.3.1.1. Using Data Source Manager
1.3.2. Data from a Database
1.3.2.1. JNDI Data Sources
1.3.2.2. Queries
1.3.2.2.1. Using Query Builder
1.3.2.2.1.1. Tables
1.3.2.2.1.2. Joins
1.3.2.2.1.3. Columns
1.3.2.2.1.4. Using Database Functions
1.3.2.2.1.5. Adding Extra SQL
1.3.2.2.1.6. Query Output
1.3.2.2.2. Parameterized Queries
1.3.2.2.2.1. Multi-Value Parameters
1.3.2.2.2.2. Initializing Query Parameters
1.3.2.2.2.3. Cascading Parameters
1.3.2.2.2.4. All Parameters
1.3.2.2.3. Entering SQL Statements
1.3.2.2.3.1. Calling Oracle Stored Procedures
1.3.2.3. Data Views
1.3.2.3.1. Data View Parameters
1.3.2.3.2. Updating Data View Queries
1.3.2.4. Editing Queries
1.3.2.5. Editing Database Connections
1.3.3. Data from XML and XBRL Files
1.3.3.1. XMLQueries
1.3.3.1.1. XML Parameters
1.3.4. Data from Text Files
1.3.4.1. Formatting Requirements for Text Files
1.3.4.2. Data Types and Format for Text Files
1.3.5. Data from Class Files
1.3.5.1. Parameterized Class Files
1.3.6. Data from EJBs
1.3.7. Data from SOAP with WSDL support
1.3.8. Data from Salesforce
1.3.9. Data from Excel files
1.3.10. Using Data for Reports
1.3.10.1. Using Multiple Data Sources
1.3.10.2. Change Data Source
1.3.11. Data Source Updating
1.4. Report Types and Data Mapping
1.4.1. Simple Columnar Report
1.4.1.1. Data Mapping
1.4.1.1.1. Top N Report
1.4.2. Summary Break Report
1.4.2.1. Data Mapping
1.4.2.1.1. Top N Report
1.4.3. Crosstab Report
1.4.3.1. Data Mapping
1.4.3.2. Transposing Data
1.4.3.3. Fixed-Field Crosstab Report
1.4.3.3.1. Data Mapping
1.4.4. Master & Details Report
1.4.4.1. Data Mapping
1.4.4.1.1. Top N Report
1.4.5. Mailing Label Report
1.4.5.1. Data Mapping
1.4.6. Additional Formatting Options
1.4.6.1. Custom Styles
1.4.6.1.1. Creating a Custom Style
1.4.6.1.2. Applying a Custom Style
1.4.7. Fit Columns to Page Width
1.4.8. Change Data Mapping
1.4.9. Keep Data Source Order
1.5. The Designer Interface
1.5.1. Report Sections
1.5.1.1. Nested Sections
1.5.2. Resizing Sections
1.5.3. Section Options
1.5.4. Rulers
1.5.4.1. Toggling Between Inches and Centimeters
1.5.5. Designer Menus
1.5.5.1. File Menu
1.5.5.2. Edit Menu
1.5.5.3. Insert Menu
1.5.5.4. Format Menu
1.5.5.5. View Menu
1.5.5.6. Data Menu
1.5.5.7. Drill-Down Menu
1.5.5.8. Option Menu
1.5.6. Designer Toolbar
1.5.7. Inserting and Manipulating Report Elements
1.5.7.1. Inserting Elements
1.5.7.1.1. Inserting Charts
1.5.7.1.1.1. Inserting Summary Charts into Fixed-field Crosstab Reports
1.5.7.1.2. Inserting Elements into the Table Data Section
1.5.7.2. Editing Elements
1.5.7.2.1. Editing Element Attributes
1.5.7.2.2. Word Wrapping
1.5.7.2.3. Editing Side-By-Side Master & Details Reports
1.5.7.3. Data Formatting for Formulas and Column Fields
1.5.7.3.1. Formatting Null Data
1.5.7.4. Line/Rectangle Format
1.5.7.5. Chart Export Format
1.5.7.6. Font, Color, and Border Options
1.5.7.6.1. Show Cell Outline
1.5.7.7. Rich Text Fields
1.5.7.7.1. Adding Formulas
1.5.7.8. Hyperlinks
1.5.7.9. Column Wrapping
1.5.7.10. Table of Contents
1.5.7.10.1. Adding a Table of Contents
1.5.7.11. Moving and Resizing Report Elements
1.5.7.11.1. Controlling Element Overlapping
1.5.7.11.2. Locking Element Position
1.5.7.12. Snap to Grid
1.5.7.13. Shift Mode
1.5.7.14. Guidelines
1.5.7.14.1. Inserting Guidelines
1.5.7.14.2. Positioning Elements with Guidelines
1.5.8. The Report Explorer
1.5.9. Global Formatting, Group Formatting, and Templates
1.5.9.1. Global Formatting
1.5.9.1.1. Global Format Import/Export
1.5.9.1.2. Global Formatting & Crosstab Reports
1.5.9.2. Group Formatting
1.5.9.3. Applying a Template
1.5.10. Report Designer in Mac OS X
1.6. The Preview Window
1.6.1. Navigating the Report
1.6.2. Other Preview Window Options
1.6.2.1. Preview Data Options
1.6.2.2. Sorting Data
1.6.2.3. Parameter Prompts
1.6.2.4. Using Page Viewer
1.6.2.4.1. Unmapped Drill-down Parameter
1.6.3. Setting Page Properties
1.7. Saving and Exporting Reports
1.7.1. Saving Reports
1.7.1.1. Changing the Save Location
1.7.1.2. XML Encoding
1.7.2. Exporting Reports
1.7.2.1. PDF Font Mapping
1.7.2.1.1. PDF Font Mapping Import/Export
1.7.2.2. CSS Options
1.8. Using Formulas & the Formula Builder
1.8.1. Creating a Formula
1.8.1.1. The Formula Builder
1.8.2. Formula Syntax
1.8.2.1. Using Column Field Data
1.8.2.1.1. Column Aggregation
1.8.2.2. Using Formulas
1.8.2.3. Using Parameter Values
1.8.2.4. Using Database Fields
1.8.2.5. Constants
1.8.2.6. Formula Parameters
1.8.2.6.1. Initializing Formula Parameters
1.8.2.7. Operators
1.8.2.7.1. Arithmetic Operators
1.8.2.7.2. Boolean Operators
1.8.2.8. Functions
1.8.2.8.1. Numeric Functions
1.8.2.8.2. String Functions
1.8.2.8.3. Date/Time Functions
1.8.2.8.4. Custom Functions
1.8.3. Subreport Formula Access
1.9. Scripting
1.9.1. Creating a Script
1.9.2. Script Syntax
1.9.2.1. Formatting Actions
1.9.2.1.1. Scripting Image URLs
1.9.2.2. Variables & Arrays
1.9.2.2.1. Variables
1.9.2.2.2. Arrays
1.9.2.3. Using Formulas
1.9.2.4. Checking for Nulls
1.9.2.5. Row-Specific Options
1.9.2.6. Loops
1.9.2.7. Section Scripts
1.9.2.7.1. Formatting Actions for Section Scripts
1.9.2.8. Commenting Scripts
1.9.2.9. Accessing Values Computed by Other Scripts
1.9.3. Managing Scripts
1.10. Drill Down
1.10.1. Creating a Drill-Down Report
1.10.1.1. Drill-Down Links
1.10.1.1.1. Linking from Charts
1.10.2. Multi-Value Drill Down
1.10.2.1. Creating a Multi-Value Drill Down Report
1.10.3. Crosstab Drill-Down
1.10.3.1. Creating a Crosstab Drill-Down Report
1.10.4. Viewing Drill-Down Reports
1.10.5. Unmapped Drill-Down
1.11. Sub-Reports
1.11.1. Adding a Sub-Report
1.11.2. Editing a Sub-Report
1.11.2.1. Sub-Report sizing
1.11.3. Removing a Sub-Report
1.11.4. Linked Sub-Reports
1.11.4.1. Using Linked Sub-Reports
1.11.5. Parameter Linking
1.12. Template Security
1.12.1. Security Levels
1.12.2. Cell-Level Security
1.12.2.1. Security Parameters
1.12.3. Security for Sub-Reports & Drill-Down Layers
1.12.4. Viewing Secured Templates
1.12.4.1. Secured Report Designer
1.13. Scheduling
1.13.1. The Scheduler Interface
1.13.2. Setting a Schedule
1.13.2.1. Scheduling a Report
1.13.2.2. Scheduling Parameterized Reports
1.13.2.3. Email Delivery Options
1.13.2.4. Specifying Email Recipients
1.13.2.5. Report Bursting
1.13.2.6. Scheduling a Command
1.13.2.7. Viewing and Editing Schedules
2. Programming Guide
2.1. Introduction to Report Viewer
2.1.1. Introduction
2.1.2. Launching Report Viewer
2.1.3. The Report Viewer Parameters
2.1.4. Specifying the Data Source for Report Viewer
2.1.4.1. Data Read From Database
2.1.4.2. Data Read From a Data File
2.1.4.3. Data Read From Argument
2.1.5. Using Report Viewer
2.1.6. Parameter Server
2.1.7. Connecting to EspressManager
2.1.7.1. EspressManager Running as Application
2.1.7.2. EspressManager Running as Servlet
2.1.8. Swing Version
2.1.9. Exporting from Viewer
2.2. Introduction to Page Viewer
2.2.1. Introduction
2.2.2. Launching Page Viewer
2.2.2.1. Launching from Report Designer
2.2.3. The Page Viewer Parameters
2.2.4. Using Page Viewer
2.2.5. Buffer Time
2.2.6. Connecting to EspressManager
2.2.6.1. EspressManager Running as Application
2.2.6.2. EspressManager Running as Servlet
2.2.7. Swing Version
2.2.8. Exporting from Viewer
2.3. EspressReport Report API
2.3.1. Introduction and Setup
2.3.2. Recommended Approach for using Report API
2.3.3. Interaction with EspressManager
2.3.4. Connecting to EspressManager
2.3.4.1. EspressManager Running as Application
2.3.4.2. EspressManager Running as Servlet
2.3.5. Using the API
2.3.5.1. Loading a Report
2.3.5.1.1. Sub-Reports, Charts, and Drill-Down Reports
2.3.5.1.2. PAK File
2.3.5.1.3. Backup Data
2.3.5.1.4. Parameterized Reports
2.3.5.1.4.1. Object Array
2.3.5.1.4.2. getAllParameters method
2.3.5.1.5. Secure Reports
2.3.5.2. Applying a Report Template
2.3.5.3. Modifying Data Source
2.3.5.3.1. Data from a Database
2.3.5.3.1.1. Parameterized
2.3.5.3.1.2. JNDI
2.3.5.3.2. Data from a Data File (TXT/DAT/XML)
2.3.5.3.3. Data from an XML Data Source
2.3.5.3.4. Data from Custom Implementation
2.3.5.3.4.1. Parameterized
2.3.5.3.5. Data passed in an Array in Memory
2.3.5.3.6. Drill-Down with DrillDownReportServlet
2.3.5.4. Modifying Column Mapping
2.3.5.5. Report Components
2.3.5.5.1. ReportElement
2.3.5.5.2. ReportCell
2.3.5.5.3. ReportSection
2.3.5.5.4. ReportColumn
2.3.5.5.5. ReportTable
2.3.5.5.6. ReportImage
2.3.5.5.7. ReportChartObject
2.3.5.5.8. ChartObject
2.3.5.5.9. ReportDocument
2.3.5.5.10. ReportRTFObject
2.3.5.5.11. SubReportObject
2.3.5.5.12. ReportGrid
2.3.5.5.13. ReportLine
2.3.5.6. Modifying Report Attributes
2.3.5.6.1. Adding New Cells
2.3.5.6.2. Adding Images/Charts
2.3.5.6.3. Adding Hyperlinks
2.3.5.6.4. Adding Grid Lines and Lines
2.3.5.6.5. Adding Rich Text Field Objects
2.3.5.6.6. Adding Nested Sections
2.3.5.6.7. Modifying Background Color, Font .....
2.3.5.6.8. Modifying the Format
2.3.5.6.9. Modifying a Column to Show Bar Codes
2.3.5.6.10. Modifying a Report to be a Top N report
2.3.5.6.11. Cell Scripts
2.3.5.7. Exporting the Report
2.3.5.7.1. Multiple Page Exporting
2.3.5.7.2. PDF Exporting Options
2.3.5.7.3. Exporting DHTML Content with Style Sheets
2.3.5.7.4. HTML Block Export
2.3.5.7.5. Custom Links for Multi-page DHTML/HTML Export
2.3.5.7.6. Setting the Pixels Per Inch Ratio for DHTML/HTML Export
2.3.5.7.7. Pre-load charts
2.3.5.7.8. IExportThreadListener for .view files
2.3.5.7.9. Virtual Memory / Paging
2.3.5.7.10. Streaming Reports
2.3.5.7.10.1. RPTImageGenerator
2.3.5.7.10.2. DrillDownReportServlet
2.3.5.7.10.3. Generating HTML Parameter Page
2.3.5.7.11. Calling Report Designer from Report API
2.3.5.7.11.1. Specify a Report Template
2.3.5.7.11.2. Specify a Data Registry
2.3.5.7.11.3. Specify a DBInfo Object (Database Information)
2.3.5.7.11.4. Open Query Builder with a Specified DBInfo Object (Database Information)
2.3.5.7.11.5. Open Report Designer with a Specific Class File Data Source
2.3.5.7.11.6. Open Report Designer with Custom Functions
2.3.5.7.11.7. Open Report Designer with Pre-set Directories
2.3.5.7.11.8. Open Report Designer with Modified Menubar and Toolbar
2.3.5.7.11.9. Open Report Designer with Skipped Wizard Steps
2.3.5.7.11.10. Open Report Designer with Customized Messages and Chart Designer
2.3.5.7.12. Changing Report/Page Viewer Options
2.3.5.8. Javadoc
2.3.5.9. Swing Version
2.3.5.10. Summary
2.4. Scheduler
2.4.1. Introduction
2.4.2. Connecting to EspressManager
2.4.2.1. EspressManager Running as Application
2.4.2.2. EspressManager running as servlet
2.4.3. Invoking Scheduler Graphical Interface
2.4.4. Scheduling an Export
2.4.5. Scheduling a Command
2.4.6. Removing a Schedule
2.4.7. Getting Details of a Failed Schedule
2.4.8. ICallBackScheduler Interface
2.4.9. Scheduler Listener
2.4.10. Report Bursting
2.4.11. Javadoc
2.4.12. Summary
2.5. Servlets and Java Server Pages
2.5.1. Servlets
2.5.1.1. Introduction
2.5.1.2. Setup
2.5.1.3. Running Under
2.5.1.3.1. Apache Tomcat 5.5.20 or 6.0.10
2.5.1.3.2. JRun 3.1
2.5.1.3.3. ColdFusion Server 4.5
2.5.1.3.4. WebLogic 6.0
2.5.1.3.4.1. WebLogic 9.2
2.5.1.3.5. WebSphere 3.5
2.5.1.3.5.1. WebSphere 6.1
2.5.1.3.6. WebSphere Express Server 5.0
2.5.1.3.7. JBoss 4.0.5
2.5.1.3.8. Orion 2.0.7
2.5.1.3.9. JRun 4(with Update 6)
2.5.1.3.10. Oracle 10g (10.1.3.1.0)
2.5.1.3.11. Sun Java System Application PE (9.0, 8.2)
2.5.1.3.12. Sun Java System WebServer 7.0
2.5.1.3.13. Resin 3.1.0
2.5.1.3.14. ColdFusion MX 7.02
2.5.1.4. Running the Servlet
2.5.2. Java Server Pages (JSP)
2.5.2.1. Introduction
2.5.2.2. Running Under
2.5.2.2.1. Apache Tomcat 4.0
2.5.2.2.2. WebSphere 3.5
2.5.3. Saving a Report to a File versus Sending a Report to a Browser
2.5.3.1. Saving the Report to a File
2.5.3.2. Sending the Report Directly to a Browser
2.6. Working with WebObjects
2.6.1. Introduction
2.6.2. Basic API
2.6.2.1. Integrating with EspressReport Standard API
2.6.2.2. Integrating with WebObjects Collection Class NSArray
2.6.2.2.1. EOModel and EO Fetch Specification
2.6.2.2.2. Creating a WOQbReport using a NSArray as a datasource
2.6.3. Deploying a WebObjects Application
2.6.3.1. Install Xcode
2.6.3.2. Install Eclipse
2.6.3.3. Install WOLips
2.6.3.4. Install Velocity EOGenerator
2.6.3.5. Create new WO Application
2.6.3.6. Edit Main WO Component
2.6.3.7. Create new WO Component
2.6.3.8. Modify build path
2.6.3.9. Create EOModel using Entity Modeler
2.6.3.10. Setup Database Information
2.6.3.11. Create Entities
2.6.3.12. Create attribute definitions
2.6.3.13. Create Relationships Between Entities
2.6.3.13.1. Create Relationship Between "Orders" and "OrderDetails"
2.6.3.13.2. Create Relationship Between "OrderDetails" and "Products"
2.6.3.13.3. Create relationship between "Products" and "Categories"
2.6.3.14. Verify and Save
2.6.3.15. Create Java Code
2.6.3.16. Running the Test Case with NSArray
2.6.3.17. Running the Test Case for Parameterized Report using NSArray
2.6.4. Notes
2.7. Deployment
2.7.1. Introduction
2.7.2. Deploying with EspressManager
2.7.2.1. Report Designer
2.7.2.2. Report Viewer
2.7.2.3. Page Viewer
2.7.2.4. Chart Viewer
2.7.2.5. Report API
2.7.2.6. Scheduler
2.7.3. Deploying without EspressManager
2.7.3.1. Report Viewer
2.7.3.2. Page Viewer
2.7.3.3. Chart Viewer
2.7.3.4. Report API
2.7.4. Deploying in a Non-Windows Environment
2.7.4.1. Xvfb (X Virtual Frame Buffer)
2.7.4.2. JVM 1.5+ in Headless Mode
2.7.5. Platform Specific Issues
2.7.5.1. AS/400
2.7.5.1.1. Running under NAWT
2.7.5.1.2. Running under Headless Mode
2.7.5.2. Linux/Unix
2.7.5.2.1. Running under X
2.7.5.2.2. Running under Headless Mode
2.A. Parameter Server
2.A.1. Writing a Parameter Server
2.A.1.1. Variables
2.A.1.2. Constructor
2.A.1.3. Methods
2.B. Getting the Report Data
2.B.1. Data from a Database
2.B.1.1. Data from JNDI
2.B.2. Data from a Data File (TXT/DAT/XML)
2.B.3. Data from an XML Data Source
2.B.4. Data passed in an Array in Memory
2.B.5. Data passed in a Custom Implementation
2.B.6. Data from Enterprise Java Beans (EJBs)
2.B.7. Data from a SOAP Data Source
2.B.8. Data from Multiple Data Sources
2.C. Creating the Report
2.C.1. Simple Columnar
2.C.1.1. Column Mapping
2.C.1.2. Creating the Report
2.C.2. Summary Break
2.C.2.1. Column Mapping
2.C.2.2. Creating the Report
2.C.3. CrossTab
2.C.3.1. Column Mapping
2.C.3.2. Creating the Report
2.C.3.3. Fixed-field Crosstab Report
2.C.3.3.1. Creating the Report
2.C.4. Master & Details
2.C.4.1. Column Mapping
2.C.4.2. Creating the Report
2.C.5. Mailing Labels
2.C.5.1. Column Mapping
2.C.5.2. Creating the Report
2.C.6. Formula
2.C.7. Parameterized Report
2.C.7.1. Creating the Report with Single Value Parameter
2.C.7.2. Creating the Report with Multi Value Parameter
2.C.8. Sub-Report
2.C.8.1. Creating the Report
2.C.9. Drill-Down
2.C.9.1. Creating the Report
3. Charting Guide
3.1. Introduction
3.2. Charting Basics
3.2.1. What is a Chart
3.2.2. Basic Data Mapping
3.3. Creating a Chart
3.3.1. Data Source Options
3.3.1.1. Chart Parameter Linking
3.3.2. Multiple Data Sources
3.4. Chart Types and Data Mapping
3.4.1. Data Mapping
3.4.1.1. Data Transposition
3.4.2. Column Charts
3.4.2.1. Data Mapping
3.4.3. Bar Charts
3.4.3.1. Data Mapping
3.4.4. XY(Z) Scatter Charts
3.4.4.1. Data Mapping
3.4.5. Line Charts
3.4.5.1. Data Mapping
3.4.6. Stack Column Charts
3.4.6.1. Data Mapping
3.4.7. Stack Bar Charts
3.4.7.1. Data Mapping
3.4.8. Pie Charts
3.4.8.1. Data Mapping
3.4.9. Area Charts
3.4.9.1. Data Mapping
3.4.10. Stack Area Charts
3.4.10.1. Data Mapping
3.4.11. High-Low Charts
3.4.11.1. Data Mapping
3.4.12. HLCO Charts
3.4.12.1. Data Mapping
3.4.13. Percentage Column Charts
3.4.13.1. Data Mapping
3.4.14. Doughnut Charts
3.4.14.1. Data Mapping
3.4.15. Surface Charts
3.4.15.1. Data Mapping
3.4.16. Bubble Charts
3.4.16.1. Data Mapping
3.4.17. Overlay Charts
3.4.17.1. Data Mapping
3.4.18. Box Charts
3.4.18.1. Data Mapping
3.4.19. Radar Charts
3.4.19.1. Data Mapping
3.4.20. Dial Charts
3.4.20.1. Data Mapping
3.4.20.2. Gauges
3.4.21. Gantt Charts
3.4.21.1. Data Mapping
3.4.22. Polar Charts
3.4.22.1. Data Mapping
3.4.23. Changing Data Mapping or Data Source
3.5. The Designer Interface
3.5.1. The Designer Menus
3.5.1.1. File Menu
3.5.1.2. Insert Menu:
3.5.1.3. Format Menu
3.5.1.4. Type Menu
3.5.1.5. Drill-Down Menu
3.5.1.6. Data Menu
3.5.1.7. Layout Menu
3.5.2. The Designer Toolbar
3.5.3. Color, Color set, Pattern, and Font Panels
3.5.3.1. Color Panel
3.5.3.2. Color Set Panel
3.5.3.2.1. Save Colors for Categories feature
3.5.3.3. Pattern Panel
3.5.3.4. Font Panel
3.5.4. The Navigation Panel
3.5.5. The Viewport
3.5.5.1. The Chart Canvas
3.5.5.1.1. Background Images
3.5.5.2. Moving and Sizing Chart Elements
3.5.6. Adding Chart Elements
3.5.6.1. Adding Text
3.5.6.1.1. TextVariables
3.5.6.1.2. Text Replacement
3.5.6.1.3. Automatic Text Re-sizing
3.5.6.1.4. Text Cropping
3.5.6.2. Adding Lines
3.5.6.2.1. Line and Point Formatting
3.5.6.2.2. Floating Lines
3.5.6.2.3. Fixed Horizontal/Vertical Lines
3.5.6.2.4. Trend Lines
3.5.6.2.4.1. Normal Distribution Curve
3.5.6.3. Adding Control Areas
3.5.6.4. Adding Tables
3.5.6.5. Adding Hyperlinks
3.5.6.5.1. Viewing Hyperlinks
3.5.7. Formatting Chart Axes
3.5.7.1. Axis Scale
3.5.7.2. Axis Elements
3.5.7.2.1. Axis Label Formatting
3.5.8. Formatting Plot/Data Elements
3.5.8.1. Data Properties
3.5.8.2. Date/Time Based Zooming
3.5.8.2.1. Adding Zooming
3.5.8.2.2. ZoomingInChartViewer
3.5.8.3. Data Ordering
3.5.8.3.1. Top/Bottom N Charts
3.5.8.4. Histograms
3.5.8.5. Formatting Plot Area
3.5.8.6. Formatting Chart Legend
3.5.8.7. 3D Display Options
3.5.8.8. Data Border
3.5.8.9. Aggregation
3.5.9. Chart-Specific Options
3.5.9.1. Bubble Charts
3.5.9.2. Dial Charts
3.5.9.2.1. Gauge Images
3.5.9.3. Overlay Charts
3.5.9.4. Pie Charts
3.5.9.5. Line Charts:
3.5.9.5.1. Double Value Line Charts
3.5.9.6. HLCO Charts
3.5.9.7. Box Charts
3.5.9.8. Stack Area Charts
3.5.9.9. Gantt Charts
3.5.9.10. Radar Charts
3.5.9.11. Scatter Charts
3.5.9.12. Polar Charts
3.5.9.13. Column Charts with Series
3.5.9.14. Column/Bar Charts without Series
3.5.9.15. Two-Dimensional Line Combination Charts
3.5.9.16. Doughnut Charts
3.6. Drill-Down
3.6.1. Data Drill-Down
3.6.1.1. Adding Data Drill-Down
3.6.2. Dynamic Data Drill-Down
3.6.3. Parameter Drill-Down
3.6.3.1. Adding Parameter Drill-Down
3.7. Saving & Exporting Charts
3.7.1. Saving Charts with Report Data
3.7.2. Saving Charts without Report Data
3.7.2.1. Working with Templates
3.7.2.2. Saving XML Templates
3.7.2.3. Creating a Viewer Page
3.7.2.3.1. Viewer Options
3.7.3. Exporting Charts
3.7.3.1. PDF Font Mapping
3.7.3.1.1. PDF Font Mapping Import/Export
3.8. Chart Viewer
3.8.1. The Chart Viewer Parameters
3.8.2. Specifying the Data Source for Chart Viewer
3.8.2.1. Data Read From a Database
3.8.2.2. Data Read From a Data File
3.8.2.3. Data Read From an Argument
3.8.3. Using Chart Viewer
3.8.4. Axis Rulers
3.8.5. Parameter Server
3.8.6. Pop-up Menu
3.8.6.1. Changing Chart Dimension and Type
3.8.6.2. Axis Zooming
3.8.6.3. Zooming
3.8.6.4. Dynamic Data Drill Down
3.8.6.5. Query Parameter
3.8.7. Swing Version Available
3.9. EspressReport Chart API
3.9.1. Introduction and Setup
3.9.2. Recommended Approach for Using Chart API
3.9.3. Interaction with EspressManager
3.9.4. Connecting to EspressManager
3.9.4.1. EspressManager Running as Application
3.9.4.2. EspressManager Running as Servlet
3.9.5. Using the API
3.9.5.1. Loading a Chart
3.9.5.1.1. Parameterized Charts
3.9.5.1.1.1. Object Array
3.9.5.2. Applying a Chart Template
3.9.5.3. Modifying Data Source
3.9.5.3.1. Data from a Database
3.9.5.3.1.1. JNDI
3.9.5.3.2. Data from a Data File (TXT/DAT/XML)
3.9.5.3.3. Data from an XML Data Source
3.9.5.3.4. Data from Custom Implementation
3.9.5.3.5. Data passed in an Array in Memory
3.9.5.4. Modifying Chart Attributes
3.9.5.4.1. Modifying Color, Font, ...
3.9.5.4.2. Setting Predefined Patterns
3.9.5.4.3. Setting Customized Patterns
3.9.5.4.4. Modifying Size
3.9.5.4.5. Modifying Date/Time Zoom Charts
3.9.5.4.6. Modifying Chart in Report
3.9.5.5. Exporting the Chart
3.9.5.5.1. Record File Exporting
3.9.5.5.2. Streaming Charts
3.9.6. API Only Features
3.9.6.1. Visual
3.9.6.1.1. Canvas/Plot
3.9.6.1.1.1. Customizable Message for No-Data-In-Plot
3.9.6.1.1.2. Set Chart to Fit Canvas
3.9.6.1.1.3. Set Chart Invisible
3.9.6.1.1.4. Applying Different Graphics Rendering
3.9.6.1.1.5. Chart Plot Position
3.9.6.1.1.6. Drawing Multiple Charts in same Plot
3.9.6.1.2. Hint Box
3.9.6.1.2.1. Modify Hint Box
3.9.6.1.2.2. Data and Hyperlink Hint Box Offset
3.9.6.1.2.3. Hint Box Border Color
3.9.6.1.2.4. Customize Image Map Hint Box
3.9.6.1.3. Legend/Annotation
3.9.6.1.3.1. Annotation with Symbol
3.9.6.1.3.2. Set Reference Position of Legend and Annotation Text
3.9.6.1.4. Misc.
3.9.6.1.4.1. Ticker Label Replacement
3.9.6.1.4.2. Customizable Data Top Label
3.9.6.1.4.3. Show Axis as Date/Time/Timestamp
3.9.6.1.4.4. Selective String Rendering
3.9.6.1.4.5. Drawing Data Points above Horizonval/Vertical/Trend Lines
3.9.6.2. Data
3.9.6.2.1. Getting the Coordinates
3.9.6.2.2. Set Data Limit at Axis Scale
3.9.6.2.3. Set Null Data as Zero
3.9.6.2.4. Additional Trend Line Options
3.9.6.3. Chart Specific
3.9.6.3.1. Column/Bar Charts
3.9.6.3.1.1. Color Separator
3.9.6.3.1.2. Disabling Shadow
3.9.6.3.2. Pie Charts
3.9.6.3.2.1. Drawing Pie Slices Clockwise/Counter Clockwise
3.9.6.3.2.2. Pie Border for 0% and 100% Slices
3.9.6.3.2.3. Customize Separator between Category and Percent Value Strings in Pie Legend
3.9.6.3.2.4. Pie Border Color Customizable
3.9.6.3.3. Line Charts
3.9.6.3.3.1. Line Area
3.9.6.3.4. Scatter Charts
3.9.6.3.4.1. Show Series in Top Label
3.9.6.3.4.2. Drawing Order
3.9.6.3.4.3. Scatter Chart Cube Width
3.9.6.3.5. Overlay Charts
3.9.6.3.5.1. Multiple Axes Titles
3.9.6.3.6. Dial Charts
3.9.6.3.6.1. Control Area Scale Labels
3.9.6.3.7. HLCO Charts
3.9.6.3.7.1. Changing Candle Stick Color
3.9.6.3.7.2. Changing Candle Stick Wicker Width
3.9.6.3.8. Surface Charts
3.9.6.3.8.1. Heat Map
3.9.6.4. Performance
3.9.6.4.1. BufferedImage or Frame
3.9.6.4.2. Chart Generation Order
3.9.6.5. Viewer
3.9.6.5.1. Call Back Mechanism
3.9.6.5.2. Disable/Enable Tool Tips Text
3.9.6.5.3. Canvas Area
3.9.7. Changing Chart Viewer Options
3.9.8. Javadoc
3.9.9. Swing Version
3.9.10. Summary
3.A. Customizing Chart Layout
3.A.1. Changing the Chart Plot Area
3.A.2. Changing the Canvas Area
3.A.3. Fit Charts Elements
3.A.4. Changing Position of Legend Box
3.A.5. Attaching Labels to Datapoints
3.B. Getting the Chart Data
3.B.1. Data from a Database
3.B.1.1. JNDI
3.B.2. Data from a Data file (TXT/DAT/XML)
3.B.3. Data from a XML Data Source
3.B.4. Data Passed in an Array in Memory
3.B.5. Data Passed in your Custom Implementation
3.B.6. Data from a Spreadsheet Model
3.B.7. Data from Enterprise Java Beans (EJBs)
3.B.8. Data from multiple Data Sources
3.B.9. Data in Spreadsheet Format
3.B.10. Transposing Data
3.B.10.1. Non-Selective Transposing
3.B.10.2. Selective Transposing
3.C. Creating the Chart
3.C.1. Column, Bar, Line, Area, Pie and Overlay Charts
3.C.1.1. Column Mapping
3.C.1.2. Creating the Chart
3.C.2. Radar Charts
3.C.2.1. Column Mapping
3.C.2.2. Creating the Chart
3.C.3. XY(Z) Scatter Charts
3.C.3.1. Column Mapping
3.C.3.2. Creating the Chart
3.C.4. Stack Column, Percentage Column, Stack Bar and Stack Area Charts
3.C.4.1. Column Mapping
3.C.4.2. Creating the Chart
3.C.5. Dial Charts
3.C.5.1. Column Mapping
3.C.5.2. Creating the Chart
3.C.6. Box Charts
3.C.6.1. Column Mapping
3.C.6.2. Creating the Chart
3.C.7. Bubble Charts
3.C.7.1. Column Mapping
3.C.7.2. Creating the Chart
3.C.8. High-Low and HLCO Charts
3.C.8.1. Column Mapping
3.C.8.2. Creating the Chart
3.C.9. Surface Charts
3.C.9.1. Column Mapping
3.C.9.2. Creating the Chart
3.C.10. Gantt Charts
3.C.10.1. Column Mapping
3.C.10.2. Creating the Chart
3.C.11. Polar Charts
3.C.11.1. Column Mapping
3.C.11.2. Creating the Chart
3.C.12. Date/Time Based Zoom Charts
3.C.13. Parameterized Charts
3.C.14. Drill Down Charts
3.C.14.1. Parameter Drill Down Charts
3.C.14.2. Data Drill Down Charts
3.C.14.3. Dynamic Data Drill Down Charts
3.C.15. Adding a Chart to a Report
3.C.15.1. Adding a Chart Template
3.C.15.2. Adding a Chart that uses Report Data
3.C.15.3. Adding a Chart that uses an Independent Data Source
4. Internationalization
4.1. Internationalizing EspressReport
4.1.1. Specifying Locales
4.1.1.1. Locale-Specific Formatting
4.1.1.2. Setting Time Zones and Locales Using the API
4.1.2. Language and Encoding
4.1.2.1. EspressReport Language Translation
4.1.2.1.1. Upgrading Language File
4.1.2.2. Displaying Foreign Characters
4.1.2.3. Entering Foreign Characters
4.1.2.4. XML Encoding
4.1.2.5. Exporting With Foreign Characters
4.1.2.6. Specifying Encoding for Text Data Files