Crystal Reports 1

Download PDF

Next Dates:

Thu, 09. Feb. 2012
Fri, 10. Feb. 2012
Thu, 22. Mar. 2012
Fri, 23. Mar. 2012
Wed, 09. May. 2012
Thu, 10. May. 2012

Length:

2 days

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 750

Target audience & Prerequisites:

This course requires a basic understanding of databases and their underlying purpose

Learning objectives:

In this course, students will build basic list and group reports that work with almost any database.

Course Outline:

Creating a List Report

Set Default Report Settings
Build the Report
Preview the Report
Add a Report Title
Align Fields

Displaying Data in a Report

Find Data
Sort Data
Filter Data by Single Criteria

Grouping Report Data

Insert a Group
Add Summaries
Change Group Options
Add an Additional Group
Format a Group Header
Filter by Group
Create a Top N Sort Group

Building Formulas

Write a Formula
Edit a Formula
Group by Formula
Delete a Formula
Build a Filter by Multiple Criteria
Modify a Filter with Multiple Criteria to Create an OR Condition
Create a Parameter Field
Write a Formula that Incorporates Null Fields

Formatting Reports

Remove White Space
Insert Page Header/Footer Data
Add Borders and Lines
Change the Background Color
Change the Margins

Enhancing Reports

Create a Watermark
Add Bulleted Lists
Modify Format Based on Data Value
Conditiona lly Suppress Data
Insert Hyperlinks
Hide Report Objects

Creating and Modifying Pie Charts

Create a Pie Chart with a Drill-down
Change the Chart Title
Format a Chart
Present a Chart by Group

Distributing Data

Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List