|
Course ID: 5365
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
Crystal Reports XI - Level 2 Training Class
Course ID: 5365
|
|
| |
|
|
| |
|
|
| |
Crystal Reports XI - Level 2 Training Seminar
In this course, students learn how to create more sophisticated reports including subreports and cross-tabs, and how to increase the speed and efficiency of your reports by using SQL queries.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: 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
Lesson 2: 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
Lesson 3: Adding Subreports Insert a Subreport
Link a Subreport to a Primary Report
Edit a Subreport's Structure
Format a Subreport Using the Format Editor
Share Variables Between Subreports and Primary Reports
Create an On-demand Subreport
Lesson 4: Creating Drill-downs Create a Drill-down
Create Separate Headings for Drill-down Data
Lesson 5: Enhancing Report Processing by Writing SQL Statements Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field
Lesson 6: Charting Data Create a Bar Chart
Modify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart
Lesson 7: Reporting on Excel Data with Crystal Reports Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Lesson 8: Working with Prompts Create a Static Prompt
Create a Dynamic Prompt
Lesson 9: Enhancing Report Functionality Group Data Hierarchically
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Crystal Reports XI - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Crystal Reports XI - Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5365
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|