Flexible Solutions, Inc. – GP Reports Viewer
MODIFYING SSRS REPORTS FOR SERVER AND DATABASE REPLACEMENT [OPTIONAL]
By default SQL Server Reporting Services reports will be run against the server and database name that are set up for the report in the SSRS Report Manager. Typically reports will be set up to use shared data sources. This is a convenient way to set up one or more data sources that many reports can use. If you have multiple Dynamics GP companies, however, this means that you would need to set up multiple shared data sources and reports that reference them for each of your GP companies. Even if you are not using shared data sources and are storing the connection information with the report, you will still need a version of your report for each GP company.
GP Reports Viewer allows you to maintain one copy of a report and pass in the current server and database name at runtime if you set up your report to do this.
To modify a report to take advantage of this feature you will need to add parameters for the SQL Server and Database names and modify any connection strings to reference these new parameters according to the following procedure (the steps below use Microsoft Visual Studio 2010):
Open your report in the Microsoft Visual Studio’s Business Intelligence Development Studio (BIDS).
On the Design tab, in the properties for the report right click Parameters and choose Add Parameter.
Add a text parameter called GPServerName. Your screen should look like the following: