With the recent release of Dynamics GP 2010, (download a Dynamics GP 2010 data sheet here) users are starting to notice the direction Microsoft is taking with its Reporting Strategy.  With over 90 out of the box SQL Reporting Services (SSRS) Reports available in the new release, more and more Great Plains clients are starting to buzz about SQL Server Reporting Services.  With Crystal and Dynamics GP Report Writer becoming outdated, and not user-friendly, Microsoft is starting to completely phase out these products and go full throttle down the SSRS road.

SQL Reporting Services (SSRS) allows users to access their data anytime, anywhere, without consuming a full Dynamics GP/ERP user license.   It also allows report developers to leverage their Visual Studio skills in creating custom reports using Queries or Stored Procedures.  If you aren’t experienced with Visual Studio, SSRS allows the end user, with minimal training, the ability to author reports using the Office-Familiar Report Builder 3.0.

The delivery and publishing of these reports take report deployment to a new level.  Integration to SharePoint and Business Portal allow reports to be published to web-sites that can be accessed by non-ERP users.  Scheduled report execution is available in SSRS which gives Report managers the ability to create subscriptions to automate report execution in several formats (PDF, Excel, Word, XML) and e-mail to specific users automatically.  SQL Server Reporting Services implements a flexible, role-tailored security model to protect reports and reporting resources.

Many Dynamics GP clients do not realize that they already own this technology as it comes with SQL Server.  Once it is installed and configured, report packs can be deployed, and custom reports are ready for creation.

Interested in learning more? SBS Group, a New Jersey Dynamics GP Partner, hosted a 30-minute “What’s New in SQL Reporting Services” Webinar on June 23^rd. View the "What's New in SQL Reporting Services" presentation or email info@sbsgroupusa.com for more information.  For over 24 years, SBS Group has implemented Microsoft Dynamics GP solutions and helped businesses with their ERP/Accounting and business process needs. Contact SBS Group here or call 732.476.5909.

By: SBS Group – New Jersey Microsoft Dynamics GP, CRM & SL Partner

June 27, 2010 by Velosio

Email | Print

Ask The Author

Tags: dynamics gp NJ, Dynamics GP Reporting, microsoft dynamics gp NJ
Posted in About Microsoft Dynamics GP, Microsoft Dynamics ERP Functionality, Microsoft Dynamics GP 2010 | Comments Off on Out with the OLD, in with the NEW…Dynamics GP Reporting!

More Posts By Velosio

1. The Power of Data Integration: When Your ERP Connects with Your Email and the Microsoft Ecosystem
2. 3 Steps to Implement the Right Accounting Solution for Your Business
3. Everyone talks about project-based ERP, so it must be pretty important. Right?
4. PowerBI License and User Types: What Skills are Needed for Developers, Analysts, and End Users
5. 6 Reasons Professional Service Firms Should Switch to Cloud ERP

Related Posts

1. Sneak Peek: Microsoft Dynamics GP “11” (GP 2010)
2. Over 300+ Enhancements in Microsoft Dynamics GP 2010!
3. Reporting Fail? Keys to Avoiding Weak Executive Dashboards
4. Tips for Optimizing Your ERP Software Dashboard Design
5. 5 Common ERP Mistakes and How to Fix Them