Crystal Reports: Beyond the Basics

Cost:
$450 for first attendee, $400 each additional company member

Time:
9 a.m. to 5 p.m.

Dates:
August 23, 2012

Where:
LAI Training Room
7440 East Sixth Ave.
Suite 100
Scottsdale, AZ 85251

Need more info?
Email | 480.423.8300

Who:
This 1-day class is for the intermediate Crystal report user, and one who is already familiar with Sage Timberline Office, Report Designer and the Sage Timberline Office database. We recommend participants attend the Beginning Crystal Report class before attending this Crystal class.

Content:
Advanced design including Linking, Subreports, Advanced Formulas, and Variables

Prerequisites:
We strongly recommend participants already have a familiarity with the database structure, field locations and have attended the Beginning Report Designer class as well as the Beginning Crystal Reports.

A minimum of three registrants is required to hold the class. We will notify you if the minimum is not met.

Register Now

Course Outline
Overview of Crystal Reports

  • Creating a report
  • Group and Sort Information
  • Formulas and Functions
  • ParametersMultiple Links and Ordering Links
  • Link Tables
  • Change Join Types

Working with Subreports

  • Create Subreports
  • Linked vs. Unlinked Subreports
  • Formatting a Subreport

Please Note: On Demand Subreports, & Passing Parameters to Subreports (not covered in class)

  • Learning about On Demand Subreports
  • Re-Importing Subreports
  • Passing Parameters to Subreports

Please Note: Multi-Pass Reporting & Evaluation Time (not covered in class)

  • Understanding Multi-Pass Reporting
  • Evaluation Time Functions
  • Performance Information
  • Multi-Pass Reporting and Summaries
 Variables

  • Declaring Variables
  • Range Variables
  • Variable Scope

Advanced Formulas & Functions

  • Arrays
  • For Loop Control Structure
  • Select Case Control Structure
  • Special String Functions
  • Null Values, Zero Values, and Empty Strings

Refining Your Reports (not covered in class)

  • Cross Tab Reports
  • Drill Down Reports
  • Stacking Formulas and Report Objects
  • Conditional Suppression of Report Sections

Please note: SQL Queries & Report Optimization (not covered in class)

 

  • Understand Query Structure
  • Record Selection
  • Indexed

Register Now

Your Information
  4. (required)
  5. (required)
  6. (valid email required)
  7. (required)
  8. (required)
  9. (required)
  11. Add additional registrants for registrant for $400?
 

cforms contact form by delicious:days