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.
Crystal Reports: SQL Statements and Complex Formulas
Crystal Reports: SQL Statements and Complex Formulas
This course is part of SAP Crystal Reports 2020 Mastery Specialization
Instructor: Bill Rosenthal
Access provided by VodafoneZiggo
Gain insight into a topic and learn the fundamentals.
4 hours to complete
Flexible schedule
Learn at your own pace
What you'll learn
In this course, you will use SQL statements in report processing and create complex formulas.
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
1 assignment
Taught in English
Recently updated!
January 2026
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the SAP Crystal Reports 2020 Mastery Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 3 modules in this course
You created drill-downs in a report to access detailed data on request. As you work with larger and more complex reports, the tools provided by SAPĀ® Crystal ReportsĀ® may not be sufficient to meet all of your data needs.
What's included
1 reading8 plugins
You have created reports and worked with simple formulas. Now you want to perform complex calculations on report data.
What's included
5 plugins
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
What's included
1 reading1 assignment
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
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."
Explore more from Data Science
Logical Operations
Logical Operations
Logical Operations
Logical Operations