Install SQL Server 2014: SSRS Configuration for Microsoft Dynamics GP

Microsoft Dynamics GPin the previous two posts, I stepped through the installation and configuration of SSRS. To deploy the Microsoft Dynamics GP SSRS reports to the SSRS server there is one last piece of configuration which needs to be completed.

There is a setting in the web.config file which needs to be added for the reports to deploy successfully. I have previously blogged about that setting here. The only change in the path will be the version number in the folder name will be higher.

Once you have completed that step you can then move onto deploying the SSRS reports in Dynamics GP; this post was written on Dynamics GP 2010 R2, but the process for deploying them is the same in Dynamics GP 2015.

Click to show/hide the Install SQL Server 2014 Series Index

Install SQL Server 2014
SQL Server Installation
SSRS Installation
SSRS Configuration
SSRS Configuration for Microsoft Dynamics GP

MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports

The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The twenty-third Feature of the Day covered is Encumbrance SQL Reporting Services Reports. New SQL Reporting Services Reports have been created for Encumbrance Management; new Encumbrance Summary and Detail reports have been added to the existing list of SRS Reports. As with other SSRS reports these ones can be run from the Reporting Services Reports navigation list, directly from the deployment location or attached to and printed from a window in Microsoft Dynamics GP.

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Deployment Server Has Exceeded The Maximum Request Length Error Deploying Reports To SSRS

When Reporting Tools Setup is used t deploy the reports to SQL Server Reporing Services an error be produced if the default configuration of SSRS has not been amended (I thought I’d blogged about this error before, but when trying to find it to send the post to someone I couldn’t find it).

The error produced is the following:

Microsoft Dynamics GP - The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.Microsoft Dynamics GP – The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength=”20690″ in the web.config file and try deploying again.

Continue reading

Review of Microsoft Dynamics GP 2013 Reporting by David Duncan and Christopher J Liley

I have received a copy of the newly published Microsoft Dynamics GP 2013 Reporting, by David Duncan and Chrisopher J Liley, from Packt Publishing to review. This is an update of a previous book the pair wrote for Microsoft Dynamics GP 2010:

Microsoft Dynamics GP 2013 Reporting

The book covers an extensive range of the reporting tools in, or available with, Microsoft Dynamics GP 2013:

  • SmartList Builder including Excel Report Builder
  • Report Writer and Word Templates
  • Reporting Services Reports
  • Analysis Cubes
  • Management Reporter

Continue reading

Microsoft Dynamics GP 2013 Reporting – Review Incoming

I have received a copy of Microsoft Dynamics GP 2013 Reporting to review which I will be doing over the next couple of weeks.

This is an update to the previous edition of the book for Microsoft Dynamics GP 2010, but this one is for the current version:

Microsoft Dynamics GP 2013 Reporting

I’ll be giving it a thorough read and, setting aside my distaste for reporting outside of Management Reporter, I may even follow some of the examples and post a detailed account.

If you don’t want to wait for my review of the book, it can be bought now from Packt Publishing.

How To Deploy The Demo Company In Microsoft Dynamics GP 2010

In the last couple of posts, I showed how to configure the server of Microsoft Dynamics GP by creating the System database and how to create a new company. In this post I’m going to run through deploying the Fabrikam, Inc. demo company.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading

How To Create A Company In Microsoft Dynamics GP 2010

In the last post, I showed how to configure the server of Microsoft Dynamics GP by creating the System database. In this post I’m going to run through the company creation process.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading

MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty fourth feature they’ve announced is Multitenant SQL Server Reporting Services Reports.

The current version of Microsoft Dynamics GP only supports a dedicated instance of SQL Server Reporting Services for each Microsoft Dynamics GP data instance. With the introduction of the Multi-tenant System Database Architecture, the SQL Server Reporting Services needed to be updated to allow for similar functionality.

With this Multi-tenant SQL Server Reporting Services Reports feature, multiple data instances can be deployed to a single SQL Server Reporting Services instance by allowing the implementer to to deploy the reports to a “tenant” folder.

Continue reading

Microsoft Dynamics GP and Schrödinger’s Cat

One of the points I make (repeatedly until I see a confirmation they’ve done so) to clients when implementing Microsoft Dynamics GP is that they need to make sure that a maintenance backup of the SQL databases and other resources are being made.

In some cases the maintenance backup is a once a night job, other clients have had one done every twelve hours with log backups made every hour. As long as a regular backup is being made I’m happy and stop nagging them.

Continue reading

How To Deploy SSRS Reports In Microsoft Dynamics GP 2010 R2

Earlier this week I did a post on how to configure SQL Server Reporting Services for use with Microsoft Dynamics GP. This is the follow up post where I’m going to explain how to deploy the SSRS reports for GP.

To deploy the reports you need to open the Reporting Tools Setup window (Tools >> Setup >> System >> Reporting Tools Setup) Continue reading