O'Reilly logo

Special Edition Using® Crystal Reports® 10 by Roger Sanborn, Steve Lucas, Kathryn Hunt, Joe Estes, Michael Voloshko, James Edkins, Bob Coates, Naisan Geula, Ryan Marples, Neil FitzGerald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Database Objects to Your Report

The term database objects is used to describe the various forms of data that can be added to a report. Specifically, Crystal Reports can use the following types of database objects as data sources for a report:

  • Tables or system tables

  • Views

  • Synonyms

  • Stored procedures

  • SQL Commands

Database objects are listed underneath connections in the Data explorer and are grouped by object type. In Figure 1.8, the various database objects are shown for the Xtreme Sample Database. In this case, there are tables, views, system tables, and stored procedures. The Add Command node gives you the ability to add SQL commands to this report.

Figure 1.8. The Data Explorer presents database objects in their logical categories.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required