Crystal Reports Can you use cursors etc when using Add Command?

Message

     I am using Crystal XI, connecting using ODBC to Oracle db. 

I've tried writing cursors, if/then statements, loops in the Add Command section to filter results and process info before bringing data into my Crystal Report but none have worked. They result in syntax errors. I have only successfully used SELECT statements. 

Can Crystal XI process cursors, declare variables, etc in the Command section? There's too much data to process in Crystal & should be done on the server.

Thanks.

Edited by jrs2345 - 28 Jul 2010 at 9:15am