Crystal Reports: SQL Statements and Complex Formulas

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Crystal Reports: SQL Statements and Complex Formulas

Coursera · Intermediate ·📊 Data Analytics & Business Intelligence ·3mo ago

Key Takeaways

Uses Crystal Reports to create SQL statements, joins, subqueries, and complex formulas with loops and arrays

Original Description

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.
Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
Half of Data Engineering Jobs on LinkedIn Aren't Real
Understand the discrepancy between reported data engineering job growth and actual job availability on LinkedIn
Dev.to · DataDriven
📰
Evolutionary Data Through Schemaboi: Achieving Forward, Backwards, and Sideways Compatibility
Learn how Schemaboi achieves forward, backwards, and sideways compatibility for evolutionary data through self-contained schemas in file headers
InfoQ AI/ML
📰
How Morphohack Helped Me Recover €678,000 in Lost Crypto Assets
Learn how Morphohack helped recover €678,000 in lost crypto assets using data science techniques
Medium · Data Science
📰
10 awk and sed Techniques Every Data Analyst Should Know for Data Cleaning and Transformation
Learn 10 essential awk and sed techniques for efficient data cleaning and transformation as a data analyst
Medium · Data Science
Up next
6-Phase SQL Roadmap 2026 | Data Analytics & Engineering | #shorts
SCALER
Watch →