Within SmartList Designer a user can send a SmartList through workflow to create a SQL view based on the SmartList query.  This SQL view can then be used outside of GP for such purposes as creating reports using SQL reporting services or Power BI reports in Excel.  The view will also allow the user to publish the SmartList as a refreshable excel report from inside of Dynamics GP.

SmartList Designer Create View

Are you a CAL client interested in installing Microsoft Dynamics GP 2015 R2? Contact us first. CAL Business Solutions 860-485-0910 or support@calszone.com

By CAL Business Solutions, Connecticut Microsoft Dynamics GP Partner, www.calszone.com

Read original post at: http://community.dynamics.com/gp/b/gpteamblog/default.aspx