|
Provided by: Acend Corporate Learning Crystal Reports 10 Level 1Business and Management Skills |
 |
Training
Provided by Acend Corporate Learning
(Nonconsecutive days) In this course, students will build basic list and group reports that work with almost any database.
Who Should Attend:
This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports. They may or may not have programming and/ or SQL experience.
|
|
||||||||||
Crystal Reports 10 Level 1
Lesson 1: Creating a Report
Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Additional Tables
Lesson 2: Displaying Specific Report Data
Find Data
Sort Data
Filter Data by Single Criteria
Lesson 3: Grouping Report Data
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group
Lesson 4: 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
Lesson 5: Formatting Reports
Remove White Space
Insert Page Header/ Footer Data
Add Borders and Lines
Change the Background Color
Change the Margins
Lesson 6: Enhancing Reports
Create a Section to Contain a Watermark
Insert Objects Using Object Linking and Embedding
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Blank Report Sections
Lesson 7: Creating and Modifying 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 PDF
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels
Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Additional Tables
Lesson 2: Displaying Specific Report Data
Find Data
Sort Data
Filter Data by Single Criteria
Lesson 3: Grouping Report Data
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group
Lesson 4: 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
Lesson 5: Formatting Reports
Remove White Space
Insert Page Header/ Footer Data
Add Borders and Lines
Change the Background Color
Change the Margins
Lesson 6: Enhancing Reports
Create a Section to Contain a Watermark
Insert Objects Using Object Linking and Embedding
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Blank Report Sections
Lesson 7: Creating and Modifying 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 PDF
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels
About The Training Provider: Acend Corporate Learning
Acend Corporate Learning - As a class leader in IT training we have become a single source of contact for training and development for many organizations in Canada. Our customized e-learning and enterprise solutions allow corporate training managers the ability to easily administer their learning programs and track the progress of all participating employees.
Maximizing the investment in training is important for all...
