X hits on this document

555 views

0 shares

0 downloads

0 comments

86 / 96

Flexible Solutions, Inc. – GP Reports Viewer

86

TIP

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.

4.

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:

  • 5.

    Click Finish on the Data Connection Wizard window, the file and friendly names do not matter, you can change them if you would like.

  • 6.

    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:

  • 7.

    On the Usage tab select Refresh data when opening file, this will update the data each time the Excel report is generated.

  • 8.

    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:

Document info
Document views555
Page views555
Page last viewedSat Jan 21 22:26:57 UTC 2017
Pages96
Paragraphs1592
Words22003

Comments