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

📰
The Who, What, and Why of Semantic Layers: The Layer That Decides Whether Your Numbers Can Be Trusted
Learn about semantic layers and their role in ensuring trustworthy data, a crucial aspect of data analytics and business intelligence
Dev.to · Alex Merced
📰
Data structures — Hash tables/ Associative Arrays
Learn about hash tables and their implementation in Python for efficient data storage and retrieval
Medium · Python
📰
Why Revisiting Old Databricks Concepts Made Me a Better Learner
Revisiting old concepts can deepen understanding and improve learning, a key insight for data scientists and professionals in related fields
Medium · Data Science
📰
Day 96: Data Catalog Service - AI System Design in Seconds
Learn to design an AI-powered data catalog service in seconds to efficiently manage and discover datasets
Dev.to · Matt Frank
Up next
Turn an Excel Table Into a Live Website
Kenji Explains
Watch →