Last post Mar 22, 2013 09:28 AM by stockcer
Mar 21, 2013 01:26 PM|jeffcarter|LINK
different between crystal report and sql reporting ?
I have a project but programmer is saying sql reporting takes a lot of time because all the framework needs to be created from scratch ?
what is this framework that programmer is talking about ?
why ? can anyone explain me why sql reporting will take more time as compared to crystal report ?
please provide me details ?
Mar 21, 2013 02:45 PM|stockcer|LINK
I am not sure of the "framework" that needs to be loaded. There are drag and drop controls for report viewer, but if you want a much more dynamic and robust report solution then use Reporting Services. I have used both and I can tell you that the cost
of ownership for Reporting Services is very low (especially if you already are using SQL Server) and from a developers perspective it has alot more bells and whistles. You can also set it up to run the reports directly. Check out this link to see how easy
it is to implement a reporting solution using SQL Reporting Services.
Note: A hosting provider like ARVIXE can set it up for you for a small price.
Here are some articles that might help you.
Mar 21, 2013 03:14 PM|jeffcarter|LINK
Thanks for your reply - but from the time point of view...what do you think which one is faster to implement and WHY ?
Since I am in the middle of the project and need something that will do the job and faster to implement.
Mar 21, 2013 03:26 PM|stockcer|LINK
Look at the example I sent and you can see that on the delivery method it is not difficult to construct the delivery. However; if you have no one that can use the reporting services designer then you are dealing with a
slight learning curve. I can honestly say that since I use both every day, I would prefer to use reporting services especially if you already are using SQL Server for this project. Sometimes the speed that you
are looking for is not the same answer as what is easier to support.
If you have reporting services already installed on the server then it is already implemented just go to a browser and type in the name of the server and reports.
You then upload the RDl and off you go...
Hope this helps.
Mar 22, 2013 06:55 AM|jeffcarter|LINK
Thank for the info.
What do you mean when you say " cost of ownership for Reporting Services is very low (especially if you already are using SQL Server)" ?
It is free and comes with visual studio right ?
For running the Sql server reports on server how easy it is ? According to
THIS, it says "In SSRS, in order to host reports we need to make a UI for the same" - What does this means for UI ?
Are they talking about when my website is done and I am putting the website on server, I need to do something on server if my website includes SSRS ?
Mar 22, 2013 09:28 AM|stockcer|LINK
Let me see if I can explain.
Taking all of the features and options SQL Reporting is cheaper. The reason is that if you license SQL server than you more than likely already "own" Reporting Services. When I say own, I am refering to the all of the other features that might be required.
If you looked at all of the features that both have and have to compare them you would need to buy the Crystal report Services engine which you would already own by licensing SQL.
Both reports types are "free" to use inside of a vb.net project. If you are using this for a windows app then Crystal would probably be better.
When you build SSRS you deploy the report to a SQL Server Reporting Services Server. ( 3 steps and 40 seconds) . Then calling the report is as simple as
http://reportservername/reports. Then the reports come up and when you click on it then it prompts to user for any parameters and such. You can also wrap security around it. It then runs the report and from there
you can print to PDF, etc. If you want to integrate it better with your app then you need to build an interface like the example I sent to you (http://blog.arvixe.com/creating-pdf-or-any-other-file-type-from-sql-reporting-services-using-wsdl-vs2012-part-1/ ).
You would have to do this with a Crystal Report as well.
I hope this helps.