Repository navigation
Set Connection String Runtime
Using a dynamic connection string in My-FyiReporting is easy and simple but it does require a few steps.
The following will describe the steps necessary to dynamically set the connection strings. Examine the screenshots below for more details.
- Open the report in the designer
- In the properties panel make sure "Report" is selected
- Find the "Parameters" and click the "..." load button
- In the parameter window that opens click "Add"
- Enter a name
- If you want to prompt the user with the builtin prompt enter a prompt
- Set the datatype to "String"
- Click OK
- Back in the main designer go to the menu Data -> Data Sources
- Select the data source whose connection should be set by the parameter
- Either clear out the connection string and type in the parameter or
- Click the "fx" button
- Clear the connection string
- Find the Parameter under the available parameter and add it by selecting it and clicking the ">>" button
- Click OK
- If satisfied with the connection string click OK
The first thing that needs to be done is open the report in the designer. In the properties panel make sure "Report" is selected. Find the "Parameters" and click the "..." load button

In the parameter window that opens click "Add". Enter a name. If you want to prompt the user with the builtin prompt enter a prompt. Set the datatype to "String". Click OK.

Back in the main designer go to the menu Data -> Data Sources

Select the data source whose connection should be set by the parameter. Either clear out the connection string and type in the parameter. Or you can Click the "fx" button, clear the connection string, and find the Parameter under the available parameter and add it by selecting it and clicking the ">>" button. Click OK.

If satisfied with the connection string click OK



