X hits on this document

342 views

0 shares

0 downloads

0 comments

88 / 96

Flexible Solutions, Inc. – GP Reports Viewer

88

USING A SQL SERVER STORED PROCEDURE

To create an Excel report based on a SQL Server stored procedure:

  • 1.

    Open a new Excel file and navigate to the Data tab.

  • 2.

    Select From Other Sources and choose From Microsoft Query.

  • 3.

    Select an existing Data Source or create a new one, click OK.

  • 4.

    Enter your login credentials, then click OK.

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.

  • 5.

    On the Query Wizard – Choose Columns window, click Cancel.

  • 6.

    You will see a pop-up asking if you want to continue editing this query in Microsoft Query, choose Yes.

  • 7.

    Click Close on the Add Tables window.

  • 8.

    Click the SQL button on the Microsoft Query window:

9.

Enter your stored procedure and parameters using the following syntax: {call YourStoredProcedureName (?, ?)} For example, with one parameter you would have one question mark:

If your stored procedure has multiple parameters, separate them with a comma:

Document info
Document views342
Page views342
Page last viewedSat Dec 10 19:12:33 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments