Editing SQL

[peterDavey]

G'day,
I've just upgraded from CR8 to 9 mainly because 9 offers more control over SQL. I have an existing report for which I want to edit the SQL. hOW DO i DO THAT IN cr9?

Thanks

cheers
peterDavey

 

[synapsevampire]

You can use SQL as the data source for your report by using the ADD command (which technically you could do with CR 8.5 as well by using ADO/RDO and pasting the SQL in).

Even in CR 8.5, try not to edit the SQL as you'll lose the record selection formula functionality.

The best methodology is to create Views or SP's on the database itself.

-k