Crystal/SQL Basic Highland, IN
Highland, IN Monday, April 14, 2008

Crystal/SQL Basic Highland, IN
Monday, April 14, 2008 9:00 am -
Friday, April 18, 2008 4:00 pm (Eastern Time)

Prompt Ambulance Service
9835 Express Drive
Highland, IN 46322
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 + Administrative Fee: $225.00 = $1725.00

Please send checks to:

ZOLLDATA SYSTEMS
Attn: Cheryl Fleharty
12202 Airport Way
Suite 300
Broomfield, CO  80021
HACKER SAFE certified sites prevent over 99% of hacker crime.
TRUSTe Certified Privacy