Creating a connection string parameter for an SSRS report

Before you can connect properly to a data source, you must have an appropriate Connection String parameter defined. This parameter should be defined as a “hidden” parameter.

To define this connection string parameter:

  1. In Visual Studio 2008, in the Report Data panel, right-click Parameters and select Add Parameter.
  2. In the Report Parameter Properties dialog box, specify these values:
    • Name: pConnectionStringIDO
    • Prompt: pConnectionStringIDO
    • Allow null values: Cleared
    • Select parameter visibility: Hidden
    • Default Values tab, Specify values: Add a default connection string using this format:

      ConfigServerURL;ConfigName

      where:

      • ConfigServerURL is the standard URL-formatted path to the configuration server’s default page (for example, http://MyServer/IDORequestService/ConfigServer.aspx)
      • ConfigName is the name of the configuration to which you want to connect (for example, MyMongoose)
      Note: Take special notice of the semicolon between the URL and the configuration name.