Flexible Solutions, Inc. – GP Reports Viewer
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.
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.
Click OK on the Import Data window.
Enter your SQL credentials on the SQL Server Login window and click OK.
You will now see your data in a table:
Optionally, you can change the formatting of any of the columns and change the design of the table.
Save the Excel file on a network share that your GP users can access.
Set up the Excel report in GP Reports Viewer. Please refer to the Report Maintenance section for
instructions on setting up reports.