EspressReport ES 7.0 User's Guide

Q. QuickStart
Q.1. Overview
Q.1.1. Setup
Q.2. Getting Started
Q.2.1. Create a User
Q.2.2. Start the Organizer
Q.2.2.1. Login as User
Q.2.2.2. Add a Project
Q.3. Setup Data Sources
Q.3.1. Create a Data Registry
Q.3.1.1. Setup Database Connections
Q.3.1.1.1. Setup a JDBC Connection
Q.3.1.2. Create a Query
Q.3.1.2.1. Add Query Parameters
Q.3.1.3. Create a Data View
Q.3.1.3.1. Query a Data View
Q.3.1.4. Setup a Text Data Source
Q.4. Report Designer
Q.4.1. Report Mapping
Q.4.1.1. Simple Columnar Layout
Q.4.1.2. Summary Break Layout
Q.4.1.3. Crosstab Layout
Q.4.1.4. Master & Details Layout
Q.4.1.5. Mailing Labels Layout
Q.4.2. Basic Report Formatting
Q.4.2.1. Add a Report Template to Organizer
Q.4.2.2. Move and Align Report Elements
Q.4.2.3. Data Formatting
Q.4.2.4. Set Dual Colors
Q.4.2.5. Inserting Elements
Q.4.2.5.1. Insert an Image
Q.4.2.5.2. Insert a Title
Q.4.2.5.3. Insert a Line
Q.4.2.6. View Report Elements in Report Explorer
Q.4.2.7. Set Section Options
Q.4.3. Advanced Reporting Features
Q.4.3.1. Formulas & Scripting
Q.4.3.2. Add a Formula
Q.4.3.3. Add a Script
Q.4.3.3.1. Add an Aggregation
Q.4.3.4. Drill-Down
Q.4.3.5. Sub-Reports
Q.5. Chart Designer
Q.5.1. Chart Mapping
Q.5.1.1. Column Chart
Q.5.1.1.1. Add a Data Series
Q.5.1.1.2. 3D Column Chart
Q.5.1.2. Pie Chart
Q.5.1.3. Stack Column Chart
Q.5.2. Basic Chart Formatting
Q.5.2.1. Axis Options
Q.5.2.2. Modify Color and Font
Q.5.2.3. Add Titles
Q.5.2.4. Customize Plot Area
Q.5.3. Advanced Charting Features
Q.5.3.1. Time-Series Zooming
Q.5.3.2. Control Areas
Q.6. QuickDesigner Reports
Q.6.1. Create a Query
Q.6.2. Create a Report
Q.6.2.1. Format Report Elements
Q.6.2.2. Save the Report
Q.7. QuickDesigner Charts
Q.7.1. Create a Chart
Q.7.1.1. Format Chart Elements
Q.7.1.2. Save the Chart
Q.8. Online Maps
Q.8.1. Create Coordinates
Q.8.2. Create Online Map
Q.8.2.1. Configure Tooltips
Q.8.2.2. Setting Drilldowns
Q.9. SVG Maps
Q.9.1. Create a Map
Q.9.2. Set SVG Map Thresholds
Q.9.2.1. Add a Map Title
Q.9.3. Set SVG Map Drilldowns
Q.10. Publishing
Q.10.1. Dashboards
Q.10.1.1. Create a Dashboard
Q.10.1.2. Save the Dashboard
Q.10.1.3. Export Dashboard to PDF
Q.10.2. URLs
Q.10.3. The Menu Page
Q.11. Alerts
Q.11.1. Alerts in Charts
Q.11.2. Alerts in Maps
Q.11.3. Alerts in Dashboards
Q.11.3.1. Sound alerts and alert messages
Q.11.4. Alert Monitoring
Q.12. API
Q.12.1. Set Up Environment
Q.12.2. Run a Report
Q.12.2.1. JSP Application
Q.12.2.2. LookupServlet Servlet
Q.12.3. Create a Report Programmatically
Q.12.3.1. Map Summary Break ColInfo
Q.12.3.2. Apply Template
Q.12.4. Create a Chart Programmatically
Q.12.4.1. Map Column Chart ColInfo
Q.12.4.2. Apply Template
Q.12.5. Modify Data Source of a Report
Q.12.5.1. Modify Data Source of a Report (with Sub-Report)
Q.12.5.2. Modify Data Source of a Parameterized Report (with Parameterized Sub-Report)
Q.12.6. Modify Report Elements
Q.12.7. Parameterized Reports
Q.12.7.1. Pass in Parameter values
Q.12.7.2. Pass in Parameter values using getAllParameters
Q.12.7.3. Use getParameterPage(and ParamReportGeneratorServlet)
Q.12.8. Deploy/Export Drill-Down
Q.12.9. Launch Report Designer
1. Administration
1.1. Overview & Architecture
1.1.1. ERES Components
1.1.2. ERES Architecture
1.2. New Features List V7.0
1.2.1. New EspressReport ES Features
1.2.1.1. Dashboard Builder (Chapter 6 - Designing Dashboards)
1.2.1.2. QuickDesigner Reports (Section 4.3 - QuickDesigner Reports)
1.2.1.3. QuickDesigner Charts (Section 4.4 - QuickDesigner Charts)
1.2.1.4. Online Maps (Section 5.2 - Online Maps)
1.2.1.5. SVG Maps (Section 5.3 - SVG Maps)
1.3. Installation and Configuration
1.3.1. Installing ERES
1.3.1.1. Re-Install/Update
1.3.2. Configuration
1.3.2.1. The ERES Database
1.3.2.1.1. Using a Different Database
1.3.2.1.2. Running HSQL in Client-Server Mode
1.3.2.1.3. Upgrading ERES Database from previous version of ERES
1.3.2.2. Starting the Server
1.3.2.3. Increasing maximum memory heap size for applets
1.3.3. Backward compatibility patches
1.3.4. Run Applets in WebStart with JNLP file
1.4. Administration
1.4.1. The Console Interface
1.4.1.1. User List
1.4.1.1.1. Importing Users and Groups
1.4.1.1.2. Using Existing Users/Groups
1.4.1.1.3. Setting User/Group Security Levels
1.4.1.2. Setting Info
1.4.1.3. Server Options
1.4.1.3.1. Secured Parameter
1.4.1.4. LDAP Settings
1.4.1.5. Customization
1.4.2. User Settings
1.A. ERES Details Log
1.B. Server Commands
2. Organizer
2.1. Using the Organizer
2.1.1. Starting the Organizer
2.1.2. The Organizer Interface
2.1.2.1. The Organizer Menus
2.1.2.1.1. File Menu
2.1.2.1.2. Edit Menu
2.1.2.1.3. Publish Menu
2.1.2.1.4. View Menu
2.1.2.1.5. Schedule/Archive Menu
2.1.2.1.6. Option Menu
2.1.2.1.7. Help Menu
2.1.2.2. The Organizer Toolbar
2.1.3. Projects and Folders
2.1.3.1. Creating and Modifying Projects and Folders
2.1.4. Files
2.1.4.1. Adding and Modifying Files
2.1.4.2. Arranging Files
2.1.4.3. File Identification Icons
2.1.4.4. Report Locking
2.1.4.5. Dashboard and Map Packages
2.1.5. URL Mapping
2.1.6. Repairing Broken Links
2.1.7. Update Directory
2.1.8. Searching in Organizer
2.1.9. Limiting Browse Directories
2.2. Scheduling & Archiving
2.2.1. Setting a Schedule
2.2.1.1. Scheduling Parameterized Reports/Charts
2.2.1.2. Additional Delivery Options
2.2.1.2.1. Email Delivery Options
2.2.1.2.2. FTP Delivery Options
2.2.1.2.3. Printer Delivery Options
2.2.1.3. Specifying Email Recipients
2.2.1.3.1. Report Bursting
2.2.1.4. Schedule Summary
2.2.2. Setting an Archive
2.2.3. View Tasks
2.2.3.1. Editing Schedules and Archives
2.2.3.2. Schedule and Archive Logs
2.3. Security and Security Administration
2.3.1. Security Concepts
2.3.2. Setting User Privileges
2.3.2.1. Changing Ownership
2.3.2.2. Folder/File Permissions
2.3.3. Security Levels
2.3.3.1. Associating Security Levels with Users and Groups
3. Data Sources
3.1. Data in Organizer
3.1.1. Managing Data Registries
3.1.1.1. Exporting/Importing Data Registries
3.1.1.2. Data Registry Privileges
3.1.2. The Data Source Manager
3.1.2.1. Using Data Source Manager
3.1.2.2. Data Source Node Locking
3.1.3. Data from a Database
3.1.3.1. JNDI Data Sources
3.1.3.2. Queries
3.1.3.2.1. Using Query Builder
3.1.3.2.1.1. Tables
3.1.3.2.1.2. Joins
3.1.3.2.1.3. Columns
3.1.3.2.1.4. Using Database Functions
3.1.3.2.1.5. Adding Extra SQL
3.1.3.2.1.6. Query Output
3.1.3.2.2. Parameterized Queries
3.1.3.2.2.1. Multi-Value Parameters
3.1.3.2.2.2. Initializing Query Parameters
3.1.3.2.2.3. Cascading Parameters
3.1.3.2.2.4. All Parameters
3.1.3.2.3. Entering SQL Statements
3.1.3.2.3.1. Calling Oracle Stored Procedures
3.1.3.3. Data Views
3.1.3.3.1. Data View Parameters
3.1.3.3.2. Updating Data View Queries
3.1.3.3.3. Data View Security
3.1.3.4. Editing Queries
3.1.3.5. Editing Database Connections
3.1.3.6. Troubleshooting Database Connections
3.1.4. Data from XML and XBRL Files
3.1.4.1. XMLQueries
3.1.4.1.1. XML Parameters
3.1.5. Data from Text Files
3.1.5.1. Formatting Requirements for Text Files
3.1.5.2. Data Types and Format for Text Files
3.1.6. Data from Class Files
3.1.6.1. Parameterized Class Files
3.1.7. Data from EJBs
3.1.8. Data from SOAP with WSDL support
3.1.9. Data from Salesforce
3.1.10. Data from Excel files
3.1.11. Using Data for Charts and Reports
3.1.11.1. Using Multiple Data Sources
3.1.11.2. Change Data Source
3.1.12. Data Source Updating
3.1.13. CData JDBC drivers
3.1.13.1. Supported CData Drivers
3.1.13.1.1. Excel
3.1.13.1.2. JSON
3.1.13.1.3. Salesforce
3.1.13.1.4. MongoDB
3.1.13.1.5. BigQuery
3.1.13.1.6. Kintone
3.1.13.2. CData JDBC driver installation
3.1.13.3. Deploying the CData JDBC Driver in EspressReport ES
3.1.13.4. Using the CData JDBC drivers in DataSource Manager
3.2. Data in QuickDesigners and Maps
3.2.1. Select a Data Source
3.2.2. Queries
3.2.2.1. Select Fields
3.2.2.1.1. Build Columns
3.2.2.1.2. Querying Encrypted Data
3.2.2.2. Set Conditions
3.2.2.2.1. Parameterized Queries
3.2.2.2.1.1. Initialize Query Parameters
3.2.2.2.2. Save Queries
3.2.2.2.3. Aggregation Alias
3.2.2.3. View SQL Query
3.2.2.4. Preview Query Results
4. Designing Reports & Charts
4.1. Report Designer
4.1.1. Introduction to Report Designer
4.1.1.1. Starting Report Designer
4.1.1.2. Selecting a Data Source
4.1.2. Report Types and Data Mapping
4.1.2.1. Simple Columnar Report
4.1.2.1.1. Data Mapping
4.1.2.1.1.1. Top N Report
4.1.2.2. Summary Break Report
4.1.2.2.1. Data Mapping
4.1.2.2.1.1. Top N Report
4.1.2.3. Crosstab Report
4.1.2.3.1. Data Mapping
4.1.2.3.2. Transposing Data
4.1.2.4. Master & Details Report
4.1.2.4.1. Data Mapping
4.1.2.4.1.1. Top N Report
4.1.2.5. Mailing Label Report
4.1.2.5.1. Data Mapping
4.1.2.6. Additional Formatting Options
4.1.2.6.1. Custom Styles
4.1.2.6.1.1. Creating a Custom Style
4.1.2.7. Fit Columns to Page Width
4.1.2.8. Change Data Mapping
4.1.2.9. Keep Data Source Order
4.1.3. The Designer Interface
4.1.3.1. Report Sections
4.1.3.1.1. Nested Sections
4.1.3.2. Resizing Sections
4.1.3.3. Section Options
4.1.3.4. Rulers
4.1.3.4.1. Toggling Between Inches and Centimeters
4.1.3.5. Designer Menus
4.1.3.5.1. File Menu
4.1.3.5.2. Edit Menu
4.1.3.5.3. Insert Menu
4.1.3.5.4. Format Menu
4.1.3.5.5. View Menu
4.1.3.5.6. Data Menu
4.1.3.5.7. Drill-Down Menu
4.1.3.5.8. Option Menu
4.1.3.5.9. Help Menu
4.1.3.6. Designer Toolbar
4.1.3.7. Inserting and Manipulating Report Elements
4.1.3.7.1. Inserting Elements
4.1.3.7.1.1. Inserting Charts
4.1.3.7.1.2. Inserting Elements into the Table Data Section
4.1.3.7.2. Editing Elements
4.1.3.7.2.1. Editing Element Attributes
4.1.3.7.2.2. Word Wrapping
4.1.3.7.2.3. Editing Side-By-Side Master & Details Reports
4.1.3.7.3. Data Formatting for Formulas and Column Fields
4.1.3.7.3.1. Formatting Null Data
4.1.3.7.4. Line/Rectangle Format
4.1.3.7.5. Chart Export Format
4.1.3.7.6. Font, Color, and Border Options
4.1.3.7.6.1. Show Cell Outline
4.1.3.7.7. Rich Text Fields
4.1.3.7.7.1. Adding Formulas
4.1.3.7.8. Hyperlinks
4.1.3.7.9. Column Wrapping
4.1.3.7.10. Table of Contents
4.1.3.7.10.1. Adding a Table of Contents
4.1.3.7.11. Moving and Resizing Report Elements
4.1.3.7.11.1. Controlling Element Overlapping
4.1.3.7.11.2. Locking Element Position
4.1.3.7.12. Snap to Grid
4.1.3.7.13. Shift Mode
4.1.3.7.14. Guidelines
4.1.3.7.14.1. Inserting Guidelines
4.1.3.7.14.2. Positioning Elements with Guidelines
4.1.3.8. The Report Explorer
4.1.3.9. Global Formatting, Group Formatting, and Templates
4.1.3.9.1. Global Formatting
4.1.3.9.1.1. Global Format Import/Export
4.1.3.9.1.2. Global Formatting & Crosstab Reports
4.1.3.9.2. Group Formatting
4.1.3.9.3. Applying a Template
4.1.4. The Preview Window
4.1.4.1. Navigating the Report
4.1.4.2. Other Preview Window Options
4.1.4.2.1. Preview Data Options
4.1.4.2.2. Sorting Data
4.1.4.2.3. Parameter Prompts
4.1.4.2.4. Using Page Viewer
4.1.4.3. Setting Page Properties
4.1.5. Saving and Exporting Reports
4.1.5.1. Saving Reports
4.1.5.1.1. XML Encoding
4.1.5.2. Exporting Reports
4.1.5.2.1. PDF Font Mapping
4.1.5.2.1.1. PDF Font Mapping Import/Export
4.1.5.2.2. CSS Options
4.1.6. Using Formulas & the Formula Builder
4.1.6.1. Creating a Formula
4.1.6.1.1. The Formula Builder
4.1.6.2. Formula Syntax
4.1.6.2.1. Using Column Field Data
4.1.6.2.1.1. Column Aggregation
4.1.6.2.2. Using Formulas
4.1.6.2.3. Using Parameter Values
4.1.6.2.4. Using Database Fields
4.1.6.2.5. Constants
4.1.6.2.6. Formula Parameters
4.1.6.2.6.1. Initializing Formula Parameters
4.1.6.2.7. Operators
4.1.6.2.7.1. Arithmetic Operators
4.1.6.2.7.2. Boolean Operators
4.1.6.2.8. Functions
4.1.6.2.8.1. Numeric Functions
4.1.6.2.8.2. String Functions
4.1.6.2.8.3. Date/Time Functions
4.1.6.2.8.4. Table Data Functions
4.1.6.2.8.5. Other Functions
4.1.6.2.8.6. Custom Functions
4.1.6.3. Subreport Formula Access
4.1.7. Scripting
4.1.7.1. Creating a Script
4.1.7.2. Script Syntax
4.1.7.2.1. Formatting Actions
4.1.7.2.1.1. Scripting Image URLs
4.1.7.2.2. Variables & Arrays
4.1.7.2.2.1. Variables
4.1.7.2.2.2. Arrays
4.1.7.2.3. Using Formulas
4.1.7.2.4. Checking for Nulls
4.1.7.2.5. Row-Specific Options
4.1.7.2.6. Loops
4.1.7.2.7. Section Scripts
4.1.7.2.7.1. Formatting Actions for Section Scripts
4.1.7.2.8. Commenting Scripts
4.1.7.2.9. Accessing Values Computed by Other Scripts
4.1.7.3. Managing Scripts
4.1.8. Drill-Down
4.1.8.1. Creating a Drill-Down Report
4.1.8.1.1. Drill-Down Links
4.1.8.1.1.1. Linking from Charts
4.1.8.2. Multi-Value Drill-Down
4.1.8.2.1. Creating a Multi-Value Drill-Down Report
4.1.8.3. Crosstab Drill-Down
4.1.8.3.1. Creating a Crosstab Drill-Down Report
4.1.8.4. Viewing Drill-Down Reports
4.1.8.5. Unmapped Drill-Down
4.1.9. Sub-Reports
4.1.9.1. Adding a Sub-Report
4.1.9.2. Editing a Sub-Report
4.1.9.2.1. Sub-Report sizing
4.1.9.3. Removing a Sub-Report
4.1.9.4. Linked Sub-Reports
4.1.9.4.1. Using Linked Sub-Reports
4.1.9.5. Parameter Linking
4.1.10. Template Security
4.1.10.1. Security Levels
4.1.10.2. Cell-Level Security
4.1.10.2.1. Security Parameters
4.1.10.3. Security for Sub-Reports & Drill-Down Layers
4.1.10.4. Viewing Secured Templates
4.1.10.4.1. Secured Report Designer
4.2. Chart Designer
4.2.1. Introduction to Chart Designer
4.2.1.1. Working with Charts
4.2.1.2. Starting Chart Designer
4.2.1.3. Selecting a Data Source
4.2.1.3.1. Chart Parameter Linking
4.2.1.3.2. Transposing Data
4.2.2. Charting Basics
4.2.2.1. What is a Chart
4.2.2.2. Basic Data Mapping
4.2.2.3. Saving and Exporting Charts
4.2.2.3.1. Saving Chart Definitions
4.2.2.3.2. Generating Image Files
4.2.3. Chart Types and Data Mapping
4.2.3.1. Data Mapping
4.2.3.1.1. Data Transposition
4.2.3.2. Column Charts
4.2.3.2.1. Data Mapping
4.2.3.3. Bar Charts
4.2.3.3.1. Data Mapping
4.2.3.4. XY(Z) Scatter Charts
4.2.3.4.1. Data Mapping
4.2.3.5. Line Charts
4.2.3.5.1. Data Mapping
4.2.3.6. Stack Column Charts
4.2.3.6.1. Data Mapping
4.2.3.7. Stack Bar Charts
4.2.3.7.1. Data Mapping
4.2.3.8. Pie Charts
4.2.3.8.1. Data Mapping
4.2.3.9. Area Charts
4.2.3.9.1. Data Mapping
4.2.3.10. Stack Area Charts
4.2.3.10.1. Data Mapping
4.2.3.11. High-Low Charts
4.2.3.11.1. Data Mapping
4.2.3.12. HLCO Charts
4.2.3.12.1. Data Mapping
4.2.3.13. Percentage Column Charts
4.2.3.13.1. Data Mapping
4.2.3.14. Doughnut Charts
4.2.3.14.1. Data Mapping
4.2.3.15. Surface Charts
4.2.3.15.1. Data Mapping
4.2.3.16. Bubble Charts
4.2.3.16.1. Data Mapping
4.2.3.17. Overlay Charts
4.2.3.17.1. Data Mapping
4.2.3.18. Box Charts
4.2.3.18.1. Data Mapping
4.2.3.19. Radar Charts
4.2.3.19.1. Data Mapping
4.2.3.20. Dial Charts
4.2.3.20.1. Data Mapping
4.2.3.20.2. Gauges
4.2.3.21. Gantt Charts
4.2.3.21.1. Data Mapping
4.2.3.22. Polar Charts
4.2.3.22.1. Data Mapping
4.2.3.23. Changing Data Mapping or Data Source
4.2.4. The Chart Designer Interface
4.2.4.1. The Designer Menus
4.2.4.1.1. File Menu
4.2.4.1.2. Insert Menu:
4.2.4.1.3. Format Menu
4.2.4.1.4. Type Menu
4.2.4.1.5. Drill-Down Menu
4.2.4.1.6. Data Menu
4.2.4.1.7. Help Menu
4.2.4.1.8. Layout Menu
4.2.4.2. The Designer Toolbar
4.2.4.3. Color, Color set, Pattern, and Font Panels
4.2.4.3.1. Color Panel
4.2.4.3.2. Color Set Panel
4.2.4.3.2.1. Save Colors for Categories feature
4.2.4.3.3. Pattern Panel
4.2.4.3.4. Font Panel
4.2.4.4. The Navigation Panel
4.2.4.5. The Viewport
4.2.4.5.1. The Chart Canvas
4.2.4.5.1.1. Background Images
4.2.4.5.2. Moving and Sizing Chart Elements
4.2.4.6. Adding Chart Elements
4.2.4.6.1. Adding Text
4.2.4.6.1.1. TextVariables
4.2.4.6.1.2. Text Replacement
4.2.4.6.1.3. Automatic Text Resizing
4.2.4.6.1.4. Text Cropping
4.2.4.6.2. Adding Lines
4.2.4.6.2.1. Line and Point Formatting
4.2.4.6.2.2. Floating Lines
4.2.4.6.2.3. Fixed Horizontal/Vertical Lines
4.2.4.6.2.4. Trend Lines
4.2.4.6.3. Adding Control Areas
4.2.4.6.4. Adding Tables
4.2.4.6.5. Adding Hyperlinks
4.2.4.6.5.1. Viewing Hyperlinks
4.2.4.7. Formatting Chart Axes
4.2.4.7.1. Axis Scale
4.2.4.7.2. Axis Elements
4.2.4.7.2.1. Axis Label Formatting
4.2.4.8. Formatting Plot/Data Elements
4.2.4.8.1. Data Properties
4.2.4.8.2. Date/Time Based Zooming
4.2.4.8.2.1. Adding Zooming
4.2.4.8.2.2. Zooming In Chart Viewer
4.2.4.8.3. Data Ordering
4.2.4.8.3.1. Top/Bottom N Charts
4.2.4.8.4. Histograms
4.2.4.8.5. Formatting Plot Area
4.2.4.8.6. Formatting Chart Legend
4.2.4.8.7. 3D Display Options
4.2.4.8.8. Data Border
4.2.4.8.9. Aggregation
4.2.4.9. Chart-Specific Options
4.2.4.9.1. Bubble Charts
4.2.4.9.2. Dial Charts
4.2.4.9.2.1. Gauge Images
4.2.4.9.3. Overlay Charts
4.2.4.9.4. Pie Charts
4.2.4.9.5. Line Charts:
4.2.4.9.5.1. Double Value Line Charts
4.2.4.9.6. HLCO Charts
4.2.4.9.7. Box Charts
4.2.4.9.8. Stack Area Charts
4.2.4.9.9. Gantt Charts
4.2.4.9.10. Radar Charts
4.2.4.9.11. Scatter Charts
4.2.4.9.12. Polar Charts
4.2.4.9.13. Column Charts with Series
4.2.4.9.14. Column/Bar Charts without Series
4.2.4.9.15. Two-Dimensional Line Combination Charts
4.2.4.9.16. Doughnut Charts
4.2.5. Chart Drill-Down
4.2.5.1. Data Drill-Down
4.2.5.1.1. Adding Data Drill-Down
4.2.5.2. Dynamic Data Drill-Down
4.2.5.3. Parameter Drill-Down
4.2.5.3.1. Adding Parameter Drill-Down
4.2.6. Saving & Exporting Charts
4.2.6.1. Saving Charts with Report Data
4.2.6.2. Saving Charts without Report Data
4.2.6.2.1. Working with Templates
4.2.6.2.2. Saving XML Templates
4.2.6.2.3. Creating a Viewer Page
4.2.6.2.3.1. Viewer Options
4.2.6.3. Exporting Charts
4.2.6.3.1. PDF Font Mapping
4.2.6.3.1.1. PDF Font Mapping Import/Export
4.3. QuickDesigner Reports
4.3.1. Start
4.3.2. Select a Data Source
4.3.3. Toolbar
4.3.4. Format Report Elements
4.3.4.1. Add a Column
4.3.4.2. Remove a Column
4.3.4.3. Collapse Sidebars
4.3.4.4. Column Width
4.3.4.5. Column Order
4.3.4.6. Show More Rows
4.3.4.7. Report Style
4.3.4.8. Pagination/Scrolling
4.3.4.9. Report Title
4.3.4.9.1. Report Title with Variables
4.3.4.10. Report Logo
4.3.5. Parameter Setting
4.3.6. Aggregation/Group
4.3.7. Data Formating
4.3.8. Sorting
4.3.9. Data Filtering
4.3.10. Save the Report
4.3.11. Export the Report
4.3.12. Open the Saved Report
4.3.13. Exit
4.4. QuickDesigner Charts
4.4.1. Start
4.4.2. Select a Data Source
4.4.2.1. Change a Data Source
4.4.3. Data Mapping and Ordering
4.4.3.1. Mapping and Ordering Options
4.4.3.2. Change Data Mapping
4.4.3.3. Parameter Setting
4.4.4. Toolbar
4.4.5. Data Formatting
4.4.5.1. Position and Size
4.4.5.1.1. Canvas Size
4.4.5.1.2. Chart Position and Size
4.4.5.2. Font and Color Options
4.4.5.2.1. Chart Titles
4.4.5.2.1.1. Text Variables
4.4.5.2.2. Chart Fonts
4.4.5.2.3. Chart Colors
4.4.5.2.4. Color Gradient
4.4.5.3. Chart Axes
4.4.5.3.1. Axis Scale
4.4.5.3.2. Axis Elements
4.4.5.3.2.1. Axis Label
4.4.5.4. Plot/Data Elements
4.4.5.4.1. Data Properties
4.4.5.4.2. Line And Point
4.4.5.4.3. Trend Line
4.4.5.4.4. Plot Area
4.4.5.4.5. Chart Legend
4.4.5.5. Chart-Specific Options
4.4.5.5.1. Dial Charts
4.4.5.5.2. Pie and Doughnut Charts
4.4.5.5.3. HLCO Charts
4.4.5.5.4. Gantt Charts
4.4.5.5.5. Polar Charts
4.4.6. Save the Chart
4.4.7. Export the Chart
4.4.8. Open the Saved Chart
4.4.9. Exit
5. Designing Maps
5.1. Introduction to ERES Maps
5.2. Online Maps
5.2.1. Generating Google Maps API Key
5.2.2. Data Sources
5.2.3. Start Online Maps
5.2.4. Coordinates Editor
5.2.4.1. Select Data Source
5.2.4.2. Create Coordinates
5.2.4.2.1. From Data Source
5.2.4.2.2. Geocoding
5.2.4.2.3. Manually
5.2.4.3. Coordinates Editor Interface
5.2.4.4. Save Coordinates
5.2.4.5. Open, Edit Coordinates
5.2.5. Coordinates Mapping
5.2.6. Create Online Maps
5.2.6.1. Select Data Source
5.2.6.2. Select Coordinates
5.2.6.3. Coordinates Mapping
5.2.6.4. Toolbar
5.2.6.5. Map Options
5.2.6.6. Heatmap
5.2.6.7. Tooltips
5.2.6.8. Parameter Setting
5.2.6.9. Drilldowns
5.2.6.10. Map Title
5.2.7. Save Map
5.2.8. Open Saved Map
5.2.9. Exit
5.3. SVG Maps
5.3.1. Introduction to SVG Maps
5.3.2. Set Area IDs Using Inkscape Editor
5.3.3. Area ID Mapping
5.3.4. SVG Maps Designing
5.3.4.1. Start
5.3.4.2. Select Data Source
5.3.4.2.1. Change Data Source
5.3.4.2.2. Parameterized Data Source
5.3.4.3. Select SVG Image
5.3.4.3.1. Change SVG Image
5.3.4.4. Toolbar
5.3.4.5. Thresholds
5.3.4.5.1. Legend
5.3.4.6. Drilldowns
5.3.4.7. Tooltips
5.3.4.8. Map Title
5.3.4.9. Map Size
5.3.4.10. Change Parameter Values
5.3.4.11. Change Area ID Mapping
5.3.5. Dynamic SVG Maps
5.3.6. Save Map
5.3.7. Open Saved Map
5.3.8. Exit
5.4. Map Viewer
5.4.1. Writing Map Viewer URL
5.5. Migrating Maps
5.A. List of SVG Map Images
6. Designing Dashboards
6.1. Introduction to Dashboards
6.2. Create Dashboard
6.2.1. Toolbar
6.2.2. Responsive Dashboard
6.2.3. Add Charts, Reports and Maps
6.2.3.1. Move and Resize Charts, Reports and Maps
6.2.3.2. Snap to Grid
6.2.3.3. Chart/Report/Map Toolbar
6.2.4. Shared Parameters
6.2.4.1. Arrange Shared Parameters
6.2.4.2. Parameter Range
6.2.4.3. Cascading Parameters
6.2.5. Insert Labels
6.2.6. Add Background
6.2.7. Additional Options
6.2.8. Drilldown
6.2.8.1. Drilldown to Dashboard
6.2.9. Folders
6.2.10. Template Linkage
6.2.11. Dashboard Preview
6.3. Dashboard Migration
6.3.1. Migrating from previous ERES versions
6.4. Save Dashboard
6.5. Open Saved Dashboard
6.6. Exit
7. Publishing (Menu & URLs)
7.1. The Menu Page
7.1.1. Launching the Menu Page
7.1.2. Using the Menu Page
7.1.2.1. Viewing Reports and Charts
7.1.2.1.1. Viewing Reports with Encrypted Data
7.1.2.2. Using the DHTML Report Viewer
7.1.2.2.1. The DHTML Report Viewer Toolbar
7.1.2.2.2. Parameterized Reports and Reports with Unmapped Drilldown Parameters
7.1.2.3. Using the DHTML Chart Viewer
7.1.2.3.1. The DHTML Chart Viewer Toolbar
7.1.3. Mobile MenuPage
7.2. Image URLs
7.2.1. Generating URLs in Organizer
7.2.1.1. URLs for Parameterized Charts
7.2.1.2. For Current User
7.2.1.3. Running Image URLs
7.2.2. Writing Image URLs
7.2.2.1. URL Syntax
7.2.2.2. URL Parameters
7.2.2.2.1. Login Parameters
7.2.2.2.2. Data Input Parameters
7.2.2.2.3. Appearance Parameters
7.2.2.2.4. Export Parameters
7.2.2.2.5. Parameter Page Parameters
7.2.2.3. Examples
7.3. Report URLs
7.3.1. Generating URLs in Organizer
7.3.1.1. URLs for Parameterized Reports
7.3.1.2. User Options
7.3.1.3. Running Report URLs
7.3.1.4. Running Reports with Encrypted Data
7.3.2. Writing Report URLs
7.3.2.1. URL Syntax
7.3.2.2. URL Parameters
7.3.2.2.1. Login Parameters
7.3.2.2.2. Data Input Parameters
7.3.2.2.3. Export Parameters
7.3.2.2.4. Parameter Page Parameters
7.3.2.3. Examples
7.4. Dashboard URLs
7.4.1. Generating URLs in Organizer
7.4.1.1. Running Dashboard URLs
7.4.2. Writing Dashboard URLs
7.4.2.1. URL Syntax
7.4.2.2. URL Parameters
7.5. Menu Page Listener
7.5.1. ERES Listener Manager
7.5.1.1. Deploying the Listener Manager
7.5.2. Using the Menu Page Listener
7.6. Report Viewer
7.6.1. The Report Viewer Parameters
7.6.2. Specifying Data for Report Viewer
7.6.2.1. Data From a Database
7.6.2.2. Data From a File
7.6.2.3. Data From an Argument
7.6.3. Using Report Viewer
7.6.4. Connecting to the ERES Server
7.6.5. Swing Version
7.6.6. Exporting from Viewer
7.7. Page Viewer
7.7.1. Launching Page Viewer
7.7.1.1. Launching from Report Designer
7.7.2. The Page Viewer Parameters
7.7.3. Using Page Viewer
7.7.4. Buffer Time
7.7.5. Connecting to the ERES Server
7.7.6. Swing Version Available
7.7.7. Exporting from Viewer
7.7.8. Unmapped Drilldown Parameter
7.8. Chart Viewer
7.8.1. The Chart Viewer Parameters
7.8.2. Specifying the Data Source for Chart Viewer
7.8.2.1. Data Read From a Database
7.8.2.2. Data Read From a Data File
7.8.2.3. Data Read From an Argument
7.8.3. Using Chart Viewer
7.8.4. Axis Rulers
7.8.5. Pop-up Menu
7.8.5.1. Changing Chart Dimension and Type
7.8.5.2. Axis Zooming
7.8.5.3. Zooming
7.8.5.4. Dynamic Data Drill-Down
7.8.5.5. Query Parameter
7.8.6. Swing Version Available
7.9. Dashboard Viewer
7.9.1. Preview Toolbar
7.9.2. Preview Options
8. Programming
8.1. ERES Report API
8.1.1. Introduction and Setup
8.1.2. Recommended Approach for Using Report API
8.1.3. Interaction with ERES Server
8.1.4. Connecting to ERES Server
8.1.5. Using the API
8.1.5.1. Loading a Report
8.1.5.1.1. Sub-Reports, Charts ,and Drill-Down Reports
8.1.5.1.2. PAK File
8.1.5.1.3. Backup Data
8.1.5.1.4. Parameterized Reports
8.1.5.1.4.1. Object Array
8.1.5.1.4.2. getAllParameters method
8.1.5.1.5. Secure Reports
8.1.5.2. Applying a Report Template
8.1.5.3. Modifying Data Source
8.1.5.3.1. Data from a Database
8.1.5.3.1.1. Parameterized
8.1.5.3.1.2. JNDI
8.1.5.3.2. Data from a Data File (TXT/DAT/XML)
8.1.5.3.3. Data from an XML Data Source
8.1.5.3.4. Data from Custom Implementation
8.1.5.3.4.1. Parameterized
8.1.5.3.5. Data Passed in an Array in Memory
8.1.5.3.6. Drill-Down with DrillDownReportServlet
8.1.5.4. Modifying Column Mapping
8.1.5.5. Report Components
8.1.5.5.1. ReportElement
8.1.5.5.2. ReportCell
8.1.5.5.3. ReportSection
8.1.5.5.4. ReportColumn
8.1.5.5.5. ReportTable
8.1.5.5.6. ReportImage
8.1.5.5.7. ReportChartObject
8.1.5.5.8. ChartObject
8.1.5.5.9. ReportDocument
8.1.5.5.10. ReportRTFObject
8.1.5.5.11. SubReportObject
8.1.5.5.12. ReportGrid
8.1.5.5.13. ReportLine
8.1.5.6. Modifying Report Attributes
8.1.5.6.1. Adding New Cells
8.1.5.6.2. Adding Images/Charts
8.1.5.6.3. Adding Hyperlinks
8.1.5.6.4. Adding GridLines and Lines
8.1.5.6.5. Adding Rich Text Field Objects
8.1.5.6.6. Adding Nested Sections
8.1.5.6.7. Modifying Background Color, Font, Etc
8.1.5.6.8. Modifying the Format
8.1.5.6.9. Modifying a Column to Show Bar Codes
8.1.5.6.10. Modifying a Report to be a Top N Report
8.1.5.6.11. Cell Scripts
8.1.5.7. Exporting the Report
8.1.5.7.1. Multiple Page Exporting
8.1.5.7.2. PDF Exporting Options
8.1.5.7.2.1. PDF Font Mapping in API
8.1.5.7.3. Exporting DHTML Content with Style Sheets
8.1.5.7.4. HTML Block Export
8.1.5.7.5. Custom Links for Multi-page DHTML Export
8.1.5.7.6. Setting the Pixels Per Inch Ratio for DHTML Export
8.1.5.7.7. Pre-load Charts
8.1.5.7.8. IExportThreadListener for .view files
8.1.5.7.9. Virtual Memory/Paging
8.1.5.7.10. Streaming Reports
8.1.5.7.10.1. RPTImageGenerator
8.1.5.7.10.2. DrillDownReportServlet
8.1.5.7.10.3. Generating HTML Parameter Page
8.1.5.7.10.4. Utilizing Cascading Style Sheets (CSS)
8.1.5.7.10.5. Customize the Parameter Page
8.1.5.8. Calling Report Designer from Report API
8.1.5.8.1. Specify a Report Template
8.1.5.8.2. Specify a Data Registry
8.1.5.8.3. Specify a DBInfo Object (Database Information)
8.1.5.8.4. Open Query Builder with a Specified DBInfo Object (Database Information)
8.1.5.8.5. Open Report Designer with a Specific Class File Data Source
8.1.5.8.6. Open Report Designer with Custom Functions
8.1.5.8.7. Open Report Designer with Pre-Set Directories
8.1.5.8.8. Open Report Designer with Modified Menubar and Toolbar
8.1.5.8.9. Open Report Designer with Skipped Wizard Steps
8.1.5.8.10. Open Report Designer with Customized Messages and Chart Designer
8.1.5.9. Changing Report Viewer and Page Viewer Options
8.1.6. Javadoc
8.1.7. Swing Version
8.1.8. Summary
8.2. ERES Chart API
8.2.1. Introduction and Setup
8.2.2. Recommended Approach for using Chart API
8.2.3. Interaction with the ERES Server
8.2.4. Connecting to ERES Server
8.2.5. Using the API
8.2.5.1. Loading a Chart
8.2.5.1.1. Parameterized Charts
8.2.5.1.1.1. Object Array
8.2.5.2. Applying a Chart Template
8.2.5.3. Modifying Data Source
8.2.5.3.1. Data from a Database
8.2.5.3.1.1. JNDI
8.2.5.3.2. Data from a Data File (TXT/DAT/XML)
8.2.5.3.3. Data from an XML Data Source
8.2.5.3.4. Data from Custom Implementation
8.2.5.3.5. Data passed in an Array in Memory
8.2.5.4. Modifying Chart Attributes
8.2.5.4.1. Modifying Color, Font, Etc
8.2.5.4.2. Setting Predefined Patterns
8.2.5.4.3. Setting Customized Patterns
8.2.5.4.4. Modifying Size
8.2.5.4.5. Modifying Date/Time Zoom Charts
8.2.5.4.6. Modifying Chart in Report
8.2.5.5. Exporting the Chart
8.2.5.5.1. Record File Exporting
8.2.5.5.2. Streaming Charts
8.2.5.6. Changing Chart Viewer Options
8.2.6. API Only Features
8.2.6.1. Visual
8.2.6.1.1. Canvas/Plot
8.2.6.1.1.1. Customizable Message for No-Data-In-Plot
8.2.6.1.1.2. Set Chart to Fit Canvas
8.2.6.1.1.3. Set Chart Invisible
8.2.6.1.1.4. Applying Different Graphics Rendering
8.2.6.1.1.5. Chart Plot Position
8.2.6.1.1.6. Drawing Multiple Charts in same Plot
8.2.6.1.2. Hint Box
8.2.6.1.2.1. Modify Hint Box
8.2.6.1.2.2. Data and Hyperlink Hint Box Offset
8.2.6.1.2.3. Hint Box Border Color
8.2.6.1.2.4. Customize Image Map Hint Box
8.2.6.1.3. Legend/Annotation
8.2.6.1.3.1. Annotation with Symbol
8.2.6.1.3.2. Set Relative Shift of Annotation Border
8.2.6.1.3.3. Set Reference Position of Legend and Annotation Text
8.2.6.1.4. Misc.
8.2.6.1.4.1. Ticker Label Replacement
8.2.6.1.4.2. Customizable Data Top Label
8.2.6.1.4.3. Show Value Axis as Date/Time/Timestamp
8.2.6.1.4.4. Selective String Rendering
8.2.6.1.4.5. Drawing Data Points above Horizontal/Vertical/Trend Lines
8.2.6.2. Data
8.2.6.2.1. Getting the Coordinates
8.2.6.2.2. Set Data Limit at Axis Scale
8.2.6.2.3. Set Null Data as Zero
8.2.6.2.4. Additional Trend Line Options
8.2.6.2.5. Adding Multiple Control Lines to Stack Type Chart
8.2.6.3. Chart Specific
8.2.6.3.1. Column/Bar Charts
8.2.6.3.1.1. Color Separator
8.2.6.3.1.2. Disabling Shadow
8.2.6.3.2. Pie Charts
8.2.6.3.2.1. Drawing Pie Slices Clockwise/Counter Clockwise
8.2.6.3.2.2. Pie Border for 0% and 100% Slices
8.2.6.3.2.3. Customize Separator between Category and Percent Value Strings in Pie Legend
8.2.6.3.2.4. Pie Border Color Customizable
8.2.6.3.3. Line Charts
8.2.6.3.3.1. Line Area
8.2.6.3.4. Scatter Charts
8.2.6.3.4.1. Show Series in Top Label
8.2.6.3.4.2. Drawing Order
8.2.6.3.4.3. Scatter Chart Cube Width
8.2.6.3.5. Overlay Charts
8.2.6.3.5.1. Multiple Axes Titles
8.2.6.3.6. Dial Charts
8.2.6.3.6.1. Control Area Scale Labels
8.2.6.3.7. HLCO Charts
8.2.6.3.7.1. Changing Candle Stick Color
8.2.6.3.7.2. Changing CandleStick Wicker Width
8.2.6.3.8. Surface Charts
8.2.6.3.8.1. Heat Map
8.2.6.4. Performance
8.2.6.4.1. BufferedImage or Frame
8.2.6.4.2. Chart Generation Order
8.2.6.5. Viewer
8.2.6.5.1. Call Back Mechanism
8.2.6.5.2. Disable/Enable Tools-Tips Text
8.2.6.5.3. Canvas Area
8.2.7. Changing Chart Viewer Options
8.2.8. Javadoc
8.2.9. Swing Version
8.2.10. Summary
8.3. Managing Users and Groups
8.3.1. Introduction
8.3.2. Users and Groups
8.3.2.1. Creating Users and Groups
8.3.2.2. Deleting Users and Groups
8.3.3. Single Sign-On
8.3.4. Login Listener
8.3.5. Javadoc
8.3.6. Summary
8.4. ERES Menu API Overview
8.4.1. Introduction and Setup
8.4.2. Using the API
8.4.2.1. Creating and Customizing an ERES Menu
8.4.2.1.1. Connecting to ERES Server
8.4.2.1.2. Getting User Menu Page
8.4.2.1.3. Getting all Visible Nodes
8.4.2.1.4. Getting the Node Details
8.4.2.1.5. Getting the File Details
8.4.2.1.6. Scheduling/Archiving
8.4.2.2. Exporting Reports/Charts using the LookupServlet Servlet
8.4.3. Javadoc
8.4.4. Summary
8.5. Menu JSP Programming
8.5.1. Menu Page Architecture
8.5.2. Login Code
8.5.3. Building the Main Page
8.5.4. Running Reports and Charts
8.5.5. Retrieving Scheduled Reports and Charts
8.5.6. Running Archived Reports and Charts
8.5.7. Getter Methods
8.5.7.1. MenuMainPage
8.5.7.2. FolderNode
8.5.7.3. ItemNode
8.5.7.4. ItemScheduleJob
8.5.7.5. ItemArchiveJob
8.5.7.6. MenuRunReport
8.5.7.7. MenuRunChart
8.5.7.8. MenuRunSchedule
8.5.7.9. MenuReportSecurity
8.5.7.10. MenuRunArchive
8.5.7.11. MenuRunArchiveCHT
8.5.7.12. MenuArchiveSecurity
8.5.7.13. MenuScheduleParam
8.6. Organizer
8.6.1. Introduction
8.6.2. Look and Feel
8.6.3. Inserting and Removing Items
8.6.4. Customizing Report and Chart Designer
8.6.5. Calling Scheduler
8.6.6. Javadoc
8.6.7. Summary
8.7. Scheduler
8.7.1. Introduction
8.7.2. Scheduling an Export
8.7.3. Scheduling Multiple Exports
8.7.4. Scheduling an Archive
8.7.5. Removing a Schedule
8.7.5.1. Getting Details of a Failed Schedule
8.7.5.2. ICallBackScheduler Interface
8.7.5.3. Scheduler Listener
8.7.5.4. Report Bursting
8.7.5.5. Javadoc
8.7.5.6. Summary
8.8. SOAP Interface
8.8.1. LookupService Running
8.8.1.1. Request Message
8.8.1.1.1. Header Elements
8.8.1.1.2. Body Elements
8.8.1.1.3. Request Message Attachments
8.8.1.1.4. Example of Request Message
8.8.1.1.5. Passing Query Parameters
8.8.1.2. Response Message
8.8.1.2.1. Messages from the LookupService
8.8.1.2.2. Response Message Attachments
8.8.1.3. SimpleSOAPMessenger
8.8.1.3.1. SOAP Client Example
8.9. Deployment
8.9.1. Introduction
8.9.2. Deploying with ERES Server
8.9.2.1. Report Designer
8.9.2.2. Report Viewer
8.9.2.3. Page Viewer
8.9.2.4. Chart Viewer
8.9.2.5. Report API
8.9.2.6. Scheduler
8.9.3. Deploying without ERES Server
8.9.3.1. Report Viewer
8.9.3.2. Page Viewer
8.9.3.3. Chart Viewer
8.9.3.4. Report API
8.9.4. Deploying in a non-Windows environment
8.9.4.1. XvfB (X Virtual Frame Buffer)
8.9.4.2. JVM 1.5+ in Headless Mode
8.9.5. Platform Specific Issues
8.9.5.1. AS/400
8.9.5.1.1. Running Under NAWT
8.9.5.1.2. Running Under Headless Mode
8.9.5.2. Linux/Unix
8.9.5.2.1. Running under X
8.9.5.2.2. Running Under Headless Mode
8.A. Getting the Report Data
8.A.1. Data from a Database
8.A.1.1. Data from JNDI
8.A.2. Data from a Data File (TXT/DAT/XML)
8.A.3. Data from an XML Data Source
8.A.4. Data passed in an Array in Memory
8.A.5. Data passed in a Custom Implementation
8.A.6. Data from Enterprise Java Beans (EJBs)
8.A.7. Data from a SOAP Data Source
8.A.8. Data from Multiple Data Sources
8.B. Creating the Report
8.B.1. Simple Columnar
8.B.1.1. Column Mapping
8.B.1.2. Creating the Report
8.B.2. Summary Break
8.B.2.1. Column Mapping
8.B.2.2. Creating the Report
8.B.3. CrossTab
8.B.3.1. Column Mapping
8.B.3.2. Creating the Report
8.B.3.3. Fixed-field Crosstab Report
8.B.3.3.1. Creating the Report
8.B.4. Master & Details
8.B.4.1. Column Mapping
8.B.4.2. Creating the Report
8.B.5. Mailing Labels
8.B.5.1. Column Mapping
8.B.5.2. Creating the Report
8.B.6. Formula
8.B.7. Parameterized Report
8.B.7.1. Creating the Report with Single Value Parameter
8.B.7.2. Creating the Report with Multi Value Parameter
8.B.8. Sub-Report
8.B.8.1. Creating the Report
8.B.9. Drill-Down
8.B.9.1. Creating the Report
8.C. Getting the Chart Data
8.C.1. Data from a Database
8.C.1.1. JNDI
8.C.1.2. JNDI example using Tomcat and EspressManager running from servlet
8.C.2. Data from a Data file (TXT/DAT/XML)
8.C.3. Data from a XML Data Source
8.C.4. Data Passed in an Array in Memory
8.C.5. Data Passed in your Custom Implementation
8.C.6. Data from a Spreadsheet Model
8.C.7. Data from Enterprise Java Beans (EJBs)
8.C.8. Data from multiple Data Sources
8.C.9. Data in Spreadsheet Format
8.C.10. Transposing Data
8.C.10.1. Non-Selective Transposing
8.C.10.2. Selective Transposing
8.D. Creating the Chart
8.D.1. Column, Bar, Line, Area, Pie and Overlay Charts
8.D.1.1. Column Mapping
8.D.1.2. Creating the Chart
8.D.2. Radar Charts
8.D.2.1. Column Mapping
8.D.2.2. Creating the Chart
8.D.3. XY(Z) Scatter Charts
8.D.3.1. Column Mapping
8.D.3.2. Creating the Chart
8.D.4. Stack Column, Percentage Column, Stack Bar and Stack Area Charts
8.D.4.1. Column Mapping
8.D.4.2. Creating the Chart
8.D.5. Dial Charts
8.D.5.1. Column Mapping
8.D.5.2. Creating the Chart
8.D.6. Box Charts
8.D.6.1. Column Mapping
8.D.6.2. Creating the Chart
8.D.7. Bubble Charts
8.D.7.1. Column Mapping
8.D.7.2. Creating the Chart
8.D.8. High-Low and HLCO Charts
8.D.8.1. Column Mapping
8.D.8.2. Creating the Chart
8.D.9. Surface Charts
8.D.9.1. Column Mapping
8.D.9.2. Creating the Chart
8.D.10. Gantt Charts
8.D.10.1. Column Mapping
8.D.10.2. Creating the Chart
8.D.11. Polar Charts
8.D.11.1. Column Mapping
8.D.11.2. Creating the Chart
8.D.12. Date/Time Based Zoom Charts
8.D.13. Parameterized Charts
8.D.14. Drill-Down Charts
8.D.14.1. Parameter Drill-Down Charts
8.D.14.2. Data Drill-Down Charts
8.D.14.3. Dynamic Data Drill-Down Charts
8.D.15. Adding a Chart to a Report
8.D.15.1. Adding a Chart Template
8.D.15.2. Adding a Chart that uses Report Data
8.D.15.3. Adding a Chart that uses an Independent Data Source
9. Configuration
9.1. Using Other Databases
9.1.1. Create Table Scripts
9.1.1.1. Database Specific Notes
9.1.1.1.1. DB2
9.1.1.1.2. MS SQL Server
9.1.1.1.3. MySQL
9.1.1.1.4. Oracle
9.1.2. Specifying the Database Connection
9.1.3. Migrating the ERES Database
9.2. Integrating Existing Users/Groups
9.2.1. Using a Database
9.2.2. Implementing UserSecurityProvider
9.2.2.1. Deploying UserSecurityProvider
9.3. Using Other Application Servers
9.3.1. Tomcat 4.1/5.x/6.0.x/7.0.x
9.3.2. Resin
9.3.2.1. Resin 3.x/4.x
9.3.2.2. Resin 2.1.12
9.3.3. WebLogic Server
9.3.3.1. WebLogic Server 9.2/10.3
9.3.3.1.1. WebLogic Server 8.1
9.3.3.1.2. WebLogic Server 7.0
9.3.3.1.3. WebLogic Server 7.0 - Quick Deployment
9.3.4. WebSphere
9.3.4.1. WebSphere 7.1
9.3.4.2. WebSphere 5.0/6.1
9.3.4.3. WebSphere on z/OS
9.3.5. JBoss 3.2.3 (with Tomcat 5.0) / JBoss 4.0.5/6.0.0
9.3.6. Oracle Containers for J2EE (OC4J) 10g (9.0.4.0/10.1.3.5)
9.3.7. Oracle Application Server 10g R3 (10.1.3)
9.3.8. GlassFish Server 3.0.1
9.4. Clustering/Load Balancing
9.4.1. Tomcat 5.0
9.4.1.1. Running ERES in a Tomcat Cluster
9.4.1.2. Set up ERES clustering using Apache Web Server and Tomcat
9.4.2. JBoss 3.2.5 (with Tomcat 5.0)
9.4.2.1. Running ERES in JBoss Cluster
9.4.3. JRun 4 (with Apache Web server)
9.4.3.1. Running ERES in a JRun Cluster
9.4.4. WebSphere 6.0
10. Internationalization
10.1. Internationalizing ERES
10.1.1. Specifying Locales
10.1.1.1. Locale-Specific Formatting
10.1.1.2. Setting Time Zones and Locales Using the API
10.1.2. Language and Encoding
10.1.2.1. ERES Language Translation
10.1.2.1.1. Upgrading Language File
10.1.2.2. Displaying Foreign Characters
10.1.2.3. Entering Foreign Characters
10.1.2.4. XML Encoding
10.1.2.5. Exporting With Foreign Characters
10.1.2.6. Specifying Encoding for Text Data Files
11. Alerts
11.1. What is an Alert
11.2. Specifying alerts
11.2.1. Online Maps
11.2.2. SVG Maps
11.2.3. Charts
11.2.4. Reports
11.2.4.1. Subreports
11.2.4.2. Charts in reports
11.3. Dashboard alerts
11.3.1. Visual alert display
11.3.2. Alert messages
11.3.3. Sound alert
11.3.4. User interface
11.4. Monitoring
11.4.1. Alert notifications
11.4.2. Failed emails
11.4.3. User interface
11.4.3.1. Create/Edit monitoring dialog
11.4.3.2. Monitoring list
11.4.4. Monitoring log
11.5. Handling special situations
11.5.1. Change in script/control area/range
11.5.2. Missed monitoring jobs