Crystal Reports

This course is designed to introduce you to the power of Crystal Reports, and give you a solid grounding in the basics of report creation. The course assumes you are new to Crystal Reports but that you have good Windows skills and an understanding of database software.

Level 1

1 Day

Printable Version

Syllabus

Terminology and Information Type Working in design mode
Managing Objects and Sections
Sorting and Grouping
TopN Reports
Basic Group Charts
Grand Totals, Subtotals and Summaries Cross-Tab Objects
Record Selection
Creating links
Formulas
Functions in Formulas
Math Functions: Round, Sum, Count, Average, Minimum, Maximum
String Functions: Right, Val, ToText
Date Math and Date Functions: Year, Month, Day, DayOfWeek, CurrentDate
Date Range Functions: MonthToDate, YearToDate
Null values in formulas: IsNull
Other Operators
If-Then-Else logic
Concatenation
Checking for one string within another Substring
Value in range
Value in list
Pasting "browsed" data into a formula Visual Effects and Presentation
Larger text objects
How to Use what You’ve Learnt

If you would like to have a course customised for your organisation, please contact us.