Crystal/SQL Basic
Broomfield, CO Monday, August 18, 2008
                                                                                  
Crystal/SQL Basic
Monday, August 18, 2008 9:00 am -
Friday, August 22, 2008 4:00 pm (Mountain Time)

ZOLL Data Systems
12202 Airport Way
Suite 300
Broomfield, CO 80021
USA

Map and Directions

Course Outline

 Lesson 1: Crystal Reports as a Tool

  • A First Look at Crystal and RescueNet
    • Open Crystal Reports Designer
    • Open a Report for Editing
    • Design Tab
    • Current Selection
    • Shortcut Menus
  • Crystal Reports and RescueNet in Action
    • Preview Tab
    • Data Retrieval Information

Lesson 2: ODBC and Data Sources

  • Open Database Connectivity (ODBC)
  • Create a New ODBC Connection

Lesson 3: Adding Fields and Filtering

  • Visual Linking Expert
    • Adding a Database Table
  • Properties of the Details Section
  • Use the Field Explorer
    • Insert a Database Field
  • Preview Report
  • Filter Data using the Select Expert

Lesson 4: Sorting, Grouping and Summarizing

  • Sorting
  • Grouping
    • Insert a Group
    • Modify an Existing Group
    • Delete a Group
    • Nesting and Reordering Groups
  • Summarizing
    • Insert a Summary Field
    • Insert a Grand Total

Lesson 5: Formatting

  • Fonts, Styles and Colors
  • Text Objects and Report Titles
  • Drawing Objects
  • Pictures and Logos
  • Printer Setup
  • Special Fields

Lesson 6: Links and Joins

  • Linking Database Tables on a Report
  • Modify Join Properties

Lesson 7: Basic Formulas

  • Create a New Formula
  • Use the Formula Expert
  • Basic Arithmetic Formulas
  • Variables
  • String Manipulation
  • Working with Date/Time fields in RescueNet

Lesson 8: Conditional Formatting and Section Formatting

  • Conditional Formatting
  • Conditional Font Colors
  • Conditional Suppression
  • Section Formatting

Lesson 9: RescueNet Reporting and .in2 Files

  • RescueNet Reporting Basics
    • Use selectors
    • Saved Report Settings
    • Report Scripts
    • Clone Reports
  • Using your Custom Reports inside of RescueNet Reporting
    • Create in2 file
    • Create selectors

Contact Information
Phone: 303-801-1477, Email: training@zolldata.com
Payment Instructions
Class Cost:  $1500.00
HACKER SAFE certified sites prevent over 99% of hacker crime.
TRUSTe Certified Privacy