1.) Overview / Introduction
1.1.) Version 6.0 New Features
1.2.) EspressReport Documentation
2.) Architecture & Installation
2.1.) EspressReport Architecture
2.2.) Installation
2.2.1.) Configuration
2.2.1.1) Increasing maximum memory heap size for applets
2.3.) Starting EspressManager
2.3.1.) EspressManager Configuration
Interface
2.3.2.) Starting EspressManager as a Servlet
2.3.2.1) Deploying EspressManager
as a servlet in Tomcat 4.x/5.x
2.4.) Starting Report Designer
2.4.1.) Connecting Report Designer to
EspressManager Running as a Servlet
2.5.) Backward compatibility patches
3.) Working with Data Sources
3.1.) The Data Source Manager
3.1.1.) Using Data Source Manager
3.2.) Data from a Database
3.2.1.) JNDI Data Sources
3.2.2.) Queries
3.2.2.1) Using Query Builder
3.2.2.1.1) Tables
3.2.2.1.2) Joins
3.2.2.1.3) Columns
3.2.2.1.4) Using Database Functions
3.2.2.1.5) Adding Extra SQL
3.2.2.1.6) Query Output
3.2.2.2) Parameterized Queries
3.2.2.2.1) Multi-Value Parameters
3.2.2.2.2) Initializing Query Parameters
3.2.2.2.3) Cascading Parameters
3.2.2.3.) Entering SQL Statements
3.2.2.3.1.) Calling Oracle Stored Procedures
3.2.3.) Data Views
3.2.3.1.) Data View Parameters
3.2.3.2.) Updating Data View Queries
3.2.4.) Editing Queries
3.2.5.) Editing Database Connections
3.3.) Data from XML and XBRL Files
3.3.1.) XML Queries
3.3.1.1.) XML Parameters
3.4.) Data from Text Files
3.4.1.) Formatting Requirements for Text Files
3.4.2.) Data Types and Format for Text Files
3.5.) Data from Class Files
3.5.1.) Parameterized Class Files
3.6.) Data from EJBs
3.7.) Data from SOAP with WSDL support
3.8.) Data from Salesforce
3.9.) Data from Excel files
3.10.) Using Multiple Data Sources
3.11.) Change Data Source
3.12.) Data Source Updating
4.) Report Types and Data Mapping
4.1.) Simple Columnar Report
4.1.1.) Data Mapping
4.1.1.1.) Top N Report
4.2.) Summary Break Report
4.2.1.) Data Mapping
4.2.1.1.) Top N Report
4.3.) Crosstab Report
4.3.1.) Data Mapping
4.3.2.) Transposing Data
4.3.3.) Fixed-field Crosstab Report
4.3.3.1.) Data Mapping
4.4.) Master & Details Report
4.4.1.) Data Mapping
4.4.1.1.) Top N Report
4.5.) Mailing Label Report
4.5.1.) Data Mapping
4.6.) Additional Formatting Options
4.6.1.) Custom Styles
4.6.1.1.) Creating a Custom Style
4.6.1.2.) Applying a Custom Style
4.7.) Fit Columns to Page Width
4.8.) Change Data Mapping
5.) The Designer Interface
5.1.) Report Sections
5.1.1.) Nested Sections
5.2.) Resizing Sections
5.3.) Section Options
5.4.) Rulers
5.4.1.) Toggling Between Inches and
Centimeters
5.5.) Designer Menus
5.5.1.) File Menu
5.5.2.) Edit Menu
5.5.3.) Insert Menu
5.5.4.) Format Menu
5.5.5.) View Menu
5.5.6.) Data Menu
5.5.7.) Drill Down Menu
5.5.8.) Option Menu
5.6.) Designer Toolbar
5.7.) Inserting and Manipulating Report
Elements
5.7.1.) Inserting Elements
5.7.1.1.) Inserting Charts
5.7.1.1.1.) Inserting Summary Charts
into Fixed-field Crosstab
Reports
5.7.1.2.) Inserting Elements into the
Table Data Section
5.7.2.) Editing Elements
5.7.2.1.) Editing Element Attributes
5.7.2.2.) Word Wrapping
5.7.2.3.) Editing Side-By-Side Master &
Details Reports
5.7.3.) Data Formatting for Formulas and
Column Fields
5.7.3.1.) Formatting Null Data
5.7.4.) Line/Rectangle Format
5.7.5.) Chart Export Format
5.7.6.) Font, Color, and Border Options
5.7.6.1.) Show Cell Outline
5.7.7.) Rich Text Fields
5.7.7.1.) Adding Formulas
5.7.8.) Hyperlinks
5.7.9.) Column Wrapping
5.7.10.) Table of Contents
5.7.10.1.) Adding a Table of Contents
5.7.11.) Moving and Resizing Report Elements
5.7.11.1.) Controlling Element Overlapping
5.7.11.2.) Locking Element Position
5.7.12.) Snap to Grid
5.7.13.) Shift Mode
5.7.14.) Guidelines
5.7.14.1.) Inserting Guidelines
5.7.14.2.) Positioning Elements with
Guidelines
5.8.) The Report Explorer
5.9.) Global Formatting, Group Formatting, and
Templates
5.9.1.) Global Formatting
5.9.1.1.) Global Format Import/Export
5.9.1.2.) Global Formatting & Crosstab
Reports
5.9.2.) Group Formatting
5.9.3.) Applying a Template
5.10.) Report Designer in Mac OS X
6.) The Preview Window
6.1.) Navigating the Report
6.2.) Other Preview Window Options
6.2.1.) Preview Data Options
6.2.2.) Sorting Data
6.2.3.) Parameter Prompts
6.2.4.) Using Page Viewer
6.2.4.1.) Unmapped Drilldown Parameter
6.3.) Setting Page Properties
7.) Saving and Exporting Reports
7.1.) Saving Reports
7.1.1.) Changing the Save Location
7.1.2.) XML Encoding
7.2.) Exporting Reports
7.2.1.) PDF Font Mapping
7.2.1.1.) PDF Font Mapping Import/Export
7.2.2.) CSS Options
8.) Using Formulas & the Formula Builder
8.1.) Creating a Formula
8.1.1.) The Formula Builder
8.2.) Formula Syntax
8.2.1.) Using Column Field Data
8.2.1.1.) Column Aggregation
8.2.2.) Using Formulas
8.2.3.) Using Parameter Values
8.2.4.) Using Database Fields
8.2.5.) Constants
8.2.6.) Formula Parameters
8.2.6.1.) Initializing Formula Parameters
8.2.7.) Operators
8.2.7.1.) Arithmetic Operators
8.2.7.2.) Boolean Operators
8.2.8.) Functions
8.2.8.1.) Numeric Functions
8.2.8.2.) String Functions
8.2.8.3.) Date/Time Functions
8.2.8.4.) Custom Functions
8.3.) Subreport Formula Access
9.) Scripting
9.1.) Creating a Script
9.2.) Script Syntax
9.2.1.) Formatting Actions
9.2.1.1.) Scripting Image URLs
9.2.2.) Variables & Arrays
9.2.2.1.) Variables
9.2.2.2.) Arrays
9.2.3.) Using Formulas
9.2.4.) Checking for Nulls
9.2.5.) Row-Specific Options
9.2.6.) Loops
9.2.7.) Section Scripts
9.2.7.1.) Formatting Actions for Section
Scripts
9.2.8.) Commenting Scripts
9.2.9.) Accessing Values Computed by Other Scripts
9.3.) Managing Scripts
10.) Drill Down
10.1.) Creating a Drill Down Report
10.1.1.) Drill Down Links
10.1.1.1.) Linking from Charts
10.2.) Multi-Value Drill Down
10.2.1.) Creating a Multi-Value Drill Down
Report
10.3.) Crosstab Drill Down
10.3.1.) Creating a Crosstab Drill Down Report
10.4.) Viewing Drill Down Reports
10.5.) Unmapped Drill-Down
11.) Sub-Reports
11.1.) Adding a Sub-Report
11.2.) Editing a Sub-Report
11.2.1.) Sub-Report sizing
11.3.) Removing a Sub-Report
11.4.) Linked Sub-Reports
11.4.1.) Using Linked Sub-Reports
11.5.) Parameter Linking
12.) Template Security
12.1.) Security Levels
12.2.) Cell-Level Security
12.3.) Security Parameters
12.4.) Security for Sub-Reports &
Drill Down Layers
12.5.) Viewing Secured Templates
12.5.1.) Secured Report Designer
13.) Scheduling
13.1.) The Scheduler Interface
13.2.) Setting a Schedule
13.2.1.) Scheduling a Report
13.2.2.) Scheduling Parameterized Reports
13.2.3.) Email Delivery Options
13.2.4.) Specifying Email Recipients
13.2.4.1) Report Bursting
13.2.5.) Scheduling a Command
13.2.6.) Viewing and Editing Schedules