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.