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