Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


Specify SQL Query (Command) in Crystal Report
Applies to CR 10.0. For 8.5, use 'Show SQL Query'

In the Database Expert, double click 'Add Command' below the database instance name. Specify valid select sql, such as
select * from user_info where company = 'main'
Optionally add parameters using the provided buttons (double click the param name to insert into sql query). Then, hit OK, and rename the 'Command' by selecting it and hitting F2.
When joining it to existing tables, an arrow appears, implying that it is left joined- however, you need to MANUALLY check and verify the join type, because the arrow is also the default for an inner join (to or from a command).
To edit the command, right click on it and choose edit. If CR crashes after saving the report, there is a hotfix available at the CR site that you should install (known bug).

Created By: amos 4/17/2006 2:57:50 PM
Updated: 1/13/2020 3:19:03 PM

 > Guest 8/8/2009 5:35:02 AM
I m not getting sql command object in crystal 8.5
 > amos 8/15/2011 7:53:43 PM
This fix only applies to version 10. For Version 8.5, use 'Show SQL Query'.