O'Reilly logo

Microsoft Dynamics GP 2013 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 Microsoft Query tool included with Excel can work with ODBC to connect to live data in Dynamics GP. This process is as fast ...

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