Overview
Experience the full potential of Crystal Reports by diving into its advanced functionalities to generate reports suited to your specific needs. This online course will guide you through creating intricate reports and data sources utilizing Crystal Reports' formidable tools.
You will be equipped to craft sophisticated reports featuring subreports, cross-tabs, and enhanced speed and efficiency using SQL queries. Enhance your data handling capabilities, even when working with unfamiliar or large databases. By mastering the art of creating subreports, cross-tabs, and running totals, you will be able to transform raw data into customized reports that streamline your business operations.
Specifically designed for those experienced in basic report creation, this course focuses on advancing your skills to include subreports, cross-tabs, advanced formulas, and multi-series charts. Whether or not you have prior SQL or programming experience, you'll gain the tools to simplify report generation for others.
Version Note: The course utilizes Crystal Reports 2016. Users familiar with the 2013 and 2011 versions will easily adapt, learning minor user interface changes from instructors skilled in all versions.
Course 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
Target Student: This course suits individuals needing to elevate their report creation with advanced features. Previous programming and/or SQL experience assists but is not required.
Prerequisites: A foundational understanding of programming or SQL is beneficial. Consider completing Crystal Reports® 2016: Part 1 prior to this course.
Course Content:
- Lesson 1: Creating Running Totals
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total
- Lesson 2: Working with Cross-Tabs
- Create a Cross-Tab Report
- Format a Cross-Tab Report
- Create Groups in Cross-Tab Reports
- Lesson 3: Adding Subreports
- Insert a Subreport
- Edit a Subreport
- Share Variables
- Lesson 4: Creating Drill-Downs in a Report
- Create a Drill-Down
- Create Headings for Drill-Down Data
- Lesson 5: Using SQL Statements in Report Processing
- Create a Report Using SQL Queries
- Summarize Report Data
- Create Joins Using SQL
- Create Subqueries
- Create an SQL Expression Field
- Lesson 6: Creating Complex Formulas
- Work with Loops
- Work with Arrays
- Lesson 7: Adding Charts to Reports
