Overview

Until now, you have used SAP® Crystal Reports® to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this Specialization, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries. Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this Specialization, you will also learn to use tools that can increase the speed with which data is retrieved.

Syllabus

Course 1: Crystal Reports: Running Totals and Cross-Tabs
Course 2: Crystal Reports: Subreports and Drill-Downs
Course 3: Crystal Reports: SQL Statements and Complex Formulas
Course 4: Crystal Reports: Charts and Functionality Enhancements

Courses

0 reviews
4 hours 40 minutes
View details

To round out your data-reporting skills in Crystal Reports, you'll add multiple different types of charts to reports and format those charts for optimal viewing. You'll also enhance the functionality of reports by creating dynamic images, alerts, and geographical maps. This is the fourth and final course in a multi-course Specialization. All of the courses in this Specialization require that you have SAP Crystal Reports 2020 installed. You also need to have an installation of Office 2019 apps or later, particularly Access. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
0 reviews
6 hours 24 minutes
View details

This course will be useful to anyone who knows how to create basic reports in Crystal Reports, but who wants to build more complex reports to maximize the insights that can be gleaned from data. You'll start by creating running totals that help to summarize data. Then you'll create and format cross-tab reports, which will help you organize and analyze complex report data more easily. This is the first course in a multi-course Specialization. All of the courses in this Specialization require that you have SAP Crystal Reports 2020 installed. You also need to have an installation of Office 2019 apps or later, particularly Access. The course setup instructions provided in the first module of this course go into more detail about the hardware and software requirements.
0 reviews
4 hours 3 minutes
View details

In this course, you'll continue developing your data-reporting skills in Crystal Reports by using Structured Query Language (SQL) statements to create and summarize report data, as well as create joins and subqueries. You'll also create more complex formulas by working with loops and arrays. These tools and techniques provide you with even greater control over how your data is presented. This is the third course in a multi-course Specialization. All of the courses in this Specialization require that you have SAP Crystal Reports 2020 installed. You also need to have an installation of Office 2019 apps or later, particularly Access. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
0 reviews
4 hours 10 minutes
View details

In this course, you'll continue developing your data-reporting skills in Crystal Reports by inserting, editing, and sharing subreports. You'll also create drill-downs in reports to make larger reports easier to interpret at a glance. This is the second course in a multi-course Specialization. All of the courses in this Specialization require that you have SAP Crystal Reports 2020 installed. You also need to have an installation of Office 2019 apps or later, particularly Access. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.