Skip to content

Set Connection String Runtime

majorsilence edited this page Nov 14, 2012 · 16 revisions

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 datasource whose connection should be set by the paramter
    • 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.
My-FyiReporting Connection String Runtime Image 1

My-FyiReporting Connection String Runtime Image 2

My-FyiReporting Connection String Runtime Image 3

My-FyiReporting Connection String Runtime Image 4

My-FyiReporting Connection String Runtime Image 5

My-FyiReporting Connection String Runtime Image 6

My-FyiReporting Connection String Runtime Image 7

My-FyiReporting Connection String Runtime Image 8

Clone this wiki locally