Custom Refreshable Excel Reports in Microsoft Dynamics GP navigation lists

Microsoft Dynamics GPMark Polino highlighted a post on Getting Custom with Excel Refreshable Reports on the Dynamics GP Support and Services Blog.

I’ve made a lot of use for clients on refreshable Excel reports and have made them available in the navigation list for clients (more recently, I’ve used that to make Jet Reports accessible in the same way):

Custom refreshable Excel reports in the navigation lists

I wasn’t aware this was problematic, but Béat Bucher posted a question in response to the Microsoft article saying that he couldn’t get custom reports to display, and the Microsoft author of the article agreed it didn’t work and would look into it. I’ve pretty sure I’ve used this for years without knowing there was a problem.

The deployment paths for the standard and custom reports on my demo environment are:

Reporting Tools Setup

From the specified folder onward, the path structure needs to include the database name and series. This means my standard report path for Purchasing series reports of:

\\demo-gp\Dynamics Central\Reports\Excel Reports\Reports\TWO\Purchasing

For custom refreshable Excel reports becomes:

\\demo-gp\Dynamics Central\Reports\User Reports\Reports\TWO\Purchasing

Any report added to this folder will be visible in the purchasing navigation list. Reports for other series would have a similar folder structure created.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *