SAP Crystal Reports 2020: Part 1
Organizations use reporting tools to access data sources and generate customized reports. SAP® Crystal Reports® 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease, presenting complex information in an understandable way.
In this course, you will connect to a database to extract data and present it as a report.
You will:
- Identify the elements of the Crystal Reports interface.
- Create and modify a basic report.
- Use formulas to calculate and filter data.
- Build a parameterized report.
- Group report data.
- Enhance a report.
- Create a report using data from an Excel workbook.
- Distribute data.
- Microsoft® Windows® 10
- Default installation of SAP® Crystal Reports® 2020
- Default installation of Microsoft® Office 2019 or Microsoft® 365
- Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- 1 gigahertz (GHz) 64-bit (x64) processor.
- 4 gigabytes (GB) of Random Access Memory (RAM).
- 32 GB available storage space.
- Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
- Bootable DVD-ROM or USB drive.
- Keyboard and mouse or a compatible pointing device.
- Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
- IP addresses that do not conflict with other portions of your network.
- Internet access (contact your local network administrator).
- (Instructor computer only) A display system to project the instructor's computer screen.
Lesson 1: Exploring the
Crystal Reports Interface
Topic A: Explore
Crystal Reports
Topic B: Use Crystal
Reports Help
Topic C: Customize
Report Settings
Lesson 2: Working with
Reports
Topic A: Create a
Report
Topic B: Modify a
Report
Topic C: Display
Specific Report Data
Topic D: Work with
Report Sections
Lesson 3: Using Formulas
in Reports
Topic A: Create a
Formula
Topic B: Edit a
Formula
Topic C: Filter Data
by Using a Formula
Topic D: Work with
Advanced Formulas and Functions
Topic E: Handle Null
Values
Lesson 4: Building
Parameterized Reports
Topic A: Create a
Parameter Field
Topic B: Use a Range
Parameter in a Report
Topic C: Create a
Prompt
Lesson 5: Grouping Report
Data
Topic A: Group Report
Data
Topic B: Modify a
Group Report
Topic C: Group by
Using Parameters
Topic D: Create a
Parameterized Top N Report
Lesson 6: Enhancing a
Report
Topic A: Format a
Report
Topic B: Insert
Objects in a Report
Topic C: Suppress
Report Sections
Topic D: Use Report
Templates
Lesson 7: Creating a
Report from Excel Data
Topic A: Create a
Report Based on Excel Data
Topic B: Modify a
Report Generated from Excel Data
Topic C: Update Data
in a Report Based on Excel Data
Lesson 8: Distributing
Data
Topic A: Export Data
Topic B: Create
Mailing Labels
Appendix A: Setting Up and
Configuring Data Sources
Appendix B: Using Report
Processing Techniques
Appendix C: Using Functions in Formulas