SQL to Crystal

[GC2000]

I need to know the equivalent of SQL Designer from older versions of Crystal in Crystal 2008. In version 8.5 specifically I was able to write the query separately and then have the report connect to the query. This was more efficient in a lot of scenario's for report speed and functionality. I once again have a situation where I have to use an SQL query but I am struggling as to where to put it in Crystal 2008. I read some stuff about SQL Expressions but apparently they can only return one field back. Is there any way to take a fully written SQL script and then connect to it through Crystal. I am trying to avoid creating a view if I can help it as I don't want the overhead. Any assistance would be much apprciated.

 

[lbass]

Use the add command feature. In XI, when you create a new blank report, you would find "Add command" above the list of tables in the database expert. If you are using parameters, create them within the command screen.

-LB