RE: SQL Reporting Services 2005 v. Crystal Reports Server XI

RE: SQL Reporting Services 2005 v. Crystal Reports Server XI

 

  

Yeah figures that a government institution would use it. I'll have to
have a word with Commissioner John Q. Winn!



Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886


-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x83367550.[Email address protected]
Sent: Friday, April 28, 2006 2:56 PM
To: LazyDBA Discussion
Subject: RE: SQL Reporting Services 2005 v. Crystal Reports Server XI

Hey Christopher!
Oh my! Phew! 1/2 of my paycheck! Ouch! hehe. Ahhhhhhh, yes! We
use Cognos, also! It's the "cream of the crop"! However, I am now
driving the Volkswagen! hehe.






Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Bellizzi Christopher - IBG
[mailto:mssqldba-ezmlmshield-x5822967.[Email address protected]
Sent: Friday, April 28, 2006 2:32 PM
To: LazyDBA Discussion
Subject: RE: SQL Reporting Services 2005 v. Crystal Reports Server XI


Well when I came to be here they were using Cognos reporting and crystal
reports (although a early version) to do reporting. We have switched
over to WRS for reports as it didn't make sense to upgrade to next
version of crystal and Cognos wanted 200K for license fees for all our
users. Heck that's like 2 64 bit SQL servers and a 8TB SAN or 1/2 of
Ed's paycheck! Big thing is that most of the reporting was simple
reporting. I think sometimes people need a Volkswagen and buy a
Mercedes at least here.
In our investigation between Cognos and RS the Cognos admin kept bring
up all these bells and whistles, me end retort was "we'll show me where
your using them" and for the ROI they were negligible.
I haven't use Crystal in quite sometime so I can't respond as to plus
and minus.



Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886


-----Original Message-----
From: Ken Ross
[mailto:mssqldba-ezmlmshield-x86066190.[Email address protected]
Sent: Friday, April 28, 2006 2:19 PM
To: LazyDBA Discussion
Subject: RE: SQL Reporting Services 2005 v. Crystal Reports Server XI

For me, the first question is "where do these reports live"? If we're
talking about an application with distributed client reports (a Windows
"desktop" application), then I would definitely go with Crystal.
However, if you're looking at a hosted application (web) with a report
server delivering content to dozens or hundreds of users, the decision
is a bit more complex.

In terms of pricing, I think you'll find Reporting Services to be a much
better deal than Crystal's report server.

In terms of performance, we have to get a bit more specific again. For
example, if you tend to generate your reports to PDF in order to ease
printing, Crystal is terribly inefficient at this (it renders the PDF to
the disk on the server, then sends it the client). SQL Reporting
Services streams the content without writing to disk on the server and
so performs much better.

Crystal has been around a lot longer and has a strong history. SQL RS is
the new kid and lacks a few features. If the "missing" bits aren't
important to you, then it doesn't much matter and the extra flexibility
that a non-banded report designer gives you may well be worth whatever
other slight trade-off you might need to make.

Ken


-----Original Message-----
From: Alex Borshch
[mailto:mssqldba-ezmlmshield-x2015337.[Email address protected]
Sent: Thursday, April 27, 2006 1:12 PM
To: LazyDBA Discussion
Subject: SQL Reporting Services 2005 v. Crystal Reports Server XI

My company is considering implementing either Reporting Services 2005 or
Crystal Reports for our report generation, so I've been comparing them
the past week. Does anyone have experience with these that can comment
on which one is a better choice, in terms of performance, ease of use
(for both report designer and end-user), and value? I am leaning
towards RS, because I like using SQL queries as datasets, but I also
like some features of Crystal better, like the report server itself, and
the price.



Any comments?



Alex Borshch





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


************************************
This e-mail and any files transmitted with it are proprietary and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this e-mail in error please notify the
sender. Please note that any views or opinions presented in this e-mail
are solely those of the author and do not necessarily represent those of
ITT Industries, Inc. The recipient should check this e-mail and any
attachments for the presence of viruses. ITT Industries accepts no
liability for any damage caused by any virus transmitted by this e-mail.
************************************




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


************************************
This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Industries, Inc. The recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page