With the recent release of Dynamics GP 2010, (
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.
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 23rd.