Processing your application. Please be patient while we make sure we receive every piece of it.
Crystal Reports XI
Crystal Reports XI Level 1
2 Days
Guaranteed To Run
Tuesday
Mar 28
Toronto
  $995
Wednesday
Mar 29
Toronto
  $995
Wednesday
Apr 26
Toronto
  $995
Thursday
Apr 27
Toronto
  $995
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
Crystal Reports XI: Level 1 is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database.
You will build basic list and group reports that work with almost any database.
This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. Students may or may not have programming and/or SQL experience.
Before taking this course, students should be familiar with the basic functions of Windows, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, students should have taken Microsoft® Office Access 2003 Level 1 or have equivalent experience with basic database concepts.
Lesson 1: Creating a Report
Set Default Report Settings
Specify Fields for a New Report
Preview a Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Other Tables


Lesson 2: Displaying Specific Report Data
Find Data
Sort Data
Filter Data by a Single Criterion


Lesson 3: Grouping Report Data
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add a Second-Level Grouping
Filter Records by Group
Create a Top N Sort Group


Lesson 4: Building Formulas
Create a Formula
Edit a Formula
Combine Fields by Formula
Delete a Formula
Filter Data by Multiple Criteria
Modify a Filter Using an OR Operator
Create a Parameter Field
Account for Null Fields in a Formula


Lesson 5: Formatting Reports
Remove White Space
Insert Page Header/Footer Data
Add Borders, Boxes, and Lines
Change Field Background Color
Change the Margins


Lesson 6: Enhancing Reports
Add a Watermark
Insert Objects Using Object Linking and Embedding
Modify Formatting Based on Data Value
Suppress Report Sections
Insert Hyperlinks
Hide Blank Report Sections


Lesson 7: Creating Pie Charts
Create a Pie Chart with a Drill-Down
Modify Chart Text
Format a Chart
Present a Chart by Group


Lesson 8: Distributing Data
Export to a PDF File
Export to a Microsoft Excel File
Export to an Access Database File
Export a Report Definition
Create Mailing Labels
SITE MAP