Crystal SQL Designer in CR10 1

[alectek]

Hi!
Today is my first day of using Crystal 10.
In CR 8.5 I was using before, in Crystal Tools was Crystal SQL Designer.
I didn’t find anything like that in CR10.
What else can I use in CR10 to create an SQL queries.

Thanks a lot.

 

[lbass]

I don't have CR 10, but I believe that when you choose your datasource, one option is "SQL Command", and that this is where you would create your SQL query. Not sure, but might be worth a look.

-LB

 

[synapsevampire]

Crystal SQL Designer wasn't recommended in version 8.5, in CR 9 you had to download it seperately, and it is no longer available in CR 10.

It's just another proprietary layer.

The option LB is alluding to was also available in CR 9, it's listed as Add Command, and you can paste real SQL in there, as opposed to the pseudo SQL Crystal Designer created.

Since you didn't share which database you're using, it's hard to suggest a real SQL creation tool, but in general avoid anything proprietary, such as Crystal SQL Designer or MS Access.

Did I mention that I never liked Crystal SQL Designer

For Oracle, use Toad (free)

For SQL Server, use Query Designer which ships with SQL Server

There are generic products which work with numerous datbases, such as RapidSQL (Embarcadero).

There are SQL tools for most databases, and you're better served to use something which generates real SQL.

You might even consider creating Views and providing an insulating layer between the reports and the database in case the tables or business rules change. If they do, just go rework the View and the report(s) it's based on won't require modification.

Hope this helps, you shoudld be much happier long term using a real SQL tool.

-k

 

[alectek]

lbass,

thank you for you help.
I get full answer for my questions in the nex post from synapsevampire.