Crystal Reports for Eclipse Developer Guide

Defining an SQL command object

If the database you are using supports SQL, you can write your own command, which will be represented in Crystal Reports as a “Table” object. This allows users complete control of the data processing that gets pushed down to the database server.
To write your own command, you create an SQL file and add it to a report. Adding the SQL command to your report will create a virtual table, containing the results of processing the SQL command.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/