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