How can I run a SQL statement using Crystal 2008 report?

[deborahyr]

I have SQL statements that I want to run using Crystal 2008 reports but once I view 'Show SQL Query' under Database Expert, there is no way to cut and paste my SQL statement into the report. Is this possible?

 

[IanWaterman]

You have to use a command

In database expert select command and then paste your SQL into the dialog box. You can add Input paramters too.

Ian

 

[IdoMillet]

The other option is to create or use an existing UFL (User Function Library) that provides an SQL execution function. One of the UFLs listed at

http://www.kenhamady.com/bookmarks.html

provides several SQL-related functions.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com