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

Deploying new Excel Reports with Excel Report Builder


As with SmartList Builder, Excel Report Builder is another powerful tool in our reporting toolbox. Though many of the same concepts that exist for SmartList Builder hold true for Excel Report Builder, we are not building a new SmartList Object that will be accessed through SmartList. Instead, as we discussed earlier in the chapter, with the deployment of Excel Reports, we are creating our own Excel Reports, Office Data Connections, or both.

The advantage this tool gives us is that we can designate that our resulting report will either be a simple list of data or a PivotTable in Excel. It basically takes out the step of our users needing to first extract the list of data, and then create the PivotTable. Essentially, the user will open the resulting Excel file and be provided with the fields they can select in their PivotTable. They will not be provided with the list of raw data but instead will select their fields in the PivotTable. The...