Logical Operations

SAP Crystal Reports 2020 Mastery Specialization

Ends soon! This point in the year is perfect for 40% off 10,000+ programs. Save now.

Logical Operations

SAP Crystal Reports 2020 Mastery Specialization

Master Reporting Using Crystal Reports.

Create complex data reports to turn raw data into meaningful information in Crystal Reports.

Bill Rosenthal

Instructor: Bill Rosenthal

Included with Coursera Plus

Get in-depth knowledge of a subject
Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • In this Specialization, you will create complex reports using tools in Crystal Reports 2020.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

January 2026

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Logical Operations

Specialization - 4 course series

Crystal Reports: Running Totals and Cross-Tabs

Crystal Reports: Running Totals and Cross-Tabs

Course 1, 6 hours

What you'll learn

  • Apply professional styling to reports using conditional formatting, custom margins, special fields, and the Highlighting Expert.

  • Embed hyperlinked objects, leverage section underlaying, and configure conditional rules to suppress blank report sections.

  • Build and refresh Crystal Reports connected directly to Microsoft Excel data sources, and export final outputs to PDF or mailing labels.

  • Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Category: Data Analysis Software
Category: Data Analysis
Category: Microsoft Access
Category: Report Writing
Category: Business Intelligence Software
Category: Business Intelligence
Category: Business Reporting
Category: Data Presentation
Crystal Reports: Subreports and Drill-Downs

Crystal Reports: Subreports and Drill-Downs

Course 2, 4 hours

What you'll learn

  • Embed standalone and on-demand subreports into primary reports to display distinct, correlated datasets side by side.

  • Share calculations and global variables across primary reports and subreports using shared formula configurations.

  • Create interactive data drill-downs with dynamic headings powered by the DrillDownGroupLevel function.

  • Data files for this course are provided in the first course of this specialization, "Crystal Reports: Running Totals and Cross-Tabs".

Skills you'll gain

Category: Editing
Category: Report Writing
Category: Business Intelligence Software
Category: Data Analysis Software
Category: Data Sharing
Category: Business Intelligence
Category: Verification And Validation
Category: Business Reporting
Category: Data Presentation
Category: Data Analysis
Category: Consolidation
Category: Data Integration
Category: Microsoft Access
Crystal Reports: SQL Statements and Complex Formulas

Crystal Reports: SQL Statements and Complex Formulas

Course 3, 4 hours

What you'll learn

  • Create custom database reports by writing optimized SQL queries, utilizing key clauses, and implementing server-side processing.

  • Construct complex SQL expressions, table joins, and nested subqueries while summarizing data with aggregate functions.

  • Develop advanced report logic using programming structures within formulas, specifically loops and array data types.

  • Data files for this course are provided in the first course of this specialization, "Crystal Reports: Running Totals and Cross-Tabs".

Skills you'll gain

Category: SQL
Category: Business Reporting
Category: Business Intelligence Software
Category: Data Analysis Software
Category: Query Languages
Category: Relational Databases
Category: Microsoft Access
Category: Data Manipulation
Category: Data Presentation
Category: Business Intelligence
Category: Data Analysis

What you'll learn

  • Create custom database reports by writing optimized SQL queries, utilizing key clauses, and implementing server-side processing.

  • Construct complex SQL expressions, table joins, and nested subqueries while summarizing data with aggregate functions.

  • Develop advanced report logic using programming structures within formulas, specifically loops and array data types.

  • Data files for this course are provided in the first course of this specialization, "Crystal Reports: Running Totals and Cross-Tabs".

Skills you'll gain

Category: Business Intelligence
Category: Business Intelligence Software
Category: Microsoft Access
Category: Geospatial Information and Technology
Category: Business Reporting
Category: Graphing
Category: Data Presentation
Category: Data Visualization
Category: Data Visualization Software
Category: Data Analysis Software
Category: Plot (Graphics)
Category: Pivot Tables And Charts
Category: Geospatial Mapping
Category: Data Analysis

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Bill Rosenthal
Logical Operations
158 Courses39,314 learners

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions