EspressReport ES 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. Data Mapping
- 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. Chart Mapping
- Q.4.2.1. Column Chart
- Q.4.2.1.1. Add a Data Series
- Q.4.2.1.2. 3D Column Chart
- Q.4.2.2. Pie Chart
- Q.4.2.3. Stack Column Chart
- Q.5. Report and Chart Features
- Q.5.1. Basic Report Formatting
- Q.5.1.1. Add a Report Template to Organizer
- Q.5.1.2. Move and Align Report Elements
- Q.5.1.3. Data Formatting
- Q.5.1.4. Set Dual Colors
- Q.5.1.5. Inserting Elements
- Q.5.1.5.1. Insert an Image
- Q.5.1.5.2. Insert a Title
- Q.5.1.5.3. Insert a Line
- Q.5.1.6. View Report Elements in Report Explorer
- Q.5.1.7. Set Section Options
- 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 Reporting Features
- Q.5.3.1. Formulas & Scripting
- Q.5.3.2. Add a Formula
- Q.5.3.3. Add a Script
- Q.5.3.3.1. Add an Aggregation
- Q.5.3.4. Drill-Down
- Q.5.3.5. Sub-Reports
- Q.5.4. Advanced Charting Features
- Q.5.4.1. Time-Series Zooming
- Q.5.4.2. Control Areas
- Q.6. QuickDesigner
- 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.6.3. Create a Chart
- Q.6.3.1. Format Chart Elements
- Q.6.3.2. Save the Chart
- Q.7. Maps
- Q.7.1. Google Maps
- Q.7.1.1. Creating Coordinates
- Q.7.1.2. Creating Google Map
- Q.7.1.2.1. Configuring Tool-Tips
- Q.7.1.2.2. Setting Drill-Downs
- Q.7.2. SVG Maps
- Q.7.2.1. Setting SVG Map Thresholds
- Q.7.2.1.1. Adding a Map Title
- Q.7.2.2. Setting SVG Map Drill-Downs
- Q.8. Publishing
- Q.8.1. Dashboards
- Q.8.1.1. Create a Dashboard
- Q.8.1.2. Save the Dashboard
- Q.8.1.3. Export Dashboard to PDF
- Q.8.2. URLs
- Q.8.3. The Menu Page
- Q.9. Alerts
- Q.9.1. Alerts in Charts
- Q.9.2. Alerts in Reports
- Q.9.3. Alerts in Maps
- Q.9.4. Alerts in Dashboards
- Q.9.5. Alert Monitoring
- Q.10. API
- Q.10.1. Set Up Environment
- Q.10.2. Run a Report
- Q.10.2.1. JSP Application
- Q.10.2.2. LookupServlet Servlet
- Q.10.3. Create a Report Programmatically
- Q.10.3.1. Map Summary Break ColInfo
- Q.10.3.2. Apply Template
- Q.10.4. Create a Chart Programmatically
- Q.10.4.1. Map Column Chart ColInfo
- Q.10.4.2. Apply Template
- Q.10.5. Modify Data Source of a Report
- Q.10.5.1. Modify Data Source of a Report (with Sub-Report)
- Q.10.5.2. Modify Data Source of a Parameterized Report (with Parameterized Sub-Report)
- Q.10.6. Modify Report Elements
- Q.10.7. Parameterized Reports
- Q.10.7.1. Pass in Parameter values
- Q.10.7.2. Pass in Parameter values using getAllParameters
- Q.10.7.3. Use getParameterPage(and ParamReportGeneratorServlet)
- Q.10.8. Deploy/Export Drill-Down
- Q.10.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 V6.6
- 1.2.1. New EspressReport ES Features
- 1.2.2. New Report Features
- 1.2.3. New Chart Features
- 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.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.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. Report Locking
- 2.1.4.4. 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
- 2.4. Working with Data Sources
- 2.4.1. Managing Data Registries
- 2.4.1.1. Exporting/Importing Data Registries
- 2.4.1.2. Data Registry Privileges
- 2.4.2. The Data Source Manager
- 2.4.2.1. Using Data Source Manager
- 2.4.2.1.1. Transposing Data
- 2.4.2.2. Data Source Node Locking
- 2.4.3. Data from a Database
- 2.4.3.1. JNDI Data Sources
- 2.4.3.2. Queries
- 2.4.3.2.1. Using Query Builder
- 2.4.3.2.1.1. Tables
- 2.4.3.2.1.2. Joins
- 2.4.3.2.1.3. Columns
- 2.4.3.2.1.4. Using Database Functions
- 2.4.3.2.1.5. Adding Extra SQL
- 2.4.3.2.1.6. Query Output
- 2.4.3.2.2. Parameterized Queries
- 2.4.3.2.2.1. Multi-Value Parameters
- 2.4.3.2.2.2. Initializing Query Parameters
- 2.4.3.2.2.3. Cascading Parameters
- 2.4.3.2.2.4. All Parameters
- 2.4.3.2.3. Entering SQL Statements
- 2.4.3.2.3.1. Calling Oracle Stored Procedures
- 2.4.3.3. Data Views
- 2.4.3.3.1. Data View Parameters
- 2.4.3.3.2. Updating Data View Queries
- 2.4.3.3.3. Data View Security
- 2.4.3.4. Editing Queries
- 2.4.3.5. Editing Database Connections
- 2.4.3.6. Troubleshooting Database Connections
- 2.4.4. Data from XML and XBRL Files
- 2.4.4.1. XMLQueries
- 2.4.4.1.1. XML Parameters
- 2.4.5. Data from Text Files
- 2.4.5.1. Formatting Requirements for Text Files
- 2.4.5.2. Data Types and Format for Text Files
- 2.4.6. Data from Class Files
- 2.4.6.1. Parameterized Class Files
- 2.4.7. Data from EJBs
- 2.4.8. Data from SOAP with WSDL support
- 2.4.9. Data from Salesforce
- 2.4.10. Data from Excel files
- 2.4.11. Using Data for Charts and Reports
- 2.4.11.1. Using Multiple Data Sources
- 2.4.11.2. Change Data Source
- 2.4.12. Data Source Updating
- 3. Designing Reports & Charts
- 3.1. Introduction to Report Designer
- 3.1.1. Starting Report Designer
- 3.1.2. Selecting a Data Source
- 3.2. Report Types and Data Mapping
- 3.2.1. Simple Columnar Report
- 3.2.1.1. Data Mapping
- 3.2.1.1.1. Top N Report
- 3.2.2. Summary Break Report
- 3.2.2.1. Data Mapping
- 3.2.2.1.1. Top N Report
- 3.2.3. Crosstab Report
- 3.2.3.1. Data Mapping
- 3.2.3.2. Transposing Data
- 3.2.3.3. Fixed-Field Crosstab Report
- 3.2.3.3.1. Data Mapping
- 3.2.4. Master & Details Report
- 3.2.4.1. Data Mapping
- 3.2.4.1.1. Top N Report
- 3.2.5. Mailing Label Report
- 3.2.5.1. Data Mapping
- 3.2.6. Additional Formatting Options
- 3.2.6.1. Custom Styles
- 3.2.6.1.1. Creating a Custom Style
- 3.2.7. Fit Columns to Page Width
- 3.2.8. Change Data Mapping
- 3.2.9. Keep Data Source Order
- 3.3. The Designer Interface
- 3.3.1. Report Sections
- 3.3.1.1. Nested Sections
- 3.3.2. Resizing Sections
- 3.3.3. Section Options
- 3.3.4. Rulers
- 3.3.4.1. Toggling Between Inches and Centimeters
- 3.3.5. Designer Menus
- 3.3.5.1. File Menu
- 3.3.5.2. Edit Menu
- 3.3.5.3. Insert Menu
- 3.3.5.4. Format Menu
- 3.3.5.5. View Menu
- 3.3.5.6. Data Menu
- 3.3.5.7. Drill-Down Menu
- 3.3.5.8. Option Menu
- 3.3.6. Designer Toolbar
- 3.3.7. Inserting and Manipulating Report Elements
- 3.3.7.1. Inserting Elements
- 3.3.7.1.1. Inserting Charts
- 3.3.7.1.1.1. Inserting Summary Charts into Fixed-field Crosstab Reports
- 3.3.7.1.2. Inserting Elements into the Table Data Section
- 3.3.7.2. Editing Elements
- 3.3.7.2.1. Editing Element Attributes
- 3.3.7.2.2. Word Wrapping
- 3.3.7.2.3. Editing Side-By-Side Master & Details Reports
- 3.3.7.3. Data Formatting for Formulas and Column Fields
- 3.3.7.3.1. Formatting Null Data
- 3.3.7.4. Line/Rectangle Format
- 3.3.7.5. Chart Export Format
- 3.3.7.6. Font, Color, and Border Options
- 3.3.7.6.1. Show Cell Outline
- 3.3.7.7. Rich Text Fields
- 3.3.7.7.1. Adding Formulas
- 3.3.7.8. Hyperlinks
- 3.3.7.9. Column Wrapping
- 3.3.7.10. Table of Contents
- 3.3.7.10.1. Adding a Table of Contents
- 3.3.7.11. Moving and Resizing Report Elements
- 3.3.7.11.1. Controlling Element Overlapping
- 3.3.7.11.2. Locking Element Position
- 3.3.7.12. Snap to Grid
- 3.3.7.13. Shift Mode
- 3.3.7.14. Guidelines
- 3.3.7.14.1. Inserting Guidelines
- 3.3.7.14.2. Positioning Elements with Guidelines
- 3.3.8. The Report Explorer
- 3.3.9. Global Formatting, Group Formatting, and Templates
- 3.3.9.1. Global Formatting
- 3.3.9.1.1. Global Format Import/Export
- 3.3.9.1.2. Global Formatting & Crosstab Reports
- 3.3.9.2. Group Formatting
- 3.3.9.3. Applying a Template
- 3.4. The Preview Window
- 3.4.1. Navigating the Report
- 3.4.2. Other Preview Window Options
- 3.4.2.1. Preview Data Options
- 3.4.2.2. Sorting Data
- 3.4.2.3. Parameter Prompts
- 3.4.2.4. Using Page Viewer
- 3.4.3. Setting Page Properties
- 3.5. Saving and Exporting Reports
- 3.5.1. Saving Reports
- 3.5.1.1. XML Encoding
- 3.5.2. Exporting Reports
- 3.5.2.1. PDF Font Mapping
- 3.5.2.1.1. PDF Font Mapping Import/Export
- 3.5.2.2. CSS Options
- 3.6. Using Formulas & the Formula Builder
- 3.6.1. Creating a Formula
- 3.6.1.1. The Formula Builder
- 3.6.2. Formula Syntax
- 3.6.2.1. Using Column Field Data
- 3.6.2.1.1. Column Aggregation
- 3.6.2.2. Using Formulas
- 3.6.2.3. Using Parameter Values
- 3.6.2.4. Using Database Fields
- 3.6.2.5. Constants
- 3.6.2.6. Formula Parameters
- 3.6.2.6.1. Initializing Formula Parameters
- 3.6.2.7. Operators
- 3.6.2.7.1. Arithmetic Operators
- 3.6.2.7.2. Boolean Operators
- 3.6.2.8. Functions
- 3.6.2.8.1. Numeric Functions
- 3.6.2.8.2. String Functions
- 3.6.2.8.3. Date/Time Functions
- 3.6.2.8.4. Custom Functions
- 3.6.3. Subreport Formula Access
- 3.7. Scripting
- 3.7.1. Creating a Script
- 3.7.2. Script Syntax
- 3.7.2.1. Formatting Actions
- 3.7.2.1.1. Scripting Image URLs
- 3.7.2.2. Variables & Arrays
- 3.7.2.2.1. Variables
- 3.7.2.2.2. Arrays
- 3.7.2.3. Using Formulas
- 3.7.2.4. Checking for Nulls
- 3.7.2.5. Row-Specific Options
- 3.7.2.6. Loops
- 3.7.2.7. Section Scripts
- 3.7.2.7.1. Formatting Actions for Section Scripts
- 3.7.2.8. Commenting Scripts
- 3.7.2.9. Accessing Values Computed by Other Scripts
- 3.7.3. Managing Scripts
- 3.8. Drill Down
- 3.8.1. Creating a Drill-Down Report
- 3.8.1.1. Drill-Down Links
- 3.8.1.1.1. Linking from Charts
- 3.8.2. Multi-Value Drill Down
- 3.8.2.1. Creating a Multi-Value Drill Down Report
- 3.8.3. Crosstab Drill-Down
- 3.8.3.1. Creating a Crosstab Drill-Down Report
- 3.8.4. Viewing Drill-Down Reports
- 3.8.5. Unmapped Drill-Down
- 3.9. Sub-Reports
- 3.9.1. Adding a Sub-Report
- 3.9.2. Editing a Sub-Report
- 3.9.2.1. Sub-Report sizing
- 3.9.3. Removing a Sub-Report
- 3.9.4. Linked Sub-Reports
- 3.9.4.1. Using Linked Sub-Reports
- 3.9.5. Parameter Linking
- 3.10. Template Security
- 3.10.1. Security Levels
- 3.10.2. Cell-Level Security
- 3.10.2.1. Security Parameters
- 3.10.3. Security for Sub-Reports & Drill-Down Layers
- 3.10.4. Viewing Secured Templates
- 3.10.4.1. Secured Report Designer
- 3.11. Introduction to Chart Designer
- 3.11.1. Working with Charts
- 3.11.2. Starting Chart Designer
- 3.11.3. Selecting a Data Source
- 3.11.3.1. Chart Parameter Linking
- 3.12. Charting Basics
- 3.12.1. What is a Chart
- 3.12.2. Basic Data Mapping
- 3.12.3. Saving and Exporting Charts
- 3.12.3.1. Saving Chart Definitions
- 3.12.3.2. Generating Image Files
- 3.13. Chart Types and Data Mapping
- 3.13.1. Data Mapping
- 3.13.1.1. Data Transposition
- 3.13.2. Column Charts
- 3.13.2.1. Data Mapping
- 3.13.3. Bar Charts
- 3.13.3.1. Data Mapping
- 3.13.4. XY(Z) Scatter Charts
- 3.13.4.1. Data Mapping
- 3.13.5. Line Charts
- 3.13.5.1. Data Mapping
- 3.13.6. Stack Column Charts
- 3.13.6.1. Data Mapping
- 3.13.7. Stack Bar Charts
- 3.13.7.1. Data Mapping
- 3.13.8. Pie Charts
- 3.13.8.1. Data Mapping
- 3.13.9. Area Charts
- 3.13.9.1. Data Mapping
- 3.13.10. Stack Area Charts
- 3.13.10.1. Data Mapping
- 3.13.11. High-Low Charts
- 3.13.11.1. Data Mapping
- 3.13.12. HLCO Charts
- 3.13.12.1. Data Mapping
- 3.13.13. Percentage Column Charts
- 3.13.13.1. Data Mapping
- 3.13.14. Doughnut Charts
- 3.13.14.1. Data Mapping
- 3.13.15. Surface Charts
- 3.13.15.1. Data Mapping
- 3.13.16. Bubble Charts
- 3.13.16.1. Data Mapping
- 3.13.17. Overlay Charts
- 3.13.17.1. Data Mapping
- 3.13.18. Box Charts
- 3.13.18.1. Data Mapping
- 3.13.19. Radar Charts
- 3.13.19.1. Data Mapping
- 3.13.20. Dial Charts
- 3.13.20.1. Data Mapping
- 3.13.20.2. Gauges
- 3.13.21. Gantt Charts
- 3.13.21.1. Data Mapping
- 3.13.22. Polar Charts
- 3.13.22.1. Data Mapping
- 3.13.23. Changing Data Mapping or Data Source
- 3.14. The Chart Designer Interface
- 3.14.1. The Designer Menus
- 3.14.1.1. File Menu
- 3.14.1.2. Insert Menu:
- 3.14.1.3. Format Menu
- 3.14.1.4. Type Menu
- 3.14.1.5. Drill-Down Menu
- 3.14.1.6. Data Menu
- 3.14.1.7. Layout Menu
- 3.14.2. The Designer Toolbar
- 3.14.3. Color, Color set, Pattern, and Font Panels
- 3.14.3.1. Color Panel
- 3.14.3.2. Color Set Panel
- 3.14.3.2.1. Save Colors for Categories feature
- 3.14.3.3. Pattern Panel
- 3.14.3.4. Font Panel
- 3.14.4. The Navigation Panel
- 3.14.5. The Viewport
- 3.14.5.1. The Chart Canvas
- 3.14.5.1.1. Background Images
- 3.14.5.2. Moving and Sizing Chart Elements
- 3.14.6. Adding Chart Elements
- 3.14.6.1. Adding Text
- 3.14.6.1.1. TextVariables
- 3.14.6.1.2. Text Replacement
- 3.14.6.1.3. Automatic Text Re-sizing
- 3.14.6.1.4. Text Cropping
- 3.14.6.2. Adding Lines
- 3.14.6.2.1. Line and Point Formatting
- 3.14.6.2.2. Floating Lines
- 3.14.6.2.3. Fixed Horizontal/Vertical Lines
- 3.14.6.2.4. Trend Lines
- 3.14.6.2.4.1. Normal Distribution Curve
- 3.14.6.3. Adding Control Areas
- 3.14.6.4. Adding Tables
- 3.14.6.5. Adding Hyperlinks
- 3.14.6.5.1. Viewing Hyperlinks
- 3.14.7. Formatting Chart Axes
- 3.14.7.1. Axis Scale
- 3.14.7.2. Axis Elements
- 3.14.7.2.1. Axis Label Formatting
- 3.14.8. Formatting Plot/Data Elements
- 3.14.8.1. Data Properties
- 3.14.8.2. Date/Time Based Zooming
- 3.14.8.2.1. Adding Zooming
- 3.14.8.2.2. ZoomingInChartViewer
- 3.14.8.3. Data Ordering
- 3.14.8.3.1. Top/Bottom N Charts
- 3.14.8.4. Histograms
- 3.14.8.5. Formatting Plot Area
- 3.14.8.6. Formatting Chart Legend
- 3.14.8.7. 3D Display Options
- 3.14.8.8. Data Border
- 3.14.8.9. Aggregation
- 3.14.9. Chart-Specific Options
- 3.14.9.1. Bubble Charts
- 3.14.9.2. Dial Charts
- 3.14.9.2.1. Gauge Images
- 3.14.9.3. Overlay Charts
- 3.14.9.4. Pie Charts
- 3.14.9.5. Line Charts:
- 3.14.9.5.1. Double Value Line Charts
- 3.14.9.6. HLCO Charts
- 3.14.9.7. Box Charts
- 3.14.9.8. Stack Area Charts
- 3.14.9.9. Gantt Charts
- 3.14.9.10. Radar Charts
- 3.14.9.11. Scatter Charts
- 3.14.9.12. Polar Charts
- 3.14.9.13. Column Charts with Series
- 3.14.9.14. Column/Bar Charts without Series
- 3.14.9.15. Two-Dimensional Line Combination Charts
- 3.14.9.16. Doughnut Charts
- 3.15. Chart Drill-Down
- 3.15.1. Data Drill-Down
- 3.15.1.1. Adding Data Drill-Down
- 3.15.2. Dynamic Data Drill-Down
- 3.15.3. Parameter Drill-Down
- 3.15.3.1. Adding Parameter Drill-Down
- 3.16. Saving & Exporting Charts
- 3.16.1. Saving Charts with Report Data
- 3.16.2. Saving Charts without Report Data
- 3.16.2.1. Working with Templates
- 3.16.2.2. Saving XML Templates
- 3.16.2.3. Creating a Viewer Page
- 3.16.2.3.1. Viewer Options
- 3.16.3. Exporting Charts
- 3.16.3.1. PDF Font Mapping
- 3.16.3.1.1. PDF Font Mapping Import/Export
- 3.17. Introduction to QuickDesigner
- 3.17.1. Starting QuickDesigner
- 3.17.2. Selecting a Data Source
- 3.17.2.1. Changing Data Source
- 3.18. QuickDesigner Queries
- 3.18.1. Selecting Fields
- 3.18.1.1. Building Columns
- 3.18.1.2. Querying Encrypted Data
- 3.18.2. Setting Conditions
- 3.18.2.1. Previewing Query Results
- 3.18.2.2. Parameterized Queries
- 3.18.2.2.1. Initializing Query Parameters
- 3.18.2.3. Saving Queries
- 3.18.2.4. Viewing SQL Query
- 3.18.2.5. Aggregation Alias
- 3.18.3. Editing Queries
- 3.19. Data Mapping
- 3.19.1. Report Mapping Options
- 3.19.2. Report Styles
- 3.19.3. Chart Mapping Options
- 3.19.4. Changing Data Mapping
- 3.20. The QuickDesigner Interface
- 3.20.1. The QuickDesigner Toolbar
- 3.20.1.1. Using the Toolbar
- 3.20.2. Inserting and Formatting Report Elements
- 3.20.2.1. Font, Color, and Border Options
- 3.20.2.2. Data Formatting for Formulas and Column Fields
- 3.20.2.3. Inserting Elements
- 3.20.2.3.1. Text Variables
- 3.20.2.3.2. Inserting/Editing Aggregations
- 3.20.2.3.3. Inserting/Editing Charts
- 3.20.2.4. Alerts for Report Elements
- 3.20.2.5. Sizing Report Elements
- 3.20.2.5.1. Re-size to Fit Content
- 3.20.3. Ordering and Sorting
- 3.20.3.1. Changing Column Order
- 3.20.3.2. Sorting
- 3.21. Saving and Exporting Reports
- 3.21.1. Saving Reports
- 3.21.2. Exporting Reports
- 3.21.2.1. Page Setup
- 3.21.2.2. Page Display
- 3.22. Charts in QuickDesigner
- 3.22.1. The QuickDesigner Toolbar
- 3.22.1.1. Using the Toolbar
- 3.22.2. Positioning and Sizing Charts
- 3.22.2.1. Setting Canvas Size
- 3.22.2.2. Setting Chart Position and Size
- 3.22.2.3. 3D Chart Options
- 3.22.3. Font and Color Options
- 3.22.3.1. Adding/Editing Chart Titles
- 3.22.3.1.1. Text Variables
- 3.22.3.2. Setting Chart Fonts
- 3.22.3.3. Setting Chart Colors
- 3.22.4. Formatting Chart Axes
- 3.22.4.1. Setting Axis Scale
- 3.22.4.2. Setting Axis Elements
- 3.22.4.2.1. Axis Label Formatting
- 3.22.5. Formatting Plot/Data Elements
- 3.22.5.1. Data Properties
- 3.22.5.2. Line And Point Formatting
- 3.22.5.3. Data Ordering
- 3.22.5.4. Formatting Plot Area
- 3.22.5.5. Formatting Chart Legend
- 3.22.6. Chart-Specific Options
- 3.22.6.1. Dial Charts
- 3.22.6.2. Pie Charts
- 3.22.6.3. HLCO Charts
- 3.22.6.4. Gantt Charts
- 3.22.6.5. Polar Charts
- 3.23. Saving & Exporting Charts
- 3.23.1. Saving Charts
- 3.23.2. Exporting Charts
- 3.24. QuickDesigner Dataview Query Secured Parameters
- 4. Designing Maps
- 4.1. Introduction to ERES Maps
- 4.2. Starting Map Builder
- 4.3. Google Maps
- 4.3.1. Generating Google Maps API Key
- 4.3.2. Selecting Data Source
- 4.3.3. Creating Coordinates
- 4.3.3.1. From Data Source
- 4.3.3.2. Geocoding
- 4.3.3.3. Manually
- 4.3.4. Operating Coordinates Designer
- 4.3.5. Coordinates Mapping
- 4.3.6. Creating Google Maps
- 4.3.6.1. Google Maps Tooltips
- 4.3.6.2. Google Maps Drill-Downs
- 4.3.6.3. Google Maps Titles
- 4.3.7. Google Maps Data Sources
- 4.4. SVG Maps
- 4.4.1. Setting Area IDs Using Inkscape Editor
- 4.4.2. Area ID Mapping
- 4.4.3. Creating SVG Map in ERES Map Builder
- 4.4.4. Setting Thresholds
- 4.4.4.1. Setting Legend
- 4.4.5. Setting Drill-Downs for SVG Maps
- 4.4.6. Setting Titles for SVG Maps
- 4.4.7. Setting Tooltips for SVG Maps
- 4.5. Map Viewer
- 4.5.1. Writing Map Viewer URL
- 4.6. Migrating Maps
- 4.A. List of SVG Map Images
- 5. Designing Dashboards
- 5.1. Dashboards
- 5.1.1. Creating Dashboards
- 5.1.1.1. The Dashboard Builder Toolbar
- 5.1.1.2. Adding Charts, Reports and Maps
- 5.1.1.2.1. Moving and Resizing Charts, Reports and Maps
- 5.1.1.3. Shared Parameters
- 5.1.1.3.1. Arranging shared parameters
- 5.1.1.3.2. Parameter Range
- 5.1.1.3.3. Cascading Parameters
- 5.1.1.4. Inserting Labels
- 5.1.1.5. Adding Dashboard Background
- 5.1.1.6. Additional Dashboard Options
- 5.1.1.7. Drill-Down
- 5.1.1.7.1. Drill-Down to Dashboard
- 5.1.1.8. Folders
- 5.1.1.9. Template Linkage
- 5.1.2. Saving Dashboards
- 5.1.3. Dashboard Preview
- 5.1.3.1. The Preview Toolbar
- 5.1.3.2. The Preview Options
- 5.1.4. Dashboard Migration
- 5.1.4.1. Migrating from previous ERES versions
- 6. Publishing (Menu & URLs)
- 6.1. The Menu Page
- 6.1.1. Launching the Menu Page
- 6.1.2. Using the Menu Page
- 6.1.2.1. Viewing Reports and Charts
- 6.1.2.1.1. Viewing Reports with Encrypted Data
- 6.1.2.2. Using the DHTML Report Viewer
- 6.1.2.2.1. The DHTML Report Viewer Toolbar
- 6.1.2.2.2. Parameterized Reports and Reports with Unmapped Drilldown Parameters
- 6.1.2.3. Using the DHTML Chart Viewer
- 6.1.2.3.1. The DHTML Chart Viewer Toolbar
- 6.1.3. Mobile MenuPage
- 6.2. Image URLs
- 6.2.1. Generating URLs in Organizer
- 6.2.1.1. URLs for Parameterized Charts
- 6.2.1.2. For Current User
- 6.2.1.3. Running Image URLs
- 6.2.2. Writing Image URLs
- 6.2.2.1. URL Syntax
- 6.2.2.2. URL Parameters
- 6.2.2.2.1. Login Parameters
- 6.2.2.2.2. Data Input Parameters
- 6.2.2.2.3. Appearance Parameters
- 6.2.2.2.4. Export Parameters
- 6.2.2.2.5. Parameter Page Parameters
- 6.2.2.3. Examples
- 6.3. Report URLs
- 6.3.1. Generating URLs in Organizer
- 6.3.1.1. URLs for Parameterized Reports
- 6.3.1.2. For Current User
- 6.3.1.3. Running Report URLs
- 6.3.1.4. Running Reports with Encrypted Data
- 6.3.2. Writing Report URLs
- 6.3.2.1. URL Syntax
- 6.3.2.2. URL Parameters
- 6.3.2.2.1. Login Parameters
- 6.3.2.2.2. Data Input Parameters
- 6.3.2.2.3. Export Parameters
- 6.3.2.2.4. Parameter Page Parameters
- 6.3.2.3. Examples
- 6.4. Menu Page Listener
- 6.4.1. ERES Listener Manager
- 6.4.1.1. Deploying the Listener Manager
- 6.4.2. Using the Menu Page Listener
- 6.5. Report Viewer
- 6.5.1. The Report Viewer Parameters
- 6.5.2. Specifying Data for Report Viewer
- 6.5.2.1. Data From a Database
- 6.5.2.2. Data From a File
- 6.5.2.3. Data From an Argument
- 6.5.3. Using Report Viewer
- 6.5.4. Connecting to the ERES Server
- 6.5.5. Swing Version
- 6.5.6. Exporting from Viewer
- 6.6. Page Viewer
- 6.6.1. Launching Page Viewer
- 6.6.1.1. Launching from Report Designer
- 6.6.2. The Page Viewer Parameters
- 6.6.3. Using Page Viewer
- 6.6.4. Buffer Time
- 6.6.5. Connecting to the ERES Server
- 6.6.6. Swing Version Available
- 6.6.7. Exporting from Viewer
- 6.6.8. Unmapped Drilldown Parameter
- 6.7. Chart Viewer
- 6.7.1. The Chart Viewer Parameters
- 6.7.2. Specifying the Data Source for Chart Viewer
- 6.7.2.1. Data Read From a Database
- 6.7.2.2. Data Read From a Data File
- 6.7.2.3. Data Read From an Argument
- 6.7.3. Using Chart Viewer
- 6.7.4. Axis Rulers
- 6.7.5. Pop-up Menu
- 6.7.5.1. Changing Chart Dimension and Type
- 6.7.5.2. Axis Zooming
- 6.7.5.3. Zooming
- 6.7.5.4. Dynamic Data Drill Down
- 6.7.5.5. Query Parameter
- 6.7.6. Swing Version Available
- 7. Programming
- 7.1. ERES Report API
- 7.1.1. Introduction and Setup
- 7.1.2. Recommended Approach for Using Report API
- 7.1.3. Interaction with ERES Server
- 7.1.4. Connecting to ERES Server
- 7.1.5. Using the API
- 7.1.5.1. Loading a Report
- 7.1.5.1.1. Sub-Reports, Charts ,and Drill-Down Reports
- 7.1.5.1.2. PAK File
- 7.1.5.1.3. Backup Data
- 7.1.5.1.4. Parameterized Reports
- 7.1.5.1.4.1. Object Array
- 7.1.5.1.4.2. getAllParameters method
- 7.1.5.1.5. Secure Reports
- 7.1.5.2. Applying a Report Template
- 7.1.5.3. Modifying Data Source
- 7.1.5.3.1. Data from a Database
- 7.1.5.3.1.1. Parameterized
- 7.1.5.3.1.2. JNDI
- 7.1.5.3.2. Data from a Data File (TXT/DAT/XML)
- 7.1.5.3.3. Data from an XML Data Source
- 7.1.5.3.4. Data from Custom Implementation
- 7.1.5.3.4.1. Parameterized
- 7.1.5.3.5. Data Passed in an Array in Memory
- 7.1.5.3.6. Drill-Down with DrillDownReportServlet
- 7.1.5.4. Modifying Column Mapping
- 7.1.5.5. Report Components
- 7.1.5.5.1. ReportElement
- 7.1.5.5.2. ReportCell
- 7.1.5.5.3. ReportSection
- 7.1.5.5.4. ReportColumn
- 7.1.5.5.5. ReportTable
- 7.1.5.5.6. ReportImage
- 7.1.5.5.7. ReportChartObject
- 7.1.5.5.8. ChartObject
- 7.1.5.5.9. ReportDocument
- 7.1.5.5.10. ReportRTFObject
- 7.1.5.5.11. SubReportObject
- 7.1.5.5.12. ReportGrid
- 7.1.5.5.13. ReportLine
- 7.1.5.6. Modifying Report Attributes
- 7.1.5.6.1. Adding New Cells
- 7.1.5.6.2. Adding Images/Charts
- 7.1.5.6.3. Adding Hyperlinks
- 7.1.5.6.4. Adding GridLines and Lines
- 7.1.5.6.5. Adding Rich Text Field Objects
- 7.1.5.6.6. Adding Nested Sections
- 7.1.5.6.7. Modifying Background Color, Font, Etc
- 7.1.5.6.8. Modifying the Format
- 7.1.5.6.9. Modifying a Column to Show Bar Codes
- 7.1.5.6.10. Modifying a Report to be a Top N Report
- 7.1.5.6.11. Cell Scripts
- 7.1.5.7. Exporting the Report
- 7.1.5.7.1. Multiple Page Exporting
- 7.1.5.7.2. PDF Exporting Options
- 7.1.5.7.3. Exporting DHTML Content with Style Sheets
- 7.1.5.7.4. HTML Block Export
- 7.1.5.7.5. Custom Links for Multi-page DHTML Export
- 7.1.5.7.6. Setting the Pixels Per Inch Ratio for DHTML Export
- 7.1.5.7.7. Pre-load Charts
- 7.1.5.7.8. IExportThreadListener for .view files
- 7.1.5.7.9. Virtual Memory/Paging
- 7.1.5.7.10. Streaming Reports
- 7.1.5.7.10.1. RPTImageGenerator
- 7.1.5.7.10.2. DrillDownReportServlet
- 7.1.5.7.10.3. Generating HTML Parameter Page
- 7.1.5.7.10.4. Utilizing Cascading Style Sheets (CSS)
- 7.1.5.7.10.5. Customize the Parameter Page
- 7.1.5.8. Calling Report Designer from Report API
- 7.1.5.8.1. Specify a Report Template
- 7.1.5.8.2. Specify a Data Registry
- 7.1.5.8.3. Specify a DBInfo Object (Database Information)
- 7.1.5.8.4. Open Query Builder with a Specified DBInfo Object (Database Information)
- 7.1.5.8.5. Open Report Designer with a Specific Class File Data Source
- 7.1.5.8.6. Open Report Designer with Custom Functions
- 7.1.5.8.7. Open Report Designer with Pre-Set Directories
- 7.1.5.8.8. Open Report Designer with Modified Menubar and Toolbar
- 7.1.5.8.9. Open Report Designer with Skipped Wizard Steps
- 7.1.5.8.10. Open Report Designer with Customized Messages and Chart Designer
- 7.1.5.9. Changing Report Viewer and Page Viewer Options
- 7.1.6. Javadoc
- 7.1.7. Swing Version
- 7.1.8. Summary
- 7.2. ERES Chart API
- 7.2.1. Introduction and Setup
- 7.2.2. Recommended Approach for using Chart API
- 7.2.3. Interaction with the ERES Server
- 7.2.4. Connecting to ERES Server
- 7.2.5. Using the API
- 7.2.5.1. Loading a Chart
- 7.2.5.1.1. Parameterized Charts
- 7.2.5.1.1.1. Object Array
- 7.2.5.2. Applying a Chart Template
- 7.2.5.3. Modifying Data Source
- 7.2.5.3.1. Data from a Database
- 7.2.5.3.1.1. JNDI
- 7.2.5.3.2. Data from a Data File (TXT/DAT/XML)
- 7.2.5.3.3. Data from an XML Data Source
- 7.2.5.3.4. Data from Custom Implementation
- 7.2.5.3.5. Data passed in an Array in Memory
- 7.2.5.4. Modifying Chart Attributes
- 7.2.5.4.1. Modifying Color, Font, Etc
- 7.2.5.4.2. Setting Predefined Patterns
- 7.2.5.4.3. Setting Customized Patterns
- 7.2.5.4.4. Modifying Size
- 7.2.5.4.5. Modifying Date/Time Zoom Charts
- 7.2.5.4.6. Modifying Chart in Report
- 7.2.5.5. Exporting the Chart
- 7.2.5.5.1. Record File Exporting
- 7.2.5.5.2. Streaming Charts
- 7.2.5.6. Changing Chart Viewer Options
- 7.2.6. API Only Features
- 7.2.6.1. Visual
- 7.2.6.1.1. Canvas/Plot
- 7.2.6.1.1.1. Customizable Message for No-Data-In-Plot
- 7.2.6.1.1.2. Set Chart to Fit Canvas
- 7.2.6.1.1.3. Set Chart Invisible
- 7.2.6.1.1.4. Applying Different Graphics Rendering
- 7.2.6.1.1.5. Chart Plot Position
- 7.2.6.1.1.6. Drawing Multiple Charts in same Plot
- 7.2.6.1.2. Hint Box
- 7.2.6.1.2.1. Modify Hint Box
- 7.2.6.1.2.2. Data and Hyperlink Hint Box Offset
- 7.2.6.1.2.3. Hint Box Border Color
- 7.2.6.1.2.4. Customize Image Map Hint Box
- 7.2.6.1.3. Legend/Annotation
- 7.2.6.1.3.1. Annotation with Symbol
- 7.2.6.1.3.2. Set Reference Position of Legend and Annotation Text
- 7.2.6.1.4. Misc.
- 7.2.6.1.4.1. Ticker Label Replacement
- 7.2.6.1.4.2. Customizable Data Top Label
- 7.2.6.1.4.3. Show Value Axis as Date/Time/Timestamp
- 7.2.6.1.4.4. Selective String Rendering
- 7.2.6.1.4.5. Drawing Data Points above Horizontal/Vertical/Trend Lines
- 7.2.6.2. Data
- 7.2.6.2.1. Getting the Coordinates
- 7.2.6.2.2. Set Data Limit at Axis Scale
- 7.2.6.2.3. Set Null Data as Zero
- 7.2.6.2.4. Additional Trend Line Options
- 7.2.6.3. Chart Specific
- 7.2.6.3.1. Column/Bar Charts
- 7.2.6.3.1.1. Color Separator
- 7.2.6.3.1.2. Disabling Shadow
- 7.2.6.3.2. Pie Charts
- 7.2.6.3.2.1. Drawing Pie Slices Clockwise/Counter Clockwise
- 7.2.6.3.2.2. Pie Border for 0% and 100% Slices
- 7.2.6.3.2.3. Customize Separator between Category and Percent Value Strings in Pie Legend
- 7.2.6.3.2.4. Pie Border Color Customizable
- 7.2.6.3.3. Line Charts
- 7.2.6.3.3.1. Line Area
- 7.2.6.3.4. Scatter Charts
- 7.2.6.3.4.1. Show Series in Top Label
- 7.2.6.3.4.2. Drawing Order
- 7.2.6.3.4.3. Scatter Chart Cube Width
- 7.2.6.3.5. Overlay Charts
- 7.2.6.3.5.1. Multiple Axes Titles
- 7.2.6.3.6. Dial Charts
- 7.2.6.3.6.1. Control Area Scale Labels
- 7.2.6.3.7. HLCO Charts
- 7.2.6.3.7.1. Changing Candle Stick Color
- 7.2.6.3.7.2. Changing CandleStick Wicker Width
- 7.2.6.3.8. Surface Charts
- 7.2.6.3.8.1. Heat Map
- 7.2.6.4. Performance
- 7.2.6.4.1. BufferedImage or Frame
- 7.2.6.4.2. Chart Generation Order
- 7.2.6.5. Viewer
- 7.2.6.5.1. Call Back Mechanism
- 7.2.6.5.2. Disable/Enable Tools-Tips Text
- 7.2.6.5.3. Canvas Area
- 7.2.7. Changing Chart Viewer Options
- 7.2.8. Javadoc
- 7.2.9. Swing Version
- 7.2.10. Summary
- 7.3. Managing Users and Groups
- 7.3.1. Introduction
- 7.3.2. Users and Groups
- 7.3.2.1. Creating Users and Groups
- 7.3.2.2. Deleting Users and Groups
- 7.3.3. Single Sign-On
- 7.3.4. Login Listener
- 7.3.5. Javadoc
- 7.3.6. Summary
- 7.4. ERES Menu API Overview
- 7.4.1. Introduction and Setup
- 7.4.2. Using the API
- 7.4.2.1. Creating and Customizing an ERES Menu
- 7.4.2.1.1. Connecting to ERES Server
- 7.4.2.1.2. Getting User Menu Page
- 7.4.2.1.3. Getting all Visible Nodes
- 7.4.2.1.4. Getting the Node Details
- 7.4.2.1.5. Getting the File Details
- 7.4.2.1.6. Scheduling/Archiving
- 7.4.2.2. Exporting Reports/Charts using the LookupServlet Servlet
- 7.4.3. Javadoc
- 7.4.4. Summary
- 7.5. Menu JSP Programming
- 7.5.1. Menu Page Architecture
- 7.5.2. Login Code
- 7.5.3. Building the Main Page
- 7.5.4. Running Reports and Charts
- 7.5.5. Retrieving Scheduled Reports and Charts
- 7.5.6. Running Archived Reports and Charts
- 7.5.7. Getter Methods
- 7.5.7.1. MenuMainPage
- 7.5.7.2. FolderNode
- 7.5.7.3. ItemNode
- 7.5.7.4. ItemScheduleJob
- 7.5.7.5. ItemArchiveJob
- 7.5.7.6. MenuRunReport
- 7.5.7.7. MenuRunChart
- 7.5.7.8. MenuRunSchedule
- 7.5.7.9. MenuReportSecurity
- 7.5.7.10. MenuRunArchive
- 7.5.7.11. MenuRunArchiveCHT
- 7.5.7.12. MenuArchiveSecurity
- 7.5.7.13. MenuScheduleParam
- 7.6. Organizer
- 7.6.1. Introduction
- 7.6.2. Look and Feel
- 7.6.3. Inserting and Removing Items
- 7.6.4. Customizing Report and Chart Designer
- 7.6.5. Calling Scheduler
- 7.6.6. Javadoc
- 7.6.7. Summary
- 7.7. Scheduler
- 7.7.1. Introduction
- 7.7.2. Scheduling an Export
- 7.7.3. Scheduling Multiple Exports
- 7.7.4. Scheduling an Archive
- 7.7.5. Removing a Schedule
- 7.7.5.1. Getting Details of a Failed Schedule
- 7.7.5.2. ICallBackScheduler Interface
- 7.7.5.3. Scheduler Listener
- 7.7.5.4. Report Bursting
- 7.7.5.5. Javadoc
- 7.7.5.6. Summary
- 7.8. SOAP Interface
- 7.8.1. LookupService Running
- 7.8.1.1. Request Message
- 7.8.1.1.1. Header Elements
- 7.8.1.1.2. Body Elements
- 7.8.1.1.3. Request Message Attachments
- 7.8.1.1.4. Example of Request Message
- 7.8.1.1.5. Passing Query Parameters
- 7.8.1.2. Response Message
- 7.8.1.2.1. Messages from the LookupService
- 7.8.1.2.2. Response Message Attachments
- 7.8.1.3. SimpleSOAPMessenger
- 7.8.1.3.1. SOAP Client Example
- 7.9. Deployment
- 7.9.1. Introduction
- 7.9.2. Deploying with ERES Server
- 7.9.2.1. Report Designer
- 7.9.2.2. Report Viewer
- 7.9.2.3. Page Viewer
- 7.9.2.4. Chart Viewer
- 7.9.2.5. Report API
- 7.9.2.6. Scheduler
- 7.9.3. Deploying without ERES Server
- 7.9.3.1. Report Viewer
- 7.9.3.2. Page Viewer
- 7.9.3.3. Chart Viewer
- 7.9.3.4. Report API
- 7.9.4. Deploying in a non-Windows environment
- 7.9.4.1. XvfB (X Virtual Frame Buffer)
- 7.9.4.2. JVM 1.5+ in Headless Mode
- 7.9.5. Platform Specific Issues
- 7.9.5.1. AS/400
- 7.9.5.1.1. Running Under NAWT
- 7.9.5.1.2. Running Under Headless Mode
- 7.9.5.2. Linux/Unix
- 7.9.5.2.1. Running under X
- 7.9.5.2.2. Running Under Headless Mode
- 7.A. Getting the Report Data
- 7.A.1. Data from a Database
- 7.A.1.1. Data from JNDI
- 7.A.2. Data from a Data File (TXT/DAT/XML)
- 7.A.3. Data from an XML Data Source
- 7.A.4. Data passed in an Array in Memory
- 7.A.5. Data passed in a Custom Implementation
- 7.A.6. Data from Enterprise Java Beans (EJBs)
- 7.A.7. Data from a SOAP Data Source
- 7.A.8. Data from Multiple Data Sources
- 7.B. Creating the Report
- 7.B.1. Simple Columnar
- 7.B.1.1. Column Mapping
- 7.B.1.2. Creating the Report
- 7.B.2. Summary Break
- 7.B.2.1. Column Mapping
- 7.B.2.2. Creating the Report
- 7.B.3. CrossTab
- 7.B.3.1. Column Mapping
- 7.B.3.2. Creating the Report
- 7.B.3.3. Fixed-field Crosstab Report
- 7.B.3.3.1. Creating the Report
- 7.B.4. Master & Details
- 7.B.4.1. Column Mapping
- 7.B.4.2. Creating the Report
- 7.B.5. Mailing Labels
- 7.B.5.1. Column Mapping
- 7.B.5.2. Creating the Report
- 7.B.6. Formula
- 7.B.7. Parameterized Report
- 7.B.7.1. Creating the Report with Single Value Parameter
- 7.B.7.2. Creating the Report with Multi Value Parameter
- 7.B.8. Sub-Report
- 7.B.8.1. Creating the Report
- 7.B.9. Drill-Down
- 7.B.9.1. Creating the Report
- 7.C. Getting the Chart Data
- 7.C.1. Data from a Database
- 7.C.1.1. JNDI
- 7.C.2. Data from a Data file (TXT/DAT/XML)
- 7.C.3. Data from a XML Data Source
- 7.C.4. Data Passed in an Array in Memory
- 7.C.5. Data Passed in your Custom Implementation
- 7.C.6. Data from a Spreadsheet Model
- 7.C.7. Data from Enterprise Java Beans (EJBs)
- 7.C.8. Data from multiple Data Sources
- 7.C.9. Data in Spreadsheet Format
- 7.C.10. Transposing Data
- 7.C.10.1. Non-Selective Transposing
- 7.C.10.2. Selective Transposing
- 7.D. Creating the Chart
- 7.D.1. Column, Bar, Line, Area, Pie and Overlay Charts
- 7.D.1.1. Column Mapping
- 7.D.1.2. Creating the Chart
- 7.D.2. Radar Charts
- 7.D.2.1. Column Mapping
- 7.D.2.2. Creating the Chart
- 7.D.3. XY(Z) Scatter Charts
- 7.D.3.1. Column Mapping
- 7.D.3.2. Creating the Chart
- 7.D.4. Stack Column, Percentage Column, Stack Bar and Stack Area Charts
- 7.D.4.1. Column Mapping
- 7.D.4.2. Creating the Chart
- 7.D.5. Dial Charts
- 7.D.5.1. Column Mapping
- 7.D.5.2. Creating the Chart
- 7.D.6. Box Charts
- 7.D.6.1. Column Mapping
- 7.D.6.2. Creating the Chart
- 7.D.7. Bubble Charts
- 7.D.7.1. Column Mapping
- 7.D.7.2. Creating the Chart
- 7.D.8. High-Low and HLCO Charts
- 7.D.8.1. Column Mapping
- 7.D.8.2. Creating the Chart
- 7.D.9. Surface Charts
- 7.D.9.1. Column Mapping
- 7.D.9.2. Creating the Chart
- 7.D.10. Gantt Charts
- 7.D.10.1. Column Mapping
- 7.D.10.2. Creating the Chart
- 7.D.11. Polar Charts
- 7.D.11.1. Column Mapping
- 7.D.11.2. Creating the Chart
- 7.D.12. Date/Time Based Zoom Charts
- 7.D.13. Parameterized Charts
- 7.D.14. Drill Down Charts
- 7.D.14.1. Parameter Drill Down Charts
- 7.D.14.2. Data Drill Down Charts
- 7.D.14.3. Dynamic Data Drill Down Charts
- 7.D.15. Adding a Chart to a Report
- 7.D.15.1. Adding a Chart Template
- 7.D.15.2. Adding a Chart that uses Report Data
- 7.D.15.3. Adding a Chart that uses an Independent Data Source
- 8. Configuration
- 8.1. Using Other Databases
- 8.1.1. Create Table Scripts
- 8.1.1.1. Database Specific Notes
- 8.1.1.1.1. DB2
- 8.1.1.1.2. MS SQL Server
- 8.1.1.1.3. MySQL
- 8.1.1.1.4. Oracle
- 8.1.2. Specifying the Database Connection
- 8.1.3. Migrating the ERES Database
- 8.2. Integrating Existing Users/Groups
- 8.2.1. Using a Database
- 8.2.2. Implementing UserSecurityProvider
- 8.2.2.1. Deploying UserSecurityProvider
- 8.3. Using Other Application Servers
- 8.3.1. Tomcat 4.1/5.x/6.0.x/7.0.x
- 8.3.2. Resin
- 8.3.2.1. Resin 3.x/4.x
- 8.3.2.2. Resin 2.1.12
- 8.3.3. WebLogic Server
- 8.3.3.1. WebLogic Server 9.2/10.3
- 8.3.3.1.1. WebLogic Server 8.1
- 8.3.3.1.2. WebLogic Server 7.0
- 8.3.3.1.3. WebLogic Server 7.0 - Quick Deployment
- 8.3.4. WebSphere
- 8.3.4.1. WebSphere 7.1
- 8.3.4.2. WebSphere 5.0/6.1
- 8.3.4.3. WebSphere on z/OS
- 8.3.5. JBoss 3.2.3 (with Tomcat 5.0) / JBoss 4.0.5/6.0.0
- 8.3.6. Oracle Containers for J2EE (OC4J) 10g (9.0.4.0/10.1.3.5)
- 8.3.7. Oracle Application Server 10g R3 (10.1.3)
- 8.3.8. GlassFish Server 3.0.1
- 8.4. Clustering/Load Balancing
- 8.4.1. Tomcat 5.0
- 8.4.1.1. Running ERES in a Tomcat Cluster
- 8.4.1.2. Set up ERES clustering using Apache Web Server and Tomcat
- 8.4.2. JBoss 3.2.5 (with Tomcat 5.0)
- 8.4.2.1. Running ERES in a JBoss Cluster
- 8.4.3. JRun 4 (with Apache Web server)
- 8.4.3.1. Running ERES in a JRun Cluster
- 8.4.4. WebSphere 6.0
- 9. Internationalization
- 9.1. Internationalizing ERES
- 9.1.1. Specifying Locales
- 9.1.1.1. Locale-Specific Formatting
- 9.1.1.2. Setting Time Zones and Locales Using the API
- 9.1.2. Language and Encoding
- 9.1.2.1. ERES Language Translation
- 9.1.2.1.1. Upgrading Language File
- 9.1.2.2. Displaying Foreign Characters
- 9.1.2.3. Entering Foreign Characters
- 9.1.2.4. XML Encoding
- 9.1.2.5. Exporting With Foreign Characters
- 9.1.2.6. Specifying Encoding for Text Data Files
- 10. Alerts
- 10.1. What is an Alert
- 10.2. Specifying alerts
- 10.2.1. Google Maps
- 10.2.2. SVG Maps
- 10.2.3. Charts
- 10.2.4. Reports
- 10.2.4.1. Subreports
- 10.2.4.2. Charts in reports
- 10.3. Dashboard alerts
- 10.3.1. Visual alert display
- 10.3.2. User interface
- 10.4. Monitoring
- 10.4.1. Alert notifications
- 10.4.2. Failed emails
- 10.4.3. User interface
- 10.4.3.1. Create/Edit monitoring dialog
- 10.4.3.2. Monitoring list
- 10.4.4. Monitoring log
- 10.5. Handling special situations
- 10.5.1. Change in script/control area/range
- 10.5.2. Missed monitoring jobs