Flexible Solutions, Inc. – GP Reports Viewer
11. If you do not wish to set up windows integrated security for your SSRS reports and do not want to have the user prompted for login credentials each time they run the report, you can click on the Data Sources link and set up a login to save with the report and then click the Apply button:
12. If you now try to run the report in the Report Manager, you should receive the following error message:
This is expected because the parameters will be sent to the report at runtime when your report is launched from Dynamics GP with GP Reports Viewer.
13. The report is now ready to be set up in Dynamics GP on the Report Maintenance window.
You may want to group reports that are set up in this manner with Server and Database name replacement into a single folder in SSRS called GP Reports Viewer to keep these separate from other SSRS reports that are intended to be run from the SSRS Report Manager interface.