Flexible Solutions, Inc. – GP Reports Viewer
When Excel reports are launched from Dynamics GP using GP Reports Viewer they will use the SQL Login specified on the GP Reports Viewer Setup Options window. When creating reports, it may be easier to simply use ‘sa’ or another admin user login so as to avoid permissions issues.
Select the database and view or table. Note that in the scrolling list views are listed first, then tables. Click Next once you have made your selections:
Click Finish on the Data Connection Wizard window, the file and friendly names do not matter, you can change them if you would like.
On the Import Data window select Table and Existing worksheet, then choose where to start showing the data. You may want to leave a few rows at the top for a report label or logo, click Properties:
On the Usage tab select Refresh data when opening file, this will update the data each time the Excel report is generated.
On the Definition tab, make sure to take the database name out of the Command text. When the window opens it will look like the following: