Crystal Report Training

Date: 7 April 2020

Time: 9a.m. – 5.pm

Course Description:

This course covers the capabilities of the Crystal Report as the reporting mechanism in SyteLine. It covers the settings and functions in SyteLine necessary to use Crystal Report, how to create report using Crystal report authoring tools, how to integrate those reports into SyteLine.

Course Duration: 1 Day

Who Should Attend: 

  • System Administrator
  • Support
  • IT
  • Developer

Syllabus:

  1. Crystal Report
    1.1 Create Report by Wizard
    1.2 Create Report from Scratch
  2. Data Connections
    2.1 Database Expert
    2.2 Selecting Database Objects
    2.3 Joins and Linking Tables
    2.4 Verifying Database Connections
    2.5 Set Data Source Connections
  3. Report Design
    3.1 Placing Fields and delete fields on Reports
    3.2 Previewing Field Data
    3.3 Customizing Layout Options
    3.4 Creating Report Titles
    3.5 Group Expert
    3.6 Record Sort Expert
  4. Report Filtering
    4.1 Parameter Fields
    4.2 Select Expert
  5. Report Formatting
    5.1 Page Margins and Orientation
    5.2 Font and Alignment
    5.3 Formatting Multiple Selections
    5.4 Format Painter
    5.5 Formatting Editor Options
    5.6 Customizing Formatting Editor
    5.7 Inserting Lines
    5.8 Border Styles and Colors
    5.9 Drawing/Formatting Boxes
    5.10 Inserting Pictures
    5.11 Highlight Expert
    5.12 Formatting Fields
  6. Reports Tools
    6.1 Sub Report
    6.2 Cross Tab
  7. Exercise

Learning Outcome:

Upon completion of this course, you will be able to:

  • Identify the elements of the Crystal Reports interface
  • Create a new report
  • Format objects
  • Insert and edit text boxes
  • Open an use the Select Expert
  • Define criteria for record selection
  • Apply record selection to date fields
  • Sort report records
  • Group records in meaningful sequences
  • Modify groups
  • Summarize and subtotal information
  • Create grand totals
  • Apply special formatting to objects
  • Use special Crystal Reports fields
  • Add lines and boxes and insert pictures
  • Import elements into a text box
  • Format individual elements of a text object
  • Use basic formulas in Crystal Reports

Register Now

Fill out this form to register for the online training:

    Your Name (required)

    Your Email (required)

    Job Title (required)

    Mobile Number (required)

    Company Name (required)

    Please Select The Course
    Crystal ReportSystem AdminWorkbench Suite DataViewForm PersonalizationAdvanced Form PersonalizationMongoose ReportingDatabase ManagementEvent System

    Your Message

    Your Message

    Terms & Conditions:

    1. Price only applicable from 6th – 20th April 2020.
    2. Price is strictly per pax basis.
    3. For each training, participants must register at least 2 days before the course date.

    Registration & Payment:

    1. Upon registration a confirmation email will be sent automatically to the registrant.
    2. Your registration is complete upon receipt of confirmation from us. You will receive a confirmation of your registration via e-mail.
    3. Payment is due upon receipt of invoice.

    Cancellation:

    1. Cancellations allowed up to 48 hrs before the course.  After that, no further cancellations will be entertained.