Book Image

Microsoft Dynamics GP 2013 Reporting

Book Image

Microsoft Dynamics GP 2013 Reporting

Overview of this book

Table of Contents (21 chapters)
Microsoft Dynamics GP 2013 Reporting
Credits
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Index

Creating a new reporting metric via Report Builder


Earlier in this chapter, we discussed the deployment of predefined charts and KPIs that can then be made visible on the GP 2013 Homepage in Business Analyzer. In this section, we'll take a look at creating a metric that shows us the top ten items on unposted 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, Working with the Builders – SmartList and Excel Reports, of this book: dbo.SalesLineItems. Remember, SSRS metrics are only available for GP 2010 and later, and SQL Server 2008 and later environments!

In the previous example, we used Visual Studio to modify a default report. In this example, however, we are going to use Report Builder to create...