This course looks at creating running totals, adding subreports, cross-tabs, creating charts, report speed, dictionaries, and reporting Excel data. Knowledge of programming and/or SQL would be helpful.
- Course Outline
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.
This course is classroom style instruction: Instructor-led, hands-on training.
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 Cross-tab by Group
Change the Cross-tab Format
Format Rows and Columns
Keep Groups Together
Insert a Subreport
Link a Subreport to Data in a Primary Report
Edit a Subreport
Format a Subreport Object
Share Formulas Between Main and Subreports
Create an On-demand Subreport
Improving Report Processing Speed
Create a SQL Expression
Select Records on the Server
Write a SQL Query
Edit a SQL Query
Build a Report on a SQL Query
Create SQL Commands in Crystal Environment
Create a Dictionary
Organize the View of Data in a Dictionary
Adding Graphics to the Dictionary
Build a Report Based on a Dictionary
Create a Chart
Modify a Chart
Create a Top N Chart
Format a Chart
Create a Chart Template
Reporting on Excel Data
Create a Report
Modify a Report
Update the Report
- Prerequisites & Certificates
Course Prerequisite: Required: Solid understanding of Crystal Reports Introduction topics.
Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion
- Cancellation Policy
- Map & Reviews
[ View Provider's Profile ]
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 456 times.