O'Reilly logo

Microsoft Dynamics GP 2010 Reporting by David Duncan, Christopher Liley

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

Creating ad-hoc reports

With our knowledge of the PivotTable basics, creating reports is actually quite simple and can be very fun once we get started. It's kind of like opening presents on Christmas morning, you don't really know how cool your report will be until you start playing with the different measures and matching them with different dimensions. An easy report to start with to get an idea of the power of Excel Analysis cubes for Excel is a simple one that uses the Accounts by Category dimension, the Signed Amount GL Trans measure and the Periodicity dimension as the columns. To accomplish this, we will use what we have learned in earlier sections to create a new data connection or use an existing connection. Once we have made our data ...

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