Crystal Reports: SQL Statements and Complex Formulas

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

• Use SQL statements in report data processing
• Create complex formulas using loops and arrays
• Enhance report accuracy with advanced queries

• Basic computer and internet skills
• Ability to read instructions in English and complete short practice activities