Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Computeration

FAQ: Integration of SQL Server Reporting Services with Microsoft Dynamics GP 2010


Email | Print

Microsoft Dynamics® GP 2010 has over 330 new updates and features – nearly triple the number for previous releases. So the main challenge is how to come up to speed quickly on those that are most useful to you.  The biggest obstacle with a state of the art system is training – not knowing what it’s capable of doing and/or how to invest your time in training.  We want to help you with those issues.

As a Microsoft Dynamics GP partner, I work with many customers like you that have questions on a daily basis. I admit that some questions catch me off guard and I need to do some research to find the answer, especially for a new product launch. But today, I would like to share my findings for two frequently asked questions about the integration of SQL Server Reporting Services (SSRS) with Microsoft Dynamics GP 2010:

Q: Which reports are available in Microsoft Dynamics GP 2010?

A: In Microsoft Dynamics GP 2010, more than 60 reports and 13 report models are built on SQL Server 2005 Reporting Services technology. SSRS reports pull data from Microsoft Dynamics GP. These reports are visible within the report list if the appropriate setup is completed.
To help make setup easier, reports are automatically associated with report roles that are created during the installation; including field service, financial, human resources, inventory, manufacturing, payroll, project, purchasing, and sales

Q: What are the Charts and KPIs that you can deploy from the SQL Server Reporting Services Wizard for Microsoft Dynamics GP 2010?

A: The Charts and KPIs that can be deployed are used to populate the Metrics section of the Microsoft Dynamics GP 2010 home page. You can enable these by clicking to select the Enable SQL Server Reporting Services Home Page Metrics box in the Reporting Tools Setup window.
To specify what reports to display on a users home page click Customize this page, then click the clue expansion button next to Metrics. Move the metrics that you want to the Metrics to display column, and then click OK.
The Charts and KPIs can also be displayed on the Executive Dashboard in Business Portal for Dynamics GP 2010.

Remember that all questions are good questions as it will ultimately help you get the most out of your solution. We here at Computeration encourage all inquiries and strive to make Microsoft Dynamics products, such as Microsoft Dynamics GP, work the best for your business. Contact us today with your good questions!

Specializing in ways to enhance your company’s solutions with Microsoft Dynamics GP in Idaho and the Pacific Northwest, with clients around the world, Computeration makes your implementation successful by offering experienced project management, data integration, training, and consulting services.

By Gloria Braunschweig with Computeration, a Portland Microsoft Dynamics GP Partner

2 Responses to “FAQ: Integration of SQL Server Reporting Services with Microsoft Dynamics GP 2010”

  1. The SSRS security is based on a user’s active directory login and not their GP login.
    1. The SSRS reports are granted access to SQL thru either a pass thru SQL account or via the active directory login.
    2. Then individual users are granted access to the SSRS report thru assigning their active directory login access to the report thru report manager.

    So the security must be set according to a user’s active directory login then the user will see the reports they have access to under customized reports.

  2. Santiago says:

    Is there any way to grant permissions to a user’s GP to some reports made in Reporting Services? That is, as the user logged in GP determine which reports are presented in customized reports?

Ask This Expert a Question / Leave a Comment