O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

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

Getting fine grain control of Excel exports from SmartList

In a previous recipe, we looked at how to export SmartLists to Excel with the push of a button. That method creates a new Excel file each time. In many cases users need to export the same set of data on a regular basis and build it into a formatted report via Excel. There's a way to accomplish this with SmartList exports. The feature is called Export Solutions and it's the focus of this recipe.

Getting ready

For our recipe, we'll assume that we have an Account Summary report that we want to format with a title and headers the same way every time. To begin we need to set it up the first time.

  1. Select the SmartList icon from the menu bar at the top or select the Microsoft Dynamics GP menu from ...

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