|
CRY-200
Advanced Crystal
Reports
Course Length:
2 days
Tuition: $800
Overview:
Since you've probably
completed the first course, or are familiar with the basics of building
and modifying reports, you're ready to move ahead to create complex
reports and data sources using Crystal Reports' tools. In this course,
you'll not only learn how to create more sophisticated reports like
subreports and cross-tabs, you'll also learn how to increase the speed
and efficiency of your reports by using SQL queries and dictionaries.
Course Objective:
You will create complex reports and data sources using Crystal Reports’
tools.
Target Student:
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.
Prerequisites:
CRYSR-100:Crystal Reports 10:Level One, and knowledge of programming
and/or SQL would be helpful.
Course Content
Creating Running Totals
Create a
Running Total Field
Modify a
Running Total Field
Create a
Manual Running Total on …Detail Data
Create a
Manual Running Total on …Summary Data
Building Cross-tabs in Your Report
Create a
Cross-tab
Create a
Specified Group Order
Filter a
Cross-tab by Group
Change
the Cross-tab Format
Conditionally Format Rows and …Columns
Keep
Groups Together
Adding Subreports
Insert a
Subreport
Link a
Subreport to Data in a Primary …Report
Edit a
Subreport
Format a
Subreport Using the Format …Editor
Share
Formulas Between main and …Subreports
Create an
On-demand Subreport
Creating Drill-Downs
Create a
Drill-down
Create
Separate Heading for Drill-…down Data
Enhancing Report Processing Using SQL
Create a
Report Using SQL Queries
Summarize
Report Data Using SQL …Aggregate Functions
Create
Joins Using SQL
Create
Subqueries
Create an
SQL Expression Field to …Promote Server-side Processing
|
