MS SSRS and crystal report

Dear all,

right now we are comparing SSRS and Crystal report as we try to see what can we do on existing crystal report, upgrade it or use SSRS.

please share the diff between them in terms of easy of use and programmability as well as issue if we convert CR to SSRS.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
There's a comparison here: http://www.pdfdrive.net/crystal-decisions-vs-ssrs-e1557740.html

Keep in mind that Crystal has a thriving ecosystem of 3rd-party tools (some are free/inexpensive) that boost the value of that option.
0
mlmccCommented:
Several more comparisons.

http://www.seguetech.com/blog/2013/12/17/comparing-crystal-reports-sql-server

https://social.msdn.microsoft.com/forums/sqlserver/en-US/2ee49c4c-11a5-4720-ae5b-a12c97fbe5ed/ssrs-vs-crystal

http://www.crystalmigrater.com/ssrslimitations.html

There are numerous comparisons available each somewhat biased based on the author's current tool.
Most of the comparisons are between older versions so many of the differences or concerns about one tool or the other may have disappeared.

The last link also sells migrations
http://www.crystalmigrater.com/Default.aspx

Ken Hamady also has links to several comparisons.  Again 2 of them are dated.  The other is from Crystal Migrator which lists limitations of SSRS from 2013.
http://www.crystalmigrater.com/ssrslimitations.html

Another conversion tool
http://www.ktlsolutions.com/Products/CrystalConverter.aspx

One thing I will say is the learning curve of going from Crystal to SSRS can be a bit steep.  The tools are very different in how they are used so keep that in mind.  

I have also read that even though SSRS is "free" many feel you need to put it on its own server so unless you have a spare sitting around, that could be an expense.  Also even though you can get it with SQL Server Express Advanced to be fully functional (multiple users) requires you to get it with SQL Server.

There is a version of Crystal that is free for use with Visual Studio.

Good luck
mlmcc
0
marrowyungSenior Technical architecture (Data)Author Commented:
"Also even though you can get it with SQL Server Express Advanced to be fully functional (multiple users) requires you to get it with SQL Server"

you mean get all function we need paid SQL server version ?

"
 There is a version of Crystal that is free for use with Visual Studio."

but that one is not fully functional ?

"Ken Hamady also has links to several comparisons.  Again 2 of them are dated.  The other is from Crystal Migrator which lists limitations of SSRS from 2013."

SSRS seems do not have 2013, right? SSRS come with MS SQL.

"Another conversion tool
http://www.ktlsolutions.com/Products/CrystalConverter.aspx"

any limitation on the converter ? it seems that MS SQL SSRS has converting tools ?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

mlmccCommented:
My understanding is the SSRS with SQL Express is fully functional except it is limited to 1 user/report at a time.  I believe that is in one of the links I provided.

For Crystal with Visual Studio, my understanding is it is functionally the same as the current full versions except is doesn't have a stand-alone editor.  All editing is done in the VS IDE.

I don't know about the report conversion tools other than what is on their web pages.

The limitations I refer to as from 2013, is because the article has a 2013 date on it.  None of the comparisons I have seen really give the versions they are comparing.

mlmcc
0
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Here's another useful comnparison:
http://www.codemag.com/Article/0711041
0
marrowyungSenior Technical architecture (Data)Author Commented:
IdoMillet,

this http://www.pdfdrive.net/crystal-decisions-vs-ssrs-e1557740.html, comparing Crystal decision and SSRS, but I am concerning Crystal report and SSRS.
0
mlmccCommented:
Crystal Decisions is one of many former names of the company that develops and sells Crystal Reports.

mlmcc
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks.

so Crystal Decisions  is the company which release Crystal report.
0
mlmccCommented:
It used to be.

Crystal Reports was originally developed by Seagate Systems.  Crystal 8 and before.
They rebranded themselves as Crystal Decisions circa 2000.  I believe Crystal 9 and 10
Crystal Decisions merged with Business Objects circa 2005.  I believe CR XI and 2008
Business Objects was acquired by SAP about 5 years ago.  All versions since

SAP now maintains and distributes Crystal Reports.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
great, tksk.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.