X hits on this document

527 views

0 shares

0 downloads

0 comments

59 / 96

Flexible Solutions, Inc. – GP Reports Viewer

59

5.

Right click on Parameters and choose Add Parameter and add another text parameter called GPDBName.

  • 6.

    Click OK.

  • 7.

    Modify your Data Sources to use expressions that point to the two new parameters: Right click on the name of the Data Source and choose Data Source Properties. The details for the Data Source will be shown:

Modify the Connection string to use the following syntax instead: ="Data Source=" + Parameters!GPServerName.Value + ";Initial Catalog=" + Parameters!GPDBName.Value

Click OK.

Repeat this step for each Data Source in your report that will need to have the Server and Database name replaced at report runtime.

8.

On the Preview tab, test your report by setting these two new parameter values to a valid SQL Server/Database name combination and clicking View Report:

Document info
Document views527
Page views527
Page last viewedThu Jan 19 20:13:45 UTC 2017
Pages96
Paragraphs1592
Words22003

Comments