1.) Introduction to Report Designer
1.1.) Starting Report Designer
1.2.) Selecting a Data Source
2.) Report Types and Data Mapping
2.1.) Simple Columnar Report
2.1.1.) Data Mapping
2.1.1.1.) Top N Report
2.2.) Summary Break Report
2.2.1.) Data Mapping
2.2.1.1.) Top N Report
2.3.) Crosstab Report
2.3.1.) Data Mapping
2.3.2.) Transposing Data
2.3.3.) Fixed-field Crosstab Report
2.3.3.1.) Data Mapping
2.4.) Master & Details Report
2.4.1.) Data Mapping
2.4.1.1.) Top N Report
2.5.) Mailing Label Report
2.5.1.) Data Mapping
2.6.) Additional Formatting Options
2.6.1.) Custom Styles
2.6.1.1.) Creating a Custom Style
2.7.) Fit Columns to Page Width
2.8.) Change Data Mapping
3.) The Designer Interface
3.1.) Report Sections
3.1.1.) Nested Sections
3.2.) Resizing Sections
3.3.) Section Options
3.4.) Rulers
3.4.1.) Toggling Between Inches and Centimeters
3.5.) Designer Menus
3.5.1.) File Menu
3.5.2.) Edit Menu
3.5.3.) Insert Menu
3.5.4.) Format Menu
3.5.5.) View Menu
3.5.6.) Data Menu
3.5.7.) Drill Down Menu
3.5.8.) Option Menu
3.6.) Designer Toolbar
3.7.) Inserting and Manipulating Report Elements
3.7.1.) Inserting Elements
3.7.1.1.) Inserting Charts
3.7.1.1.1.) Inserting Summary Charts into Fixed-field Crosstab Reports
3.7.1.2.) Inserting Elements into the Table Data Section
3.7.2.) Editing Elements
3.7.2.1.) Editing Element Attributes
3.7.2.2.) Word Wrapping
3.7.2.3.) Editing Side-By-Side Master & Details Reports
3.7.3.) Data Formatting for Formulas and Column Fields
3.7.3.1.) Formatting Null Data
3.7.4.) Line/Rectangle Format
3.7.5.) Chart Export Format
3.7.6.) Font, Color, and Border Options
3.7.6.1.) Show Cell Outline
3.7.7.) Rich Text Fields
3.7.7.1.) Adding Formulas
3.7.8.) Hyperlinks
3.7.9.) Column Wrapping
3.7.10.) Table of Contents
3.7.10.1.) Adding a Table of Contents
3.7.11.) Moving and Resizing Report Elements
3.7.11.1.) Controlling Element Overlapping
3.7.11.2.) Locking Element Position
3.7.12.) Snap to Grid
3.7.13.) Shift Mode
3.7.14.) Guidelines
3.7.14.1.) Inserting Guidelines
3.7.14.2.) Positioning Elements with Guidelines
3.8.) Report Explorer
3.9.) Global Formatting, Group Formatting, and Templates
3.9.1.) Global Formatting
3.9.1.1.) Global Format Import/Export
3.9.1.2.) Global Formatting & Crosstab Reports
3.9.2.) Group Formatting
3.9.3.) Applying a Template
4.) The Preview Window
4.1.) Navigating the Report
4.2.) Other Preview Window Options
4.2.1.) Preview Data Options
4.2.2.) Sorting Data
4.2.3.) Parameter Prompts
4.2.4.) Using Page Viewer
4.3.) Setting Page Properties
5.) Saving and Exporting Reports
5.1.) Saving Reports
5.1.1.) XML Encoding
5.2.) Exporting Reports
5.2.1.) PDF Font Mapping
5.2.1.1.) PDF Font Mapping Import/Export
5.2.2.) CSS Options
6.) Using Formulas & the Formula Builder
6.1.) Creating a Formula
6.1.1.) The Formula Builder
6.2.) Formula Syntax
6.2.1.) Using Column Field Data
6.2.1.1.) Column Aggregation
6.2.2.) Using Formulas
6.2.3.) Using Parameter Values
6.2.4.) Using Database Fields
6.2.5.) Constants
6.2.6.) Formula Parameters
6.2.6.1.) Initializing Formula Parameters
6.2.7.) Operators
6.2.7.1.) Arithmetic Operators
6.2.7.2.) Boolean Operators
6.2.8.) Functions
6.2.8.1.) Numeric Functions
6.2.8.2.) String Functions
6.2.8.3.) Date/Time Functions
6.2.8.4.) Custom Functions
6.3.) Sub-report Formula Access
7.) Scripting
7.1.) Creating a Script
7.2.) Script Syntax
7.2.1.) Formatting Actions
7.2.1.1.) Scripting Image URLs
7.2.2.) Variables & Arrays
7.2.2.1.) Variables
7.2.2.2.) Arrays
7.2.3.) Using Formulas
7.2.4.) Checking for Nulls
7.2.5.) Row-Specific Options
7.2.6.) Loops
7.2.7.) Section Scripts
7.2.7.1.) Formatting Actions for Section Scripts
7.2.8.) Commenting Scripts
7.2.9) Accessing Values Computed by Other Scripts
7.3.) Managing Scripts
8.) Drill Down
8.1.) Creating a Drill Down Report
8.1.1.) Drill Down Links
8.1.1.1.) Linking from Charts
8.2.) Multi-Value Drill Down
8.2.1.) Creating a Multi-Value Drill Down Report
8.3.) Crosstab Drill Down
8.2.1.) Creating a Multi-Value Drill Down Report
8.4.) Viewing Drill Down Reports
8.5) Unmapped Parameter Drill-down
9.) Sub-Reports
9.1.) Adding a Sub-Report
9.2.) Editing a Sub-Report
9.2.1.) Sub-Report sizing
9.3.) Removing a Sub-Report
9.4.) Linked Sub-Reports
9.4.1.) Using Linked Sub-Reports
9.5.) Parameter Linking
10.) Template Security
10.1.) Security Levels
10.2.) Cell-Level Security
10.3.) Security Parameters
10.4.) Security for Sub-Reports & Drill Down Layers
10.5.) Viewing Secured Templates
10.5.1.) Secured Report Designer
11.) Introduction to Chart Designer
11.1.) Working With Charts
11.2.) Starting Chart Designer
11.3.) Selecting a Data Source
11.3.1.) Chart Parameter Linking
11.3.2.) Transposing Data
12.) Charting Basics
12.1.) What's in a Chart
12.2.) Basic Data Mapping
12.3.) Saving and Exporting Charts
12.3.1.) Saving Chart Definitions
12.3.2.) Generating Image Files
13.) Chart Types and Data Mapping
13.1.) Data Mapping
13.2.) Column Charts
13.2.1.) Data Mapping
13.3.) Bar Charts
13.3.1.) Data Mapping
13.4.) XY(Z) Scatter Charts
13.4.1.) Data Mapping
13.5.) Line Charts
13.5.1.) Data Mapping
13.6.) Stack Column Charts
13.6.1.) Data Mapping
13.7.) Stack Bar Charts
13.7.1.) Data Mapping
13.8.) Pie Charts
13.8.1.) Data Mapping
13.9.) Area Charts
13.9.1.) Data Mapping
13.10.) Stack Area Charts
13.10.1.) Data Mapping
13.11.) High-Low Charts
13.11.1.) Data Mapping
13.12.) HLCO Charts
13.12.1.) Data Mapping
13.13.) Percentage Column Charts
13.13.1.) Data Mapping
13.14.) Surface Charts
13.14.1.) Data Mapping
13.15.) Bubble Charts
13.15.1.) Data Mapping
13.16.) Overlay Charts
13.16.1.) Data Mapping
13.17.) Box Charts
13.17.1.) Data Mapping
13.18.) Radar Charts
13.18.1.) Data Mapping
13.19.) Dial Charts
13.19.1.) Data Mapping
13.19.2.) Gauges
13.20.) Gantt Charts
13.20.1.) Data Mapping
13.21.) Polar Charts
13.21.1.) Data Mapping
13.22.) Change Data Mapping
14.) The Chart Designer Interface
14.1.) The Designer Menus
14.1.1.) File Menu
14.1.2.) Insert Menu
14.1.3.) Format Menu
14.1.4.) Type Menu
14.1.5.) Drill-Down Menu
14.1.6.) Data Menu
14.1.7.) Layout Menu
14.2.) The Designer Toolbar
14.3.) Color, Pattern, and Font Panels
14.3.1.) Color Panel
14.3.2.) Pattern Panel
14.3.3.) Font Panel
14.4.) The Navigation Panel
14.5.) The Viewport
14.5.1.) The Chart Canvas
14.5.1.1) Background Images
14.5.2.) Moving and Sizing Chart Elements
14.6.) Adding Chart Elements
14.6.1.) Adding Text
14.6.1.1) Text Variables
14.6.1.2) Text Replacement
14.6.1.3) Automatic Text Re-sizing
14.6.1.4) Text Cropping
14.6.2.) Adding Lines
14.6.2.1) Line and Point Formatting
14.6.2.2) Floating Lines
14.6.2.3) Fixed Horizontal/Vertical Lines
14.6.2.4) Trend Lines
14.6.2.4.1) Normal Distribution Curve
14.6.3.) Adding Control Areas
14.6.4.) Adding Tables
14.6.5.) Adding Hyperlinks
14.6.5.1) Viewing Hyperlinks
14.7.) Formatting Chart Axes
14.7.1.) Axis Scale
14.7.2.) Axis Elements
14.7.2.1) Axis Label Formatting
14.8.) Formatting Plot/Data Elements
14.8.1.) Data Properties
14.8.2.) Date/Time Based Zooming
14.8.2.1) Adding Zooming
14.8.2.2) Zooming in Chart Viewer
14.8.3.) Data Ordering
14.8.4.) Histograms
14.8.5.) Formatting Plot Area
14.8.6.) Formatting Chart Legend
14.8.7.) 3D Rendering Approximation
14.8.8.) Column Borders
14.9.) Chart-Specific Options
14.9.1.) Bubble Charts
14.9.2.) Dial Charts
14.9.2.1.) Gauge Images
14.9.3.) Overlay Charts
14.9.4.) Pie Charts
14.9.5.) Line Charts
14.9.5.1) Double Value Line Charts
14.9.6.) HLCO Charts
14.9.7.) Box Charts
14.9.8.) Stack Area Charts
14.9.9.) Gantt Charts
14.9.10.) Radar Charts
14.9.11.) Scatter Charts
14.9.12.) Polar Charts
14.9.13.) Column Charts with Series
14.9.14.) Two-Dimensional Line Combination Charts
15.) Chart Drill Down
15.1.) Data Drill Down
15.1.1.) Adding Data Drill Down
15.2.) Dynamic Data Drill Down
15.3.) Parameter Drill Down
15.3.1.) Adding Parameter Drill Down
16.) Saving & Exporting Charts
16.1.) Saving Charts
16.2.) Saving Charts with Report Data
16.2.1.) Working with Templates
16.2.2.) Saving XML Templates
16.2.3.) Creating a Viewer Page
16.2.3.1) Viewer Options
16.3.) Exporting Charts
16.3.1.) PDF Font Mapping
16.3.1.1) PDF Font Mapping Import/Export
17.) Introduction to QuickDesigner
17.1.) Starting QuickDesigner
17.2.) Selecting a Data Source
17.2.1.) Changing Data Source
18.) QuickDesigner Queries
18.1.) Selecting Fields
18.1.1.) Building Columns
18.1.2.) Querying Encrypted Data
18.2.) Setting Conditions
18.2.1.) Previewing Query Results
18.2.2.) Parameterized Queries
18.2.2.1) Initializing Query Parameters
18.2.3.) Saving Queries
18.2.4.) Viewing SQL Query
18.2.5.) Aggregation Alias
18.3.) Editing Queries
19.) Data Mapping
19.1.) Report Mapping Options
19.2.) Report Styles
19.3.) Chart Mapping Options
19.4.) Changing Data Mapping
20.) The QuickDesigner Interface
20.1.) The QuickDesigner Toolbar
20.1.1.) Using the Toolbar
20.2.) Inserting and Formatting Report Elements
20.2.1.) Font, Color and Border Options
20.2.2.) Data Formatting for Formulas and Column Fields
20.2.3.) Inserting Elements
20.2.3.1) Inserting/Editing Aggregations
20.2.3.2) Inserting/Editing Charts
20.2.4.) Sizing Report Elements
20.2.4.1) Re-size to Fit Content
20.3.) Ordering and Sorting
20.3.1.) Changing Column Order
20.3.2.) Sorting
21.) Saving and Exporting Reports
21.1.) Saving Reports
21.2.) Exporting Reports
21.2.1.) Page Setup
22.) Charts in QuickDesigner
22.1.) The QuickDesigner Toolbar
22.1.1.) Using the Toolbar
22.2.) Positioning and Sizing Charts
22.2.1.) Setting Canvas Size
22.2.2.) Setting Chart Position and Size
22.2.3.) 3D Chart Options
22.3.) Font and Color Options
22.3.1.) Adding/Editing Chart Titles
20.3.1.1) Text Variables
22.3.2.) Setting Chart Fonts
22.3.3.) Setting Chart Colors
22.4.) Formatting Chart Axes
22.4.1.) Setting Axis Scale
22.4.2.) Setting Axis Elements
20.4.2.1) Axis Label Formatting
22.5.) Formatting Plot/Data Elements
22.5.1.) Data Properties
22.5.2.) Line And Point Formatting
22.5.3.) Data Ordering
22.5.4.) Formatting Plot Area
22.5.5.) Formatting Chart Legend
22.6.) Chart-Specific Options
22.6.1.) Dial Charts
22.6.2.) Pie Charts
22.6.3.) HLCO Charts
22.6.4.) Gantt Charts
22.6.5.) Polar Charts
23.) Saving & Exporting Charts
23.1.) Saving Charts
23.2.) Exporting Charts
Appendix A: ERES XML Chart File Parameters