Resetting the data source connection string

In an earlier procedure of the process, you should have changed the "connection string" for the data source to a hard-coded value for testing purposes. Before you can run the report successfully, though, you must reset the connection string back to its original value.

To reset the data source connection string:

  1. In Visual Studio, locate and double-click the name of your data source.
  2. In the Data Source Properties dialog box, General tab, change the hard-coded value in the Connection string field to:
    • [@pConnectionString] for a report based on a stored procedure
    • [@pConnectionStringIDO] for a report based on an IDO

    You can use the Expression Editor to do this.

  3. Select the Credentials tab and then select the Prompt for credentials option.
  4. In the Enter prompt text field, enter some text to use as a prompt.
    Note: This text never really displays anywhere in our system, but without something in this field, Visual Studio does not let you save your changes to the data source.