In this course, students will build basic list and group reports that work with almost any database. This course requires a basic understanding of databases and their underlying purpose
- Course Start Date: Jun. 6
- Location: Ottawa
- Time: 9:00 am - 4:00 pm (Note on end times)
- Duration: 2 Days
on the number or students and pace of the class.
It is important to allow for the class to run a little bit longer,
or finish a little sooner, than expected.
- Delivery Method(s):Instructor Led
- Seats Available: YES
- Category:Crystal Reports Training Courses
that provides you with the quality training that
you have come to expect, and combines it with
flexible learning and a self paced environment.
For more information click here.
- Course Outline
Course Length: 12hrs (2 Days)
Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports helps you build advanced reports with ease, presenting complex information in an understandable way.
In this course, you will connect to a database to extract data and present it as a report. You will:
- Identify the elements of the Crystal Reports interface
- Create and modify a basic report
- Use formulas to calculate and filter data
- Build a parameterized report
- Group report data
- Enhance a report
- Create a report using data from an Excel workbook
- Distribute data
This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.
Section 1: Exploring the Crystal Reports Interface
Explore Crystal Reports
Use Crystal Reports Help
Customize Report Settings
Section 2: Working with Reports
Create a Report
Modify a Report
Display Specific Report Data
Work with Report Sections
Section: 3: Using Formulas in Reports
Create a Formula
Edit a Formula
Filter Data by Using a Formula
Work with Advanced Formulas and Functions
Handle Null Values
Section 4: Building Parameterized Reports
Create a Parameter Field
Use a Range Parameter in a Report
Create a Prompt
Section 5: Grouping Report Data
Group Report Data
Modify a Group Report
Group by Using Parameters
Create a Parameterized Top N Report
Section 6: Enhancing a Report
Format a Report
Insert Objects in a Report
Suppress Report Sections
Use Report Templates
Section 7: Creating a Report from Excel Data
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Section 8: Distributing Data
Create Mailing Labels
- Prerequisites & Certificates
This course requires a basic understanding of databases and their underlying purpose
Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support
- Cancellation Policy
Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.
- Map & Reviews
[ View Provider's Profile ]
Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 25 times.