In this chapter, we introduced the first four tools in our reporting toolbox: SmartList for easy-on-demand ad-hoc reporting, SmartList Builder for times when the default SmartLists just don't cut it and we need to build our own SmartList Objects, Excel Reports for viewing SmartList like data in Excel, and Excel Report Builder for when we want to extend the concept of SmartList Builder into Excel and build our own refreshable Excel Reports and/or Office Data Connections.

We began with the basic structure of each tool and what it does and ended with some real life, step-by-step examples of how to use the builder tools. Finally, we looked at some tips and tricks when using the SmartList Builder and Excel Report Builder tools.

In the next chapter, we will dive into Report Writer, which has been the backbone of reporting in Dynamics GP for many years. We'll begin by understanding what Report Writer is, before looking at using the tool to customize reports. We will then explore the Word...