|
Back to training page
Crystal Reports
Installation And Settings (Remote Assistance Classroom Prep - Required)
Crystal Reports Installation
Crystal Reports Drivers
SDE Database Architecture (SQL Backend) (Pre-req. – 1/4 Day)
Table and View Relationships
SDE System Tables
Concept: How Database Customizations Improve Reporting
Basic Skills (1/4 Day)
The Crystal Reports Design window
Toolbar and shortcut menu
Field Explorer
Designing your report – best practices
Basic Report Creation (1/4 Day)
Crystal Reports Database Expert
Creating Reports – Using One View
Selecting Views For Your Report
Formatting Report (1/2 Day)
Moving, Resizing, and Aligning Objects
Formatting Database Fields
Using Text on Your Report
Inserting a Picture
Inserting Special Fields
Adding Lines and Boxes
Sorting, Grouping, and Summarizing (1/2 Day)
Creating Groups
Sorting Records
Customizing Group Name
Grouping Data Hierarchically
Record Selection – (1/2 Day)
Selecting Report Records
Select Record Options
Selecting Records From Two Or More Fields
Ensuring that statements pass to SQL for Improved Report Processing |
Advanced File Linking (1/2 Day)
Overview – Joins and Linking Views
Creating Links
Types of Joins
Understanding and Using Aliases
Formula Basics (1/2 Day)
Components Of A Formula
Formula Editor
Concatenation
Using If... Then... Else
Conditional Formatting
Absolute Vs. Conditional Formatting
Conditionally Formatting Fields and Objects
Advanced Formulas (1 Day)
Understanding and Using Variables
Using Select Case Statements
Using For Loops
Running Totals
Manual Running Totals
Advanced Subreports (1/2 Day)
Understanding Subreports – Linked and Unlinked
On Demand Subreports
Tips and Tricks with Subreports
BMC SDE - Report Configuration (1/4 Day)
Adding your report to BMC SDE
Uploading a report to a configuration
Troubleshooting Configuration Issues
Advanced SQL Expressions – (1/4 Day)
Understanding SQL Expressions (Database Specific)
Correlated vs. Non-correlated
Improving Report Performance
Benefits and Limitations |
