Execute some SQL Statements Before Report

[krishnappan]

Before my report kicks off, i want to execute some SQL statements like insert delete. Could you let me know how i can do that?

 

[IdoMillet]

One option is to use a command that starts with your desired statements and ends with the select statement for the report (or for a subreport).

Another option is to use a UFL that provides SQL Statement functionality.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[krishnappan]

Thanks for ur reply ....

did you mean add command?
if so is there any order in which the add command list is executed?

could u pls explain what is UFL?

 

[IdoMillet]

For the 1st question, see:

http://technicalsupport.businessobj...iceId=&dialogID=16344292&stateId=1 0 16342696

A UFL is a User Function Library. You can create your own or purchase one that someone already developed. For a list of 3rd-party Crystal tools, see:

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

My "CUT Light" UFL provides SQL Calling functionality, so you can invoke SQL statements from Crystal functions.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[krishnappan]

In the add command i tried the following

Delete from temp_footnote;
select * my_table;

it says invalid character ... i even tried without semicolon , then it says sql statement not eneded properly ... could you give an syntax of adding multiple statement in a single add command .....