Top Websites
- Dynamics GP Help
Over 5800 resources listed. - Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Rose Business Solutions Blog New
Over 2200 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 1100 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 900 resources listed. - Microsoft Dynamics Partner Community Blog
Over 900 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 600 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 500 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 500 resources listed. - eOne Business Solutions Blog
Over 400 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - Dynamics CPM
Over 300 resources listed. - BKD Dynamics GP Insights Blog
Over 200 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 200 resources listed. - Victoria Yudin's Dynamics GP Website
Over 200 resources listed.Victoria Yudin - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: SQL Reporting Services
Links Sort by: Hits | References | Alphabetical
Things I love about SQL Reporting Services
http://dynamicsgpland.blogspot.com/2009/04/things-i-love-about-sql-reporting.html
Posted by
Using SQL Server Reporting Services(SSRS) with Microsoft Dynamics GP
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.
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
- For Windows 2008
o Click Start -> All Programs -> Administrative Tools -> Server Manager.
http://waqasb.blogspot.com/2010/02/using-sql-server-reporting-servicesssrs.html
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
o Click Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
o Click Add/Remove Windows Components, The Windows Components Wizard appears.
o In the Windows Components list, click Application Server, but do not select the check box.
o Click Details, and then click to select the Internet Information Services (IIS) check box.
o For Further Details Please refer to windows manual.
- For Windows 2008
o Click Start -> All Programs -> Administrative Tools -> Server Manager.
o In Server Manager, scroll down to Roles Summary, and then click on Add Roles. The Add Roles Wizard will start…
Posted by
DotNetRocks Podcast has Thiago Silva on SSRS for 2008
http://msdynamicsgp.blogspot.com/2008/08/dotnetrocks-podcast-has-thiago-silva-on.html
The Dot Net Rocks podcast has Thiago Silva talking about the new features of SQL Reporting…
Posted by
Crystal Reports vs. SQL Server Reporting Services
http://msdynamicsgp.blogspot.com/2008/02/crystal-reports-vs-sql-server-reporting.html
DevX.com has a nice article comparing Crystal Reports and SQL Server Reporting Services (SSRS). The article contain a little code but don't worry, you'll get it even if you are not a developer. The point of the article is to compare the two, presenting the differences without lobbying for or the…
Posted by
Integrating Microsoft Dynamics GP With SQL Reporting Services
http://mohdaoud.blogspot.com/2009/11/integrating-microsoft-dynamics-gp-with.html
GP 2010 - User Defined KPI's and Graphs on the Home Page Using SQL Server Reporting Services
http://www.rosebizinc.com/gpblog/2010/03/gp-2010-user-defined-kpi-and-graphs-on.html
SSRS Reports Available in Dynamics GP 10.0
http://www.rosebizinc.com/gpblog/2009/10/ssrs-reports-available-in-dynamics-gp.html
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
Human Resources
Employee Attendance Detail
Employee Attendance Summary
E…
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
Human Resources
Employee Attendance Detail
Employee Attendance Summary
E…
SSRS Report Builder with Dynamics GP
http://www.rosebizinc.com/gpblog/2009/08/ssrs-report-builder-with-dynamics-gp.html
Deploying GP SSRS Reports - maxRequestLength Error & Resolution
http://www.vaidy-dyngp.com/2010/06/deploying-gp-ssrs-reports.html
Setting up SSRS in Dynamics GP - Mariano's Input saved my day
http://www.vaidy-dyngp.com/2010/02/setting-up-ssrs-in-dynamics-gp-marianos.html
Generate Charts Using SSRS
http://www.vaidy-dyngp.com/2010/02/generate-charts-using-ssrs.html
MichaelJ2 has pointed out to a very good article in SQL Server Central portal, which…
Posted by
Generating charts in SQL Server Reporting Services
http://mbsguru.blogspot.com/2010/02/generating-charts-in-sql-server.html
SQLServerCentral.com has a nice post up with step-by-step instructions on generating charts…
Posted by
Publishing User Specific Data from Dynamics GP using SSRS
http://mbsguru.blogspot.com/2009/12/publishing-user-specific-data-from_29.html
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.
This…
Posted by
Weekly Review: Access SQL Reporting Services from GP
http://msdynamicsgp.blogspot.com/2010/03/weekly-review-access-sql-reporting.html
Exposing SQL Reporting Services Reports in Great Plains
http://gp.rosebizincblogs.com/2010/04/exposing-sql-reporting-services-reports-in-great-plains.html
New Article on MSDynamicsWorld: Michael Johnson on "Filtering Salesperson-specific data with SSRS"
http://dynamicsgpblogster.blogspot.com/2010/02/new-article-on-msdynamicsworld-michael.html
Publishing Salesperson Specific Data - GP & SSRS
http://msdynamicsgp.blogspot.com/2010/02/publishing-salesperson-specific-data-gp.html
SSRS Charts
http://msdynamicsgp.blogspot.com/2010/02/ssrs-charts.html
MichaelJ2 points us to a new SQL Server Central article on generating charts in SQL Server…
SSRS and Dynamics GP
http://msdynamicsgp.blogspot.com/2010/02/ssrs-and-dynamics-gp.html
Waqas Butt looks at SQL Server Reporting Services in Dynamics GP and the built in library…
Textbox Fun in SSRS
http://msdynamicsgp.blogspot.com/2009/09/textbox-fun-in-ssrs.html
Latest links
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”
- Reset Home Page
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Weeeee’rrrreeee Baaaack! Podcast 2: Presenting Convergence
GPWindow.com
Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.