Data, Analytics & BI
Crystal Reports 2016 - Part 2
Build sophisticated business reports in Crystal Reports.
2 daysIntermediate9 modules
About this course
Build sophisticated business reports in Crystal Reports. You will create running totals and cross-tabs, add subreports and drill-downs, use SQL in report processing, write complex formulas and add charts.
What you'll learn
- Create automatic and manual running totals.
- Work with cross-tab reports.
- Add subreports.
- Create drill-downs in a report.
- Use SQL statements in report processing.
- Create complex formulas.
- Add charts to reports.
- Enhance report functionality.
Curriculum
9 modules
- Topic A: Create a Running Total Field
- Topic B: Modify a Running Total Field
- Topic C: Create a Manual Running Total
- Topic A: Create a Cross-Tab Report
- Topic B: Format a Cross-Tab Report
- Topic C: Create Groups in Cross-Tab Reports
- Topic A: Insert a Subreport
- Topic B: Edit a Subreport
- Topic C: Share Variables
- Topic A: Create a Drill-Down
- Topic B: Create Headings for Drill-Down Data
- Topic A: Create a Report Using SQL Queries
- Topic B: Summarize Report Data
- Topic C: Create Joins Using SQL
- Topic D: Create Subqueries
- Topic E: Create an SQL Expression Field
- Topic A: Work with Loops
- Topic B: Work with Arrays
- Topic A: Create Charts
- Topic B: Create a Chart with Drill-Down
- Topic C: Create a Top N Chart
- Topic D: Create a Cross-Tab Chart
- Topic E: Create Charts for Grouped Data
- Topic F: Format a Chart
- Topic G: Create a Chart Template
- Topic A: Organize Data Based on a Hierarchy
- Topic B: Create a Dynamic Image
- Topic C: Create a Report Alert
- Topic D: Create a Geographic Map
- Appendix A: Managing Reports
- Appendix B: Processing Data on the Server
- Appendix C: Detecting and Fixing Problems
Who it's for
Report writers who know Crystal Reports basics.
Before you start
- Crystal Reports 2016 - Part 1 or equivalent experience
Related courses
More in Data, Analytics & BI →Foundation
Crystal Reports 2016: Part 1
Data, Analytics & BI
View course →Intermediate
Data Literacy
Data, Analytics & BI
View course →Foundationv11.2
IBM Cognos Analytics: Author Reports Fundamentals (v11.2)
Data, Analytics & BI
View course →Foundation
Platform Analytics (PA) Fundamentals
Data, Analytics & BI
View course →Intermediate
Tableau - Connect to Data & Work with Fields
Data, Analytics & BI
View course →Intermediate
Tableau - Create Data Sources with Relationships & Joins
Data, Analytics & BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.