Tag Archives: SSRS

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

Posted in Analysis Cubes for Excel, Business Analyzer, Dynamics, Excel Reports, GP, Management Reporter, Microsoft, Modifier with VBA, Report Writer, Reporting Services Reports, SmartList, SmartList Builder, Word Template Generator | Tagged , , , , , , , , , , , , , , , , , , , , , | Leave a comment

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.

Posted in Dynamics, GP, Management Reporter, Microsoft, Reporting Services Reports, SmartList Builder | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

How To Install Business Analyzer for Microsoft Dynamics GP 2013

In this post, I’ll take a step-by-step look at installing Business Analyzer for Microsoft Dynamics GP 2013. This is a tool that comes as standard with GP but I’ve never bothered to look at before; this has changed recently because I’ve been dealing with a few clients who are heavy users of SSRS and Business Analyzer gives way to run the GP reports without needing to log into Microsoft Dynamics GP itself.

To Install Microsoft Dynamics GP Business Analyzer start the normal Microsoft Dynamics GP setup utility and select Microsoft Dynamics GP Business Analyzer;

Microsoft Dynamics GP 2013 Setup Utility

Continue reading

Posted in Business Analyzer, Dynamics, GP, Microsoft | Tagged , , , , , , , , | 8 Comments

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

Posted in Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports | Tagged , , , , , , , , , , | 3 Comments

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

Posted in Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports | Tagged , , , , , , , , , , | 2 Comments

MDGP 2013 Feature of the Day: SSRS Reports On Forms

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixteenth feature they’ve announced is SSRS Reports On Forms.

This feature allows users to print SQL Server Reporting Services (SSRS) reports directly from a window in Microsoft Dynamics GP. This has been made available on a range of windows across General Ledger, Receivables Management, Sales Order Processing, Payables Management, Inventory Management, Human Resources and Payroll.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Print on Picklist Shortage Enquiry

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fourth feature they’ve announced is Print on Picklist Shortage Enquiry.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , | 1 Comment

SSRS GL Trial Balance Returning No Data

I was doing some testing to compare the SSRS Trial Balance against the standard report version but ran into a problem straight away when I found the SSRS version returned no data.

A quick search online found me this post SSRS: GL Trial Balance Summary report returns no data – Follow Up by Mariano Gomez where he discussed the exact problem I had encountered.

As Mariano says this has been fixed in the upcoming SP3 but for now there is a Knowledge Base article covering a workaround which is to alter the stored procedure (seeglPrintSRSTrialBalance) which is used for returning the data: GL Trial Balance SRS Reports return no data using Microsoft Dynamics GP.

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , | 2 Comments

How To Configure SQL Server Reporting Services In Order To Deploy Reporting Services Reports In GP

The post following this will cover deploying SSRS reports within Microsoft Dynamics GP but I thought I’d cover configuring SSRS as a spearate post rather than assuming everyone has it already configured. A number of the clients I deal with have had GP for a while and never installed the SSRS reports but are now doing so.

When you install SQL Server Reporting Services at the same time as SQL Server you have the option to automatically configure SSRS with the default settings. In the case of someone who has SQL already installed but didn’t install SSRS at the same time, this is not an option.

This How To starts after SSRS has been added to the installation on the client machine at the point where you would start to configure it; if you’d like a walk through adding SSRS to an existing installation of SQL Server, let me know and I’ll sort one out.

To do the initial configuration of SSRS, or to change the configuration of an existing installation, you need to start the Reporting Services Configuration Manager (Start menu >> Programs >> Microsoft SQL Server 2008 R2 ?? Configuration Tools >> Reporting Services Configuration Manager) Continue reading

Posted in Dynamics, GP, Microsoft, Reporting Services Reports, SSRS | Tagged , , , , , , , , | 1 Comment

Microsoft Dynamics GP 2010 R2 RTM VPC Is Now Available

Microsoft Dynamics GPDavid Musgrave on the Developing for Dynamics GP blog has forwarded on the announcement that the Microsoft Dynamics GP 2010 R2 RTM VPC image is now available.

This download comes in two parts; the Tech Demo Toolkit image as well as a Domain Controller image (I’ll try to check this out later but I’m off for a long weekend later today but presumably this is because Management Reporter requires a domain) and is only compatible with Microsoft Virtual PC 2007 SP1; if you have Windows Virtual PC installed you’ll need to remove it and revert back to the older one as, unfortunately, both cannt be installed at the same time.

Check out David’s blog post for details of all the changes or download the Toolkit from PartnerSource (PartnerSource login required).

Update:Just found the original post which came from Jay Manley on the Inside Microsoft Dynamics GP blog.

Posted in Dynamics, GP, Management Reporter, Microsoft | Tagged , , , , , | Leave a comment