creating own SQL query in CR9

[adrianroy]

Hello
I've heard that one can create own SQL query and use UNIONs etc in CR9 but I can't find where to do it...any hints/pointers??!!
regards
Adrian

 

[synapsevampire]

Just edit/replace it directly.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

You still can't edit the "show SQL" window, but you can create a SQL 'command' and use that as the source for your report. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[pgmr]

Could you create multiple SQL commands as source for a report using Ver9.0?

 

[kenhamady]

Not sure what you mean.

Since each command creates a virtual table, and you can only have one virtual table for each report, I don't think so. You could have a command for the main report and another for a subreport. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com