Crystal Reports XI - Level 2
Course Description
Now that you have 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 including subreports and cross-tabs, but you`ll also learn how to increase the speed and efficiency of your reports by using SQL queries.
2 days
Contact us for pricing
Prerequisites
Crystal Reports XI: Level 1, and knowledge of programming and/or SQL would be helpfulCreating Running Totals
Create a Running Total FieldModify 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-tabCreate 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 SubreportLink 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
Creating Drill-downs
Create a Drill-downCreate Separate Headings for Drill-down Data
Enhancing Report Processing by Writing SQL Statements
Create a Report Using SQL QueriesSummarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field
Charting Data
Create a Bar ChartModify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart
Reporting on Excel Data with Crystal Reports
Create a Report Based on Excel DataModify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Working with Prompts
Create a Static PromptCreate a Dynamic Prompt
Enhancing Report Functionality
Group Data HierarchicallyCreate a Dynamic Image
Create a Report Alert
Create a Geographic Map
CrystalCrystal ReportsCrystal Reports X1SAP Crystal Reports