Why you should move from Crystal Reports to SSRS (SQL Server Reporting Services)
If you are looking for a more customizable, reliable, and secure reporting for your company, Practical Technology Solutions can help you! PTS is your one stop Independent company for all of your Epicor® service needs. We provide many services including: Implementations, Upgrades, Development, Consulting, New Installs, Training, System Admin. and Help Desk across multiple versions of Epicor®.
Some Epicor® users may wonder what the benefits of moving from Crystal to SSRS are and there are several. Here are a few reasons you should consider moving from Crystal to SSRS:
Crystal is being phased out of the Epicor® landscape moving forward. Even though all the current reports will work with Crystal, all new report functionality, bug fixes, and enhancements will happen on the SSRS platform. This is because Epicor® has moved to SSRS being their default reporting service.
Financially SSRS is a win as well; this is because SSRS comes with your Microsoft SQL installation. This gets rid of the need to buy and install Crystal Developer or run times on each client, saving your company money and adding better and more reliable functionality.
Interactivity with your report is much more prevalent with SSRS developed reports. The ability to drill down, sort, or interact with matrices gives viewing data a personalized touch, allowing the user to view the data how they want. The SQL platform itself allows for a powerful set of query tools built into your reports. From the simple to complex SQL facilitates queries that present the data that is important to you.
Security inside the world of SSRS is more granular than Crystal as well, allowing for a range of securities to be applied to each folder. Overall SSRS is simpler, more powerful, and better secured!