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:
- Crystal Report
1.1 Create Report by Wizard
1.2 Create Report from Scratch - 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 - 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 - Report Filtering
4.1 Parameter Fields
4.2 Select Expert - 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 - Reports Tools
6.1 Sub Report
6.2 Cross Tab - 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:
Terms & Conditions:
- Price only applicable from 6th – 20th April 2020.
- Price is strictly per pax basis.
- For each training, participants must register at least 2 days before the course date.
Registration & Payment:
- Upon registration a confirmation email will be sent automatically to the registrant.
- Your registration is complete upon receipt of confirmation from us. You will receive a confirmation of your registration via e-mail.
- Payment is due upon receipt of invoice.
Cancellation:
-
Cancellations allowed up to 48 hrs before the course. After that, no further cancellations will be entertained.