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 a new reporting metric via Report Builder

Earlier in this chapter, we discussed the deployment of pre-defined Charts and KPIs that can then be made visible on the GP 2010 Homepage. In this section, we'll take a look at creating a metric that shows us the top ten items on un-posted sales orders by extended price. A metric of this sort can give members of our organization insight into which items are generating the most sales at the moment. As the data source for this metric, we'll use one of the SQL views that is generated in each GP company database by the predefined Excel Reports deployment that was covered in Chapter 3 of this book: dbo.SalesLineItems. Remember, SSRS metrics are only available for GP 2010 and SQL Server 2008 environments! ...

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