Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

Crystal Reports: SQL Statements and Complex Formulas

via Coursera

Go to class Write review

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.

Syllabus

  • Using SQL Statements in Report Processing
    • 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.
  • Creating Complex Formulas
    • You have created reports and worked with simple formulas. Now you want to perform complex calculations on report data.
  • Completing the Course
    • You'll wrap things up and then validate what you've learned in this course by taking an assessment.

Taught by

Bill Rosenthal

Reviews

Start your review of Crystal Reports: SQL Statements and Complex Formulas

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.