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.
Are you a CAL client interested in installing Microsoft Dynamics GP 2015 R2? Contact us first. CAL Business Solutions 860-485-0910 or email@example.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