Re: sqr vs crystal -Reply

["Wanko, Christopher G, CFCTRCFFIN" <apollo@ATT.COM>]

> We use Maximo. I have about 40/60 with SQR at 60%.. Depending
> on your database there are things you can't (or are difficult
> to do in crystal)If you want quick and and sometimes easy and
> good looks.. use crystal. There are two reports we have, one
> was written in crystal and one in SQR ..both have the same
> output.. SQR takes 40 seconds, crystal takes at least 10
> minutes and really puts a load on the server.

I have to agree with Wes on the speed issue.  SQR uses our direct Sybase
connection, and this is much faster than any ODBC I can imagine.  I'd say,
in general, direct (non-ODBC) connectivity is really what's being compared
when you compare the speed of both.

If you could mate Crystal's output formatting with SQR's flexibility and
speed, you'd have an all-around winner.  To some extent, you can get the
best of both worlds if you use SQR to extract the data and Crystal to format
it, but unless you have plenty of spare time in order to coordinate and
automate it, I wouldn't bother...

-Chris