Sql Reporting services

[member27]

Hi all, Is Sql reporting Services will be faster compare to Crystal reports ? can any one suggest me which tool is best for loading nearly lakhs of datas ?? which tool is best ? can any one suggest me

[Wendelius]

Lots of comparisons: http://www.google.com/search?hl=en&q=compare+crystal+sql+server+reporting+services&meta=&aq=f&oq=[^]

The need to optimize rises from a bad design.My articles[^]

[member27]

Thank u for ur reply..Iam not asking u the differences between them i know to google and find the difference.. Which tool is more faster i asked..Coz this is forum to get ideas from well versed people and fix soon

[Wendelius]

cbenan wrote:

Which tool is more faster i asked..

I believe that this is a matter of design, usage scenario, datasources etc. Since both of those tools behave very differently it's quite impossible to predefine which one is faster. If you have an open situation meaning that you can build the reporting as you like, I would say that Reporting Services has more possibilities to do things since it's more like just a layout-engine. Crystal offers more built-in capabilities but on the other hand it's perhaps restricting you more than SSRS. Also you should note that Crystal is an older product so it's more mature (in a way) and SSRS is still developing to it's full size. I guess this means that the situation is currently something, but after few years it may be a whole lot different. This affects if you're making a long term decision. Just added performance keyword to the query and seems that there a some comparison on this aspect also: http://www.google.com/search?hl=en&q=compare+performance+crystal+sql+server+reporting+services[^]

The need to optimize rises from a bad design.My articles[^]