Course not currently available
Reports XI Advanced
Course
In London ()
Description
-
Type
Course
-
Duration
2 Days
This highly intensive two-day training course has been designed to teach existing users of Crystal Reports X1 how to use more advanced techniques and features to create complex reports and data sources.
About this course
This course is intended 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. Delegates should be familiar with the content covered in the Crystal Reports XI Introduction course. A knowledge of programming and/or SQL would also be helpful.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- Microsoft .Net
- Visual Studio
- Crystal Reports
- SQL
- Programming
- MS Excel
- Running Total Field
- Cross-tab
- Subreport
Course programme
Topics covered:
- 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
Topics covered:
- 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
Topics covered:
- 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
Topics covered:
- Create a Drill-down
- Create Separate Headings for Drill-down Data
Topics covered:
- Create a Report Using SQL Queries
- Summarize Report Data Using SQL Aggregate Functions
- Create Joins Using SQL
- Create Subqueries
- Create a SQL Expression Field
Topics covered:
- Create a Bar Chart
- Modify a Chart
- Format a Chart
- Create a Chart Template
- Create a Top N Chart
- Create a Cross-tab Chart
Topics covered:
- Create a Report Based on Excel Data
- Modify a Report Generated from Excel Data
- Update Data in a Report Based on Excel Data
Topics covered:
- Create a Static Prompt
- Create a Dynamic Prompt
Topics covered:
- Group Data Hierarchically
- Create a Dynamic Image
- Create a Report Alert
- Create a Geographic Map
Reports XI Advanced