• Professional Services
• Cursussen
• Algemeen
• Aanbod klassikaal
• Aanbod e-learning
• Aanbod e-learning XI
• Cursusrooster 2008
• Cursuslocatie tot 2 augustus
• Cursuslocatie vanaf 4 augustus
• Inschrijven klassikaal
• Inschrijven e-learning
• Inschrijven e-learning XI
• Wachtlijst
• Knowledge Accelerator
• Education Credits
• Authorized Education Partners

Crystal Reports 10: Creating and Using SQL Commands

This 4-hour eLearning course is designed to give learners comprehensive skills and indepth knowledge to create and use SQL Commands for reporting efficiency.

The Crystal Reports 10: Creating and Using SQL Commands - is an elective course in the Crystal Reports Certified Professional (CRCP) certification.

Who should attend?

This course is designed for report designers, who have taken CR10: Report Design I – Fundamentals of Report Design, CR10: Report Design II – Business Reporting , CR10: Report Design III – Report Processing Strategies and RD IV – Optimizing Report Data and who are responsible for creating and distributing reports.

What will I learn?

After completing the course, learners will be able to:

• Describe SQL and Crystal Reports
• Use SQL Commands to create Crystal Reports
• Enhance Reports Using SQL Commands

Course Agenda

Describe SQL and Crystal Reports

• Define SQL
• Describe how SQL is used in Crystal Reports
• Use a SQL Command
• Define a SQL Command
• Describe Server-side processing
• Compare Stored Procedures and SQL Commands
• Create a SQL Command

How Crystal Reports Uses SQL Commands

• Save a SQL Command to the Repository
• Add a commands field to a report
• Modifying a SQL Command
• Create a parameter in a SQL Command
• Modify a parameter in a SQL Command
• Add tables to a report based on a parameter

Enhance Reports Using SQL Commands

• Report from Multiple SQL Commands
• Create a Dynamic Top N Report
• Combining Fields From Multiple Tables
• Set Location from Multiple Tables to a SQL Command

Delivery and duration

4-hour eLearning course.

Certification Applicability

The Crystal Reports 10: Creating and Using SQL Commands course is an elective course in the Crystal Reports Certified Professional (CRCP) certification.

Prerequisites

In this course you will be working intensively with Crystal Reports. To successfully understand the content and complete the activities, you must already able to:

• Understand and use Windows conventions
• Understand basic database concepts
• Understand concepts taught in Associate level course

Note: Topics on CR10: Creating and Using SQL Commands builds on concepts from CR10: Report Design I – Fundamentals of Report Design, CR10: Report Design II – Business Reporting Solutions, CR10: Report Design III – Report Processing Strategies and RD IV – Optimizing Report Data therefore it is important that learners have a solid understanding of the concepts taught at that level.

Schedule

Accessible at any time.

Datasheet

Course Overview Crystal Reports 10: Creating and Using SQL Commands

Price

Public Per Delegate     € 140,00