Course Outline

CREATING A LIST REPORT
•  Set Default Report Settings
•  Build the Report
•  Preview the Report
•  Add a Report Title
•  Align Fields

DISPLAYING DATA IN A REPORT
•  Find Data
•  Sort Data
•  Filter Data by Single Criteria

GROUPING REPORT DATA
•  Insert a Group
•  Add Summaries
•  Change Group Options
•  Add an Additional Group
•  Format a Group Header
•  Filter by Group
•  Create a Top N Sort Group

BUILDING FORMULAS
•  Write a Formula
•  Edit a Formula
•  Group by Formula
•  Delete a Formula
•  Build a Filter by Multiple Criteria
•  Modify a Filter with Multiple Criteria to Create an OR Condition
•  Create a Parameter Field
•  Write a Formula that Incorporates Null Fields

FORMATTING REPORTS
•  Remove White Space
•  Insert Page Header/Footer Data
•  Add Borders and Lines
•  Change the Background Color
•  Change the Margins

ENHANCING REPORTS
•  Create a Watermark
•  Add Bulleted Lists
•  Modify Format Based on Data Value
•  Conditionally Suppress Data
•  Insert Hyperlinks
•  Hide Report Objects

CREATING AND MODIFYING PIE CHARTS
•  Create a Pie Chart with a Drill-down
•  Change the Chart Title
•  Format a Chart
•  Present a Chart by Group

DISTRIBUTING DATA
•  Export to Excel
•  Export to an Access Database
•  Create a Report Definition
•  Create Mailing Labels

CREATING RUNNING TOTALS
•  Create a Running Total Field
•  Modify a Running Total Field
•  Create a Manual Running Total on Detail Data
•  Create a Manual Running Total on Summary Data

BUILDING CROSS-TABS IN YOUR REPORT
•  Create a Cross-tab
•  Create a Specified Group Order
•  Filter Cross-tab by Group
•  Change the Cross-tab Format
•  Format Rows and Columns
•  Keep Groups Together

ADDING SUBREPORTS
•  Insert a Subreport
•  Link a Subreport to Data in a Primary Report
•  Edit a Subreport
•  Format a Subreport Object
•  Share Formulas Between Main and Subreports
•  Create an On-demand Subreport

IMPROVING REPORT PROCESSING SPEED
•  Create a SQL Expression
•  Select Records on the Server
•  Write a SQL Query
•  Edit a SQL Query
•  Build a Report on a SQL Query
•  Create SQL Commands in the Crystal Report Environment