Crystal Reports 2016 - Part 2
- 2 Days Course
- Language: English
Introduction:
In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.
Objectives:
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.
Course Outline:
1 – CREATING RUNNING TOTALS
- Topic A: Create a Running Total Field
- Topic B: Modify a Running Total Field
- Topic C: Create a Manual Running Total
2 – WORKING WITH CROSS-TABS
- Topic A: Create a Cross-Tab Report
- Topic B: Format a Cross-Tab Report
- Topic C: Create Groups in Cross-Tab Reports
3 – ADDING SUBREPORTS
- Topic A: Insert a Subreport
- Topic B: Edit a Subreport
- Topic C: Share Variables
4 – CREATING DRILL-DOWNS IN A REPORT
- Topic A: Create a Drill-Down
- Topic B: Create Headings for Drill-Down Data
5 – USING SQL STATEMENTS IN REPORT PROCESSING
- 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
6 – CREATING COMPLEX FORMULAS
- Topic A: Work with Loops
- Topic B: Work with Arrays
7 – ADDING CHARTS TO REPORTS
- 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
8 – ENHANCING REPORT FUNCTIONALITY
- 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
9 – APPENDIX
- Appendix A: Managing Reports
- Appendix B: Processing Data on the Server
- Appendix C: Detecting and Fixing Problems
Enroll in this course
£990.00