locked
Dynamic data source settings based on configuration RRS feed

  • Question

  • Hi,

    Is it possible to have the solution/project configuration decide upon the data source settings in a reporting services project in VS? By using different configurations I can have different report server configurations in my project, but I have found no way to dynamically select which data source to use.

    We have two different production environments but with similar database and report server configurations. The same reports will be used on the two report servers but in the report project I have found no way to assoicate different data source settings (e.g. database server name and login credentials) so that I can easily have two different configurations Production_DB01 and Production_DB02 that is deploying the correct data sources as well. Isn't that possible?

    Thanks in advance!
    Best regards
    Lars

    Friday, March 19, 2010 10:35 PM

Answers

  • Hi,

    You can configure dynamic data source through a parameter, like this:

    ="Data Source=" & Parameters! ServerName.Value & "; initial catalog=AdventureWorks"

    Generally, you can achieve dynamic setting if you can write expression for this setting.

    More information, you can refer to the FAQ:

    Question 2: How to combine connecting string via parameter?

     

    Hope this helps,

    Raymond

     

    • Proposed as answer by Suman Sarkar Monday, March 22, 2010 7:13 AM
    • Marked as answer by Lars Lindgren Monday, March 22, 2010 8:32 AM
    Sunday, March 21, 2010 5:23 AM