Hands On With MDGP 2018 RTM: Deploy Reporting Services Reports

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With SSRS configured to work with Microsoft Dynamics GP, we can now deploy the reports. This is done via Reporting Tools Setup (Administration area page >> Setup >> System >> Reporting Tool Setup).

Change the Report Server Mode to Native and enter the Report Server URL and Report Manager URL.

You can also set a subfolder for where the reports are to be deployed; this is useful when you have more than just the Microsoft Dynamics GP reports deployed onto the report server.

Make sure the checkboxes in the Deployment Options section are checked and click the Deploy Reports button.

Reporting Tool Setup

Continue reading “Hands On With MDGP 2018 RTM: Deploy Reporting Services Reports”

Hands On With MDGP 2018 RTM: Before Deploying the Reporting Services Reports

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

Now that Microsoft Dynamics GP 2018 RTM has been installed and confirmed working, it’s time to deploy the Reporting Services Reports. However, before I do so, there are two tasks which need to be done first.

The first is to ensure SQL Server Reporting Services itself has been configured to work with Microsoft Dynamics GP. This isn’t actually too difficult, it just requires the following element to be added to the web.config file:

maxRequestLength="20690"

This blog post has detailed instructions of how to make this configuration change.

The second change may not be needed; it will depend on the security settings on your PC or server, but I find myself making this change in advance anyway so that I do not have any issues and so that my AD login is automatically used. When I don’t make this change, I have had problems deploying the reports; when I make the attempt, the deployment hangs and eventually fails.

The change is to add the SSRS website to the Local Intranet zone. To do this, launch Internet Explorer, clikc the cog icon and then select Internet options:

Internet Explorer

Continue reading “Hands On With MDGP 2018 RTM: Before Deploying the Reporting Services Reports”

Hands On With Microsoft Dynamics GP 2016 R1: Create Company

Microsoft Dynamics GPIn the last couple of posts in this series, we have deployed the system database and Fabrikam sample database. In this post, I’m going to create a new company using GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Create Company”

Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company”

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

Microsoft Dynamics GPThe 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

Microsoft Dynamics GPWhen 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 “Deployment Server Has Exceeded The Maximum Request Length Error Deploying Reports To SSRS”

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

Microsoft Dynamics GPI 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 “Review of Microsoft Dynamics GP 2013 Reporting by David Duncan and Christopher J Liley”

Microsoft Dynamics GP 2013 Reporting – Review Incoming

Microsoft Dynamics GPI 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

Microsoft Dynamics GPIn 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 Deploy The Demo Company In Microsoft Dynamics GP 2010”

How To Create A Company In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn 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 “How To Create A Company In Microsoft Dynamics GP 2010”