DM330e - BusinessObjects: SQL Commands

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • This course is designed to teach learners how to efficiently produce reports with heightened functionality and more robust data connectivity by using SQL Commands in Crystal Reports®.
  • This course is not intended to teach users the SQL Language. Although some of the language's basic syntax is discussed, additional resources should be sought for further instruction in the SQL language.
  • 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

Audience

  • This course is designed for report designers, who have taken Crystal Reports® XI: Report Design I – Fundamentals of Report De…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Crystal Reports, SQL & MySQL, PL/SQL, Microsoft Access, and Programming (general).

Goals

  • This course is designed to teach learners how to efficiently produce reports with heightened functionality and more robust data connectivity by using SQL Commands in Crystal Reports®.
  • This course is not intended to teach users the SQL Language. Although some of the language's basic syntax is discussed, additional resources should be sought for further instruction in the SQL language.
  • 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

Audience

  • This course is designed for report designers, who have taken Crystal Reports® XI: Report Design I – Fundamentals of Report Design, Crystal Reports® XI: Report Design II - Business Reporting Solutions, Crystal Reports® XI: Report Design III - Report Processing Strategies, and Crystal Reports® XI: Report Design IV - Optimizing Report Data and who are responsible for creating and distributing reports.

Prerequisites

Essential
  • * 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 in BusinessObjects™ XI: SQL Commands build on concepts from Crystal Reports® XI: Report Design I – Fundamentals of Report Design, Crystal Reports® XI: Report Design II - Business Reporting Solutions, Crystal Reports® XI: Report Design III - Report Processing Strategies, and Crystal Reports® XI: Report Design IV - Optimizing Report Data. It is therefore very important that learners have a solid understanding of the concepts taught at that level before enrolling in this course.

Content

  • SQL and reporting with Crystal Reports
    • Writing an SQL statement
    • Using the SQL Query window
    • Using Crystal Reports as an SQL Authoring tool
    • Creating a basic SQL Command
  • How Crystal Reports uses SQL Commands
    • Saving an SQL Command to the repository
    • Adding SQL Command fields to a report
    • Modifying an SQL Command
    • Adding a parameter in an SQL Command
    • Selecting tables using an SQL parameter
  • Enhancing reports using SQL Command Records
    • Reporting from multiple SQL Commands
    • Creating a dynamic TopN report
    • Combining fields from multiple tables
    • Setting the location to an SQL Command

Notes

  • Course length: 4 hours
  • Certification applicability
    • This course is not part of a certification path.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.