O'Reilly logo

Microsoft Dynamics GP 2016 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reporting on any Dynamics GP data with direct Excel connections

In an earlier recipe, we looked at deploying and using the Excel reports contained in Dynamics GP. For all of the power of those dynamic reports, one thing is missing, the ability to modify the type of data being returned from within Excel. Excel reports allow filtering. However, if a user only needs a subset of data, using filters can make it difficult to work with only the filtered data. Also, Excel reports bring in all of the available rows, creating a much larger data set to work with and possibly overwhelming Excel.

Fortunately, there is another option. The MS Query tool included with Excel can work with Open Database Connectivity (ODBC) to connect to live data in Dynamics GP. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required