Course
Crystal Reports Level 1
Course Duration
2 Days
During this Crystal Reports course, delegates will learn the basics of report creation, from linking the report to the requisite data source, to distributing the report to others. Delegates will also learn about sorting, grouping, linking, basic formula creation and working with Crystal Report experts.
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.
Prerequisites
-
- To ensure your success on this Crystal Reports introduction course, we recommend that you attend a Windows course or have equivalent knowledge.
Objectives
-
- Plan the needs for your Crystal Report including data as well as appearance.
- Become familiar with components of the Crystal Reports application window.
- Create reports based directly on database information, use a report expert or create a copy of an existing report.
- Add, modify and remove Crystal Reports objects such as data fields, text objects, file information, graphics or decorative lines and boxes.
- Format the appearance of your Crystal Report using font, colour, border and number choices.
- Change the selection criteria and sort order of your data in Crystal Reports.
- Create subtotals, grand totals and summaries for your report data.
- Create, edit and delete formulas. Understand the formula language in Crystal Reports.
- Understand Crystal Reports linking concepts then create and modify your own links.
- Identify and control the sections in Crystal Reports.
- Distribute your Crystal Reports to those who need the information through a variety of methods.
What's included
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
Course Content
-
Overview of Crystal ReportsModifying the default settings and using help in Crystal Reports
Reviewing reports and databases to be used in class
The steps necessary to create reports
Examining the capabilities of Crystal Reports -
Creating Simple Crystal ReportsSaving and refreshing your report
Adding drawings and images / company logos etc to your Crystal reports.
Adding special fields such as page numbers and other document information to your Crystal Report
Using the format editor to enhance a Crystal report
Formatting a report by changing the size and position of the fields
Viewing a Crystal report as it will print
Creating a new Crystal report
Identifying the sections of a report -
Sorting and Selecting Records in Crystal ReportsModifying composite formulas and the selection criteria statement in Crystal Reports
Adding an additional selection criterion using the "And" / "Or" statement
Using the Select Expert to limit Crystal Reports records using single or multiple criteria
Sorting Crystal Reports records using single or multiple criteria -
Grouping and Summarizing in Crystal ReportsUsing Top N/Sort Group Expert in your Crystal Reports
Inserting grand total summary fields
Inserting percent of the total fields
Inserting summary fields
Inserting subtotals and grand totals
Modifying grouping options
Defining a Crystal Reports multiple level group
Defining a Crystal Reports single level group -
Crystal Reports Parameter FieldsCreating pick lists for use with parameter fields
Creating Crystal Reports parameter fields - to select records
Creating Crystal Reports parameter fields - free text entry
Creating and utilising Crystal Reports parameter fields -
Using the Report ExpertEditing a Crystal report created using an expert
Creating new Crystal reports using the cross tab expert
Creating new Crystal reports using the standard report expert -
LinkingCreating, examining and modifying links using the visual linking expert
Using multiple tables in a single Crystal report correctly
Understanding relational database basic concepts -
Creating FormulasCreating and using If-Then-Else formulas and functions
Creating and using arrays in formulas and functions
Creating and using date formulas and functions
Creating and using numeric formulas and functions
Creating and using string formulas and functions
Making changes to formulas
Creating new formulas using the Crystal Reports formula editor
Understanding formula components -
Formatting Crystal Reports SectionsCreating summary and drill down Crystal reports
Using the Crystal Reports section expert
Resizing Crystal Reports sections in design view
Reviewing Crystal Reports sections -
Distributing / Exporting Crystal Reports DataWeb browser options to view Crystal reports on-line
Creating a Crystal report using spreadsheet data
Exporting a Crystal report into office suite applications
Identifying exporting options
Are there any aspects of the course which you feel require improvement
"No, excellent pace and plenty of hands on experience"
J.H. Breedon Northern Ltd, Crystal Reports Level 1
Which part of the course did you find particularly valuable
"Learning how to use the formula to manipulate data "
P.C. NHS Fleet Solutions, Crystal Reports Level 1
Which part of the course did you find particularly valuable
"The overview of crystal and the functionality of formulas "
G.P. NHS Fleet Solutions, Crystal Reports Level 1
Following this training what are you going to do differently
"Start using the Crystal platform to write tasks for the team which will be more bespoke than previous "
G.P. NHS Fleet Solutions, Crystal Reports Level 1
Other Courses In This Series
Windows Server 2022 Networking This five-day course will provide you with the knowledge and skills required to configure the networking features in Windows Server 2022, to automate and consolidate networking processes and resources, easily connect private clouds with public cloud services, and connect users to IT resources and se
Crystal Reports Level 2 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.
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.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2024 4:37:23 PM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2024 4:37:23 PM