In Dynamics GP we have a cool feature to have SQL server reporting services(SSRS) reports, Microsoft SQL Server Reporting Services (SSRS) offers a very powerful report writing capability for any SQL Server based system. Specifically for Microsoft Dynamics GP, Microsoft has created a library of over 200 pre-built reports to use.
In Order to access and leverage the SSRS Library that is provided by Microsoft and to upload it to your Dynamics GP system you need to perform some simple steps
Step 0 :Prerequisites
-SQL Server Reporting Services 2005 With SP2 Or Later
-SQL Server Reporting Services 2008 With SP3 For SQL Server Reporting Services Wizard
-Internet Explorer 7 or 6 with SP2
-Dynamics GP 10.0 with Service Pack 1 or Later
Step 1 :Install & Setup IIS
-For Windows 2003
oClick Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
oClick Add/Remove Windows Components, The Windows Components Wizard appears.
oIn the Windows Components list, click Application Server, but do not select the check box.
oClick Details, and then click to select the Internet Information Services (IIS) check box.
oFor Further Details Please refer to windows manual.
-For Windows 2008
oClick Start -> All Programs -> Administrative Tools -> Server Manager.
oIn Server Manager, scroll down to Roles Summary, and then click on Add Roles. The Add Roles Wizard will start…
We recently finished a SQL Server Reporting Services engagement for a client requiring that the Sales Order Processing data displayed in reports be filtered by Salesperson. That alone is simple enough; you could simply add the Salesperson or Territory as a parameter on the SSRS Report, right? The challenge here was that reps could never be permitted to view another Salesperson's data. So, it couldn't be quite that simple. This was compounded only slightly by the requirement that, logically, sales managers needed to see all of the data for their Territories. So, depending on whether a Salesperson was a Rep or a Territory Manager the results would vary.
"It didn't take long to figure out that the problem wasn't with Business Portal, but rather the way they were trying to use it and NOT using SQL Server Reporting Services (SSRS). Both tools have a place in their environment,…