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!
In the previous example, we used Visual Studio to modify a canned report. In this example, however, we are going to use the Report Builder to create a new metric from scratch. Report Builder is a component of SSRS that can be used to modify and...