X hits on this document

340 views

0 shares

0 downloads

0 comments

87 / 96

Flexible Solutions, Inc. – GP Reports Viewer

87

Change this to only have the table or view name:

Taking out the database name is critical to allow GP Reports Viewer to be able to switch the company database that the report is generated.

9.

You will get a pop-up warning that the connection in this workbook is no longer identical to the connection defined in the external file and asking if you want to proceed with changes. Click Yes.

  • 10.

    Click OK on the Import Data window.

  • 11.

    Enter your SQL credentials on the SQL Server Login window and click OK.

  • 12.

    You will now see your data in a table:

  • 13.

    Optionally, you can change the formatting of any of the columns and change the design of the table.

  • 14.

    Save the Excel file on a network share that your GP users can access.

  • 15.

    Set up the Excel report in GP Reports Viewer. Please refer to the Report Maintenance section for

instructions on setting up reports.

Document info
Document views340
Page views340
Page last viewedSat Dec 10 15:14:07 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments