EspressChart 7.0 User's Guide

Q. QuickStart
Q.1. Start Chart Designer
Q.2. Start a new chart & setup a data source registry
Q.3. Set up Data Sources in the Registry
Q.4. Build a query
Q.5. Build a chart
Q.6. Customize chart properties
Q.7. Save and export the chart
1. Overview/Introduction
1.1. Using this Guide
1.2. EspressChart Components
1.3. EspressChart Architecture
2. Installation/Configuration
2.1. Running the Installer
2.2. Configuration
2.2.1. Increasing maximum memory heap size for applets
2.3. Starting EspressManager
2.3.1. Starting EspressManager as a Servlet Deploying EspressManager as a Servlet in Tomcat
2.4. Starting Chart Designer
2.4.1. Connecting to EspressManager Running as a Servlet
2.5. Backward compatibility patches
3. Charting Basics
3.1. What is a Chart
3.2. Basic Data Mapping
3.3. Saving and Exporting Charts
3.3.1. Saving Chart Definitions
3.3.2. Generating Image Files
4. Working with Data Sources
4.1. The Data Source Manager
4.1.1. Using Data Source Manager
4.2. Data from a Database
4.2.1. JNDI Data Sources
4.2.2. Queries Using Query Builder Tables Joins Columns Using Database Functions Adding Extra SQL Query Output Parameterized Queries Multi-Value Parameters Initializing Query Parameters All Parameters Entering SQL Statements Calling Oracle Stored Procedures
4.2.3. Data Views Data View Parameters Updating Data View Queries
4.2.4. Editing Queries
4.2.5. Editing Database Connections
4.3. Data from XML and XBRL Files
4.3.1. XMLQueries XML Parameters
4.4. Data from Text Files
4.4.1. Formatting Requirements for Text Files
4.4.2. Data Types and Format for Text Files
4.5. Data from Class Files
4.5.1. Parameterized Class Files
4.6. Data from EJBs
4.7. Data from SOAP with WSDL support
4.8. Data from Salesforce
4.9. Data from Excel files
4.10. Using Data for Charts
4.10.1. Using Multiple Data Sources
4.10.2. Change Data Source
4.11. Data Source Updating
5. Chart Types and Data Mapping
5.1. Data Mapping
5.1.1. Data Transposition
5.2. Column Charts
5.2.1. Data Mapping
5.3. Bar Charts
5.3.1. Data Mapping
5.4. XY(Z) Scatter Charts
5.4.1. Data Mapping
5.5. Line Charts
5.5.1. Data Mapping
5.6. Stack Column Charts
5.6.1. Data Mapping
5.7. Stack Bar Charts
5.7.1. Data Mapping
5.8. Pie Charts
5.8.1. Data Mapping
5.9. Area Charts
5.9.1. Data Mapping
5.10. Stack Area Charts
5.10.1. Data Mapping
5.11. High-Low Charts
5.11.1. Data Mapping
5.12. HLCO Charts
5.12.1. Data Mapping
5.13. Percentage Column Charts
5.13.1. Data Mapping
5.14. Doughnut Charts
5.14.1. Data Mapping
5.15. Surface Charts
5.15.1. Data Mapping
5.16. Bubble Charts
5.16.1. Data Mapping
5.17. Overlay Charts
5.17.1. Data Mapping
5.18. Box Charts
5.18.1. Data Mapping
5.19. Radar Charts
5.19.1. Data Mapping
5.20. Dial Charts
5.20.1. Data Mapping
5.20.2. Gauges
5.21. Gantt Charts
5.21.1. Data Mapping
5.22. Polar Charts
5.22.1. Data Mapping
5.23. Changing Data Mapping or Data Source
6. The Designer Interface
6.1. The Designer Menus
6.1.1. File Menu
6.1.2. Insert Menu:
6.1.3. Format Menu
6.1.4. Type Menu
6.1.5. Drill-Down Menu
6.1.6. Data Menu
6.1.7. Help Menu
6.1.8. Layout Menu
6.2. The Designer Toolbar
6.3. Color, Color set, Pattern, and Font Panels
6.3.1. Color Panel
6.3.2. Color Set Panel Save Colors for Categories feature
6.3.3. Pattern Panel
6.3.4. Font Panel
6.4. The Navigation Panel
6.5. The Viewport
6.5.1. The Chart Canvas Background Images
6.5.2. Moving and Sizing Chart Elements
6.6. Adding Chart Elements
6.6.1. Adding Text TextVariables Text Replacement Automatic Text Resizing Text Cropping
6.6.2. Adding Lines Line and Point Formatting Floating Lines Fixed Horizontal/Vertical Lines Multiple control lines for Stack Type Charts Trend Lines Normal Distribution Curve
6.6.3. Adding Control Areas
6.6.4. Adding Tables
6.6.5. Adding Hyperlinks Viewing Hyperlinks
6.7. Formatting Chart Axes
6.7.1. Axis Scale
6.7.2. Axis Elements Axis Label Formatting
6.8. Formatting Plot/Data Elements
6.8.1. Data Properties
6.8.2. Date/Time Based Zooming Adding Zooming Zooming In Chart Viewer
6.8.3. Data Ordering Top/Bottom N Charts
6.8.4. Histograms
6.8.5. Formatting Plot Area
6.8.6. Formatting Chart Legend
6.8.7. 3D Display Options
6.8.8. Data Border
6.8.9. Aggregation
6.9. Chart-Specific Options
6.9.1. Bubble Charts
6.9.2. Dial Charts Gauge Images
6.9.3. Overlay Charts
6.9.4. Pie Charts
6.9.5. Line Charts: Double Value Line Charts
6.9.6. HLCO Charts
6.9.7. Box Charts
6.9.8. Stack Area Charts
6.9.9. Gantt Charts
6.9.10. Radar Charts
6.9.11. Scatter Charts
6.9.12. Polar Charts
6.9.13. Column Charts with Series
6.9.14. Column/Bar Charts without Series
6.9.15. Two-Dimensional Line Combination Charts
6.9.16. Doughnut Charts
6.10. Chart Designer in Mac OS X
7. Drill-Down
7.1. Data Drill-Down
7.1.1. Adding Data Drill-Down
7.2. Dynamic Data Drill-Down
7.3. Parameter Drill-Down
7.3.1. Adding Parameter Drill-Down
8. Saving & Exporting Charts
8.1. Saving Charts
8.1.1. Working with Templates
8.1.2. Saving XML Templates
8.1.3. Creating a Viewer Page Viewer Options
8.2. Exporting Charts
8.2.1. PDF Font Mapping PDF Font Mapping Import/Export
9. Chart Viewer
9.1. The Chart Viewer Parameters
9.2. Specifying the Data Source for Chart Viewer
9.2.1. Data Read From a Database
9.2.2. Data Read From a Data File
9.2.3. Data Read From an Argument
9.3. Using Chart Viewer
9.4. Axis Rulers
9.5. Parameter Server
9.6. Pop-up Menu
9.6.1. Changing Chart Dimension and Type
9.6.2. Axis Zooming
9.6.3. Zooming
9.6.4. Dynamic Data Drill-Down
9.6.5. Query Parameter
9.7. Swing Version Available
10. EspressChart Chart API
10.1. Introduction and Setup
10.2. Recommended Approach for Using Chart API
10.3. Interaction with EspressManager
10.4. Connecting to EspressManager
10.4.1. EspressManager Running as Application
10.4.2. EspressManager Running as Servlet
10.5. Using the API
10.5.1. Loading a Chart Parameterized Charts Object Array
10.5.2. Applying a Chart Template
10.5.3. Modifying Data Source Data from a Database JNDI Data from a Data File (TXT/DAT/XML) Data from an XML Data Source Data from Custom Implementation Data passed in an Array in Memory
10.5.4. Modifying Chart Attributes Modifying Color, Font, ... Setting Predefined Patterns Setting Customized Patterns Modifying Size Modifying Date/Time Zoom Charts
10.5.5. Exporting the Chart Record File Exporting Streaming Charts
10.5.6. Calling Chart Designer from Chart API Specify a Chart Template Specify a Data Registry Specify a DBInfo Object (Database Information) Open Query Builder with a Specified DBInfo Object (Database Information) Open Chart Designer with pre-set Directories Open Chart Designer with Modified Menubar and Toolbar
10.6. API Only Features
10.6.1. Visual Canvas/Plot Customizable Message for No-Data-In-Plot Set Chart to Fit Canvas Set Chart Invisible Applying Different Graphics Rendering Chart Plot Position Drawing Multiple Charts in same Plot Hint Box Modify Hint Box Data and Hyperlink Hint Box Offset Hint Box Border Color Customize Image Map Hint Box Legend/Annotation Annotation with Symbol Set Relative Shift of Annotation Border Set Reference Position of Legend and Annotation Text Misc. Ticker Label Replacement Customizable Data Top Label Show Axis as Date/Time/Timestamp Selective String Rendering Drawing Data Points above Horizonval/Vertical/Trend Lines
10.6.2. Data Getting the Coordinates Set Data Limit at Axis Scale Set Null Data as Zero Additional Trend Line Options Adding Multiple Control Lines to Stack Type Chart
10.6.3. Chart Specific Column/Bar Charts Color Separator Disabling Shadow Pie Charts Drawing Pie Slices Clockwise/Counter Clockwise Pie Border for 0% and 100% Slices Customize Separator between Category and Percent Value Strings in Pie Legend Pie Border Color Customizable Line Charts Line Area Scatter Charts Show Series in Top Label Drawing Order Scatter Chart Cube Width Overlay Charts Multiple Axes Titles Dial Charts Control Area Scale Labels HLCO Charts Changing Candle Stick Color Changing Candle Stick Wicker Width Surface Charts Heat Map
10.6.4. Performance BufferedImage or Frame Chart Generation Order
10.6.5. Viewer Call Back Mechanism Disable/Enable Tool Tips Text Canvas Area
10.7. Changing Chart Viewer Options
10.8. Javadoc
10.9. Swing Version
10.10. Summary
10.A. Getting the Chart Data
10.A.1. Data from a Database
10.A.1.1. JNDI
10.A.2. Data from a Data file (TXT/DAT/XML)
10.A.3. Data from a XML Data Source
10.A.4. Data Passed in an Array in Memory
10.A.5. Data Passed in your Custom Implementation
10.A.6. Data from a Spreadsheet Model
10.A.7. Data from Enterprise Java Beans (EJBs)
10.A.8. Data from a SOAP Data Source
10.A.8.1. Example SOAP Service
10.A.9. Data from multiple Data Sources
10.A.10. Data in Spreadsheet Format
10.A.11. Transposing Data
10.A.11.1. Non-Selective Transposing
10.A.11.2. Selective Transposing
10.B. Creating the Chart
10.B.1. Column, Bar, Line, Area, Pie and Overlay Charts
10.B.1.1. Column Mapping
10.B.1.2. Creating the Chart
10.B.2. Radar Charts
10.B.2.1. Column Mapping
10.B.2.2. Creating the Chart
10.B.3. XY(Z) Scatter Charts
10.B.3.1. Column Mapping
10.B.3.2. Creating the Chart
10.B.4. Stack Column, Percentage Column, Stack Bar and Stack Area Charts
10.B.4.1. Column Mapping
10.B.4.2. Creating the Chart
10.B.5. Dial Charts
10.B.5.1. Column Mapping
10.B.5.2. Creating the Chart
10.B.6. Box Charts
10.B.6.1. Column Mapping
10.B.6.2. Creating the Chart
10.B.7. Bubble Charts
10.B.7.1. Column Mapping
10.B.7.2. Creating the Chart
10.B.8. High-Low and HLCO Charts
10.B.8.1. Column Mapping
10.B.8.2. Creating the Chart
10.B.9. Surface Charts
10.B.9.1. Column Mapping
10.B.9.2. Creating the Chart
10.B.10. Gantt Charts
10.B.10.1. Column Mapping
10.B.10.2. Creating the Chart
10.B.11. Polar Charts
10.B.11.1. Column Mapping
10.B.11.2. Creating the Chart
10.B.12. Date/Time Based Zoom Charts
10.B.13. Parameterized Charts
10.B.14. Drill-Down Charts
10.B.14.1. Parameter Drill-Down Charts
10.B.14.2. Data Drill-Down Charts
10.B.14.3. Dynamic Data Drill-Down Charts
11. Servlets and JavaServer Pages
11.1. Servlets
11.1.1. Introduction
11.1.2. Setup
11.1.3. Running Under Apache Tomcat JRun ColdFusion Server WebLogic 6.0 WebLogic 9.2 WebSphere 3.5 WebSphere 6.1 JBoss 4.0.5 Orion 2.0.7 JRun 4 (with Update 6) Oracle 10g ( Sun Java System Application PE (9.0, 8.2) Sun Java System WebServer 7.0 Resing 3.1.0 ColdFusion MX 7.02
11.1.4. Running the Servlet
11.2. JavaServer Pages (JSP)
11.2.1. Introduction
11.2.2. Running Under Apache Tomcat WebSphere
11.3. Saving a Chart to File versus Sending it to a Browser
11.3.1. Saving the Chart to a File
11.3.2. Sending the Chart Directly to a Browser
12. Deployment
12.1. Introduction
12.2. Deploying with EspressManager
12.2.1. Chart Designer
12.2.2. Chart Viewer
12.2.3. Chart API
12.3. Deploying without EspressManager
12.3.1. Chart Viewer
12.3.2. Chart API
12.4. Deploying in a Non-Windows Enviroment
12.4.1. Xvfb (X Virtual Frame Buffer)
12.4.2. JVM 1.4+ in Headless Mode
12.5. Platform Specific Issues
12.5.1. AS/400 Running under NAWT Running under Headless Mode
12.5.2. Linux/Unix Running under X Running under Headless Mode
13. Internationalization
13.1. Internationalizing EspressChart
13.1.1. Specifying Locales Locale-Specific Formatting Setting Time Zones and Locales Using the API
13.1.2. Language and Encoding EspressChart Language Translation Upgrading Language File Displaying Foreign Characters Entering Foreign Characters XML Encoding
A. Parameter Server
A.1. Writing a Parameter Server
A.1.1. Variables
A.1.2. Constructor
A.1.3. Methods
B. Customizing Chart Layout
B.1. Changing the Chart Plot Area
B.2. Changing the Canvas Area
B.3. Fit Charts Elements
B.4. Changing Position of Legend Box
B.5. Attaching Labels to Datapoints