Crystal Reports 2020 - Level 2 Course



Course Details:

Length: 2 days

Price: $1,270/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included: Yes
(requires trial or license)

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course 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 course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including sub-reports 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 sub-reports, 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 course, you will also learn to use tools that can increase the speed with which data is retrieved. In this course, you will create complex reports using tools in Crystal Reports 2020.

You will:

  • Create automatic and manual running totals.
  • Work with cross-tab reports.
  • Add sub-reports.
  • Create drill-downs in a report.
  • Use SQL statements in report processing.
  • Create complex formulas.
  • Add charts to reports.
  • Enhance report functionality.

Register Early: Registration Deadline is 2 Weeks Prior to Class Start.


Course Notes

Knowledge Prerequisites

Crystal Reports 2020 - Level 1


Course Topics



Course FAQs

What Are the Available Class Formats?

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

What Are Running Totals in Crystal Reports?

Running totals in Crystal Reports allow users to quickly generate summaries and totals for an entire report. This is especially helpful for tracking changes over time or in different groups, such as sales figures by product or month. Running totals are also useful for creating cumulative sums, averages, and other calculations based on a subset of the data. To create Running Totals, users simply select the field for which they want to generate the report, along with any additional criteria needed. Crystal Reports will then calculate and display the relevant values in the appropriate order. This makes it easy to compare how different groups are performing over time or compare trends across different areas of a business.

Running Totals in Crystal Reports are an invaluable tool for businesses needing to quickly analyze complex data sets. By leveraging Running Totals, organizations can gain insights into their operations and make informed decisions that will help them optimize their performance and achieve success.

What Are Cross-Tabs in Crystal Reports?

Cross-tabs in Crystal Reports is a powerful tool for analyzing and summarizing data. It is used to organize data into columns, rows, and sub-rows based on the various criteria defined by the user. The cross-tab can then display the results of this analysis in an easily understandable visual format that can be used to gain valuable insights about the data. Cross-tabs can also be used to compare different sets of data or measure how two or more variables interact and influence each other. This makes it a very helpful tool for making business decisions. With cross-tabs, users can quickly identify trends and patterns in their data without having to manually analyze numerous individual records. As such, cross-tabs are an essential component of any data analysis process.

Crystal Report's cross-tab feature is one such feature that makes it a great choice for analyzing complex datasets. With this feature, users can quickly and easily identify patterns in their data and make informed decisions. Using cross-tabs in Crystal Reports can enable businesses to gain valuable insights into their business operations that they otherwise would not be able to uncover. It is a powerful tool for transforming raw data into meaningful information that can be used to drive better decision-making.

What Are Subreports in Crystal Reports?

Subreports are a powerful tool in Crystal Reports that allow users to include additional data from separate report objects. Subreports can be used to combine multiple datasets into one report or to create complex reports with multiple levels of grouping and summaries. They allow for better organization of the report layout, enabling easier navigation and readability. Subreports can be used to make changes to existing reports without having to recreate them from scratch. The use of subreports also streamlines the report-writing process, making it easier for users to create complex and interlinked reports in a fraction of the time. By using subreports, users can quickly add data from other sources and display it within the same report, creating a comprehensive view of the information. Subreports are an essential feature of Crystal Reports that enable users to create sophisticated and comprehensive reports promptly.

Subreports can also be used to join data from different sources, allowing for deeper analysis of complex relationships between different sets of data. For instance, if you wanted to compare sales numbers from different stores, you could link a subreport to the main report that includes data from multiple stores. This would allow you to swiftly identify trends and relationships between the different stores' sales figures.

Subreports provide users with a great deal of flexibility and control when creating complex reports in Crystal Reports. They enable users to quickly add data from multiple sources, create complex reports with multiple levels of grouping and summaries, and join data from different sources for deeper analysis. With the help of subreports, users can quickly create comprehensive and detailed reports without having to start over from scratch.

What Are Drill-Downs in Crystal Reports?

Drill-downs in Crystal Reports enables users to explore and analyze data in greater detail. With a drill-down, users can view summarized data at first glance and then expand the report to reveal more detailed information. For example, a report may show sales by product category and when the user drills down on one of the categories, they will be able to see sales figures by individual products within that category. Drill-downs can also help users understand trends and compare the information at different levels of detail. A single drill-down report can be used for multiple purposes, allowing the user to customize their view depending on what kind of data they need to access.

