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
- Properties of the Details Section
- Use the Field Explorer
- 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
|
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
|