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 ·4mo 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.
AI explanation not available for this lesson yet
This lesson is still being prepared for the AI tutor. In the meantime, explore lessons that are ready.
Browse explainer-ready lessons →

Related Reads

📰
Building a Real-Time Market Microstructure Analyzer for Indian Equities
Learn to build a real-time market microstructure analyzer for Indian equities using data analytics and programming skills
Dev.to · Aarya Parekh
📰
Power BI’s ADBC Migration Has Started.
Power BI's ADBC migration is underway, focusing on driver updates rather than new features, to enhance performance and compatibility
Medium · Data Science
📰
How Small Businesses Can Build a Data-to-Decision System That Actually Gets Used
Learn how small businesses can create a data-to-decision system that drives actionable insights and informed decisions
Dev.to · Olajumoke Akinremi
📰
You May Only Get One Swing: Building an Offense That Attacks Together
Build a cohesive offense strategy by analyzing the pitcher's plan and attacking together
Medium · Data Science
Up next
A Super El Nino Is Forming...
Ryan Hall, Y'all
Watch →