With drill-downs, Crystal Reports users can gain deeper insight into their data and optimize decision-making. Drill-downs are easy to set up and manage; they can be used as part of an existing report or a new one created from scratch. Drill-downs also save time since the user does not need to manually generate multiple reports with different parameters for each level of detail. By using drill-downs, users can visually and quickly explore data, identify trends and make informed business decisions.

What Is Using SQL Statements in Crystal Reports Processing?

Using SQL statements in Crystal Reports processing can help you create effective and precise reports. You can use SQL queries to create a report from existing data sources, summarize the report data, create joins between tables using SQL, create subqueries to filter larger datasets, and even create an expression field using an SQL statement. This is all done within the familiar Crystal Reports interface, where you can format the report as desired and add other features such as charts and graphs. By using SQL statements in your Crystal Reports processing, you can ensure that your reports are accurate and up-to-date with the most recent data available. You'll also be able to analyze large datasets more easily by taking advantage of the powerful SQL syntax. With the help of SQL statements for Crystal Reports processing, you can create comprehensive and meaningful reports that provide valuable insights into your data.

What Are Complex Formulas in Crystal Reports?

Complex formulas in Crystal Reports offer users the opportunity to perform advanced calculations and manipulate data from different sources. By using loops, you can run calculations over a range of values. This is especially useful when working with large collections of data. Arrays are used for manipulating and storing multiple pieces of related information in one place. With complex formulas in Crystal Reports, you can quickly and efficiently perform calculations across multiple fields or columns of data. This gives users more control over the information they are working with and helps to avoid manual data entry errors. Complex formulas can also be used in conjunction with other functions such as date range filters or criteria groups to create highly customized reports. By taking advantage of these powerful features, you can save time and create complex reports with ease.

What Are Charts in Crystal Reports?

Charts in Crystal Reports are powerful data visualizations that allow users to quickly and accurately read and interpret the data. Charts provide users with an effective way to compare different values, identify trends, or illustrate relationships between two or more variables. With Crystal Reports, users can create a variety of charts including bar, line, area, pie, doughnut, and scatter charts.

Creating a chart in Crystal Reports requires the selection of data fields to be charted, followed by options for formatting the chart. When creating a chart, users can also choose to drill down on their data for further analysis. To do this, users can click on a point within the chart to display more specific data.

Crystal Reports also enables users to create a Top N chart, which allows them to analyze the data by displaying the highest or lowest values in the dataset. Cross-Tab charts can be created which present cross-tabulated results between two or more variables, allowing users to quickly and easily identify correlations between different sets of data.

Crystal Reports also enables users to create charts for grouped data, which allows them to view different levels of details within a chart. This is especially useful when the user needs to compare different datasets that are related in some way. Formatting options allow users to customize their chart’s appearance by changing colors, fonts, and other visual elements.

To save time and effort, users can also create chart templates in Crystal Reports. A chart template is a saved set of formatting options that can be applied to other charts in the future. This feature allows users to quickly change the look and feel of their charts while maintaining their desired formatting settings.

Charts in Crystal Reports provide the user with powerful data visualizations and analysis tools. With its wide selection of charting options, users can create effective visuals for their datasets and gain insight into their data quickly and easily.

What Is Enhancing Crystal Reports Functionality?

Enhancing Crystal Reports Functionality offers businesses the ability to organize their data based on a hierarchical structure. This provides an efficient way to organize and present data in a meaningful way. Users can create dynamic images such as charts and graphs to represent information visually. These visual aids can help make complex data more understandable for stakeholders. Businesses can create alerts for reports to ensure that important information is shared promptly. They can also utilize Crystal Reports functionality to create geographic maps which can help show patterns and trends with data from different locations. With these features, businesses can make more informed decisions quickly and accurately.







Related Crystal Reports Information:

How Much Do Crystal Reports Training Courses Cost?

Public instructor-led Crystal Reports course prices start at $1,240 per student. Group training discounts are available.

What Crystal Reports Skills Should I Learn?

A: If you are wondering what Crystal Reports skills are important to learn, we've written a Crystal Reports Skills and Learning Guide that maps out Crystal Reports skills that are key to master and which of our courses teaches each skill.

Read Our Crystal Reports Skills and Learning Guide

