Options

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.