Mark 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):
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:
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.