How long does it take to learn Crystal Reports?

A: Crystal Reports is a popular business intelligence tool, and many people want to know how long it will take to learn it. The answer really depends on your prior experience and how much time you're willing to commit to learning.

If you're starting from scratch, we recommend taking one of our online Crystal Reports classes or book a group onsite training. Our classes are designed to give you a comprehensive understanding of Crystal Reports and how to use it effectively. In general, most people need about 8-16 hours of training to feel confident using Crystal Reports basic features.

Of course, the more time you spend practicing and using Crystal Reports, the better you'll become at it. If you keep up with your learning and stay current on new features, you'll be able to master Crystal Reports in no time.

Is Crystal Report easy to learn?

A: Crystal Reports is a business intelligence application used to design and generate reports from a variety of data sources. Crystal Reports is easy to learn for users who are already familiar with basic database concepts and report design principles. For beginners, Crystal Reports can be challenging to learn due to its complex interface and functionality. However, there are many online resources and Crystal Reports training courses available to help users get started with Crystal Reports. Once you have a basic understanding of how Crystal Reports works, you'll be able to create complex and customized reports with ease.

What is Crystal Report training?

A: Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. Crystal Reports training classes can teach you how to use the software to create custom reports, work with data sources, and troubleshoot any issues that may arise. Crystal Reports training can be beneficial for business professionals who wish to gain skills in report design and generation. Crystal Reports training can also be beneficial for IT professionals who support the software or who need to troubleshoot issues that may arise. Crystal Reports training classes typically cover topics such as report design, working with data sources, and troubleshooting common issues.

What are the top Crystal Reports skills?

A: Crystal Reports is a popular business intelligence tool that helps organizations track and report on data. In order to get the most out of Crystal Reports, it is important to have a solid understanding of the software and how to use it effectively. Here are some of the top skills that you should master in order to become a power user of Crystal Reports:

Top Crystal Reports Skills

1. Learning the basics - Before you can start using Crystal Reports to its full potential, you need to have a firm grasp of the basics. This includes understanding how to create reports, format them, and add different data sources. If you are new to the software, it is important to take some time to learn these basic concepts before moving on to more advanced skills.

2. Adding conditional formatting - One of the most powerful features of Crystal Reports is the ability to add conditional formatting. This allows you to format data based on certain conditions, such as highlighting negative values in red or positive values in green. Conditional formatting can be a great way to make your reports more user-friendly and easier to interpret.

3. Creating custom formulas - Another powerful feature of Crystal Reports is the ability to create custom formulas. This allows you to perform calculations on your data, such as finding the average value of a certain field or determining the percentage of total sales that are made online. Custom formulas can be a great way to get more out of your data and make your reports more informative.

4. Adding charts and graphs - Crystal Reports also allows you to add charts and graphs to your reports. This can be a great way to visualize your data and make it easier to understand. Charts and graphs can also help you spot trends and patterns that you may not have otherwise noticed.

5. Exporting to different formats - Crystal Reports can also be exported to different formats, such as PDFs, Excel files, and PowerPoint presentations. This allows you to share your reports with others who may not have access to the software. Exporting your reports can also be a great way to archive them for future reference.

Mastering these skills will allow you to get the most out of Crystal Reports and turn your data into powerful business intelligence. With a little practice, you can become a Crystal Reports power user in no time!

Where Can I Learn More About Crystal Reports?

Crystal Reports Blogs

Crystal Reports User Groups

Crystal Reports Online Forums

Explore Crystal Reports Training Classes Near Me:

Certstaffix Training provides Crystal Reports classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Crystal Reports concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Crystal Reports skills. Start learning today and see how Certstaffix Training can help you reach your goals.

 







Registration:

Have a Group?
Request Private Training

5/8/2024 10:00:00 AM
Online Class

Registration Deadline - 04/23/2024

 

6/24/2024 10:00:00 AM
Online Class

Registration Deadline - 06/09/2024

 

8/8/2024 10:00:00 AM
Online Class

Registration Deadline - 07/23/2024

 

9/19/2024 10:00:00 AM
Online Class

Registration Deadline - 09/03/2024

 

11/7/2024 10:00:00 AM
Online Class

Registration Deadline - 10/22/2024

 

12/18/2024 10:00:00 AM
Online Class

Registration Deadline - 12/03/2024

Start your training today!