Course
Crystal Reports Level 2
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Course Duration
2 Days Overview
Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.
Prerequisites
-
- To ensure your success on this advanced Crystal Reports course, we recommend that you first attend the course Crystal Reports Level 1 course, or have equivalent knowledge.
Objectives
-
- Understand and control the calculation process used to compile your data in Crystal Reports.
- Control the appearance of your Crystal report using conditional format statements and multiple sections.
- Create parameter formulas that allow users to determine what data they want to see on a Crystal report.
- Enhance the analysis capability of your cross-tabs.
- Create Crystal Reports formulas with multiple statements and use variables.
- Extend your reporting capacity by utilizing sub-reports.
- Access data from SQL/ODBC data sources, and generate queries using your own SQL statements.
- Create and edit graphical representations of your data using the Chart Expert or modify existing
What's included
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
Course Content
-
Crystal Reports Review ExercisesFormatting Crystal Reports sections for summary/drill-down
Creating formulas in Crystal Reports
Selecting, grouping and summarizing
Adding and linking databases
Creating a basic Crystal report -
Conditional Formatting in Crystal ReportsRemoving conditional formatting
Using the Crystal Reports highlighting expert
Assigning conditional attribute formatting
Applying and removing conditional on/off formatting in Crystal Reports
Understanding the difference between absolute and conditional formatting -
Advanced Formulas / Variables in Crystal ReportsUsing variables in formulas
Creating formulas using multiple variables in your Crystal report
Using evaluation time functions
Understanding multiple pass reporting
Creating running totals -
SQL and Commands in Crystal ReportsAdding parameters to your own SQL statement
Defining your own SQL as the Crystal report data source
Introduction to standard query language (SQL) -
Crystal Reports Parameter FieldsUsing Crystal Reports parameter fields to set conditional formats
Using Crystal Reports parameter fields to specify sort criteria
Understanding edit masks in Crystal Reports -
Report AlertsViewing record sets created by use of alerts
Creating and using Crystal report alerts -
Crystal Reports Multiple SectionsWorking with multiple sections and conditional formats
Moving, splitting and merging sections
Inserting and deleting sections -
SubreportsUsing variables to pass data from a sub report to the main report
Creating on-demand subreports
Formatting subreports
Inserting unlinked and linked subreports
Identifying when subreports are needed -
Basic & Advanced Cross-TabsUsing Crystal Reports formula fields & parameter fields with cross tab reports
Formatting cross Tab components
Inserting multiple rows, columns and summarized fields
Creating basic and advanced cross tab Crystal reports -
ChartingFormatting existing graphs
Creating basic, calculating and cross tab related charts
Using the Crystal Reports Chart Expert
Crystal Reports chart types and layout options
Learn with IT Training Solutions. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
Please contact us to book a place or request a quote for your course.
-
Course Options
Please contact us to discuss options for this coursePrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.BespokeBespokeBespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/29/2024 8:03:23 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/29/2024 8:03:23 AM