GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
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
-IIS 6.0
-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…
GP 2010 includes the functionality to allow users to design their own Home Page by creating their own reports in SQL Server Reporting Services, and displaying those…
This is a list of SQL Server Reporting Services reports that are available for Dynamics GP 10.0. You should also check out the KnowledgeBase article #954242
SSRS reports:
Field Service
Contract Information SVC RTV Hard Copy
Financial
Additions Report Bank Transaction History Report Checkbook Register Fixed Asset Depreciation Detail Fixed Assets Depreciation Ledger Fixed Assets to General Ledger Reconciliation Report Journal Entry Report Period Projection Report Retirements Report Source Cross Reference Trial Balance Detail Trial Balance Summary Undeposited Receipts
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.
No, I can't show you how to use SQL Reporting Services (SRS) in a short blog posting. I can however show you how to access your SRS setup from Dynamics GP.
No, I can't show you how to use SQL Reporting Services…
"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,…