Post reply

DYnamic Datasouces

  • July 24, 2012 at 8:04 am

    #392818

    We are using SQL 2008 ... I have 1 report that I want to deploy for mulitple clients.

    How can I publish the report once to SSRS and dynamically change the datasource based on client.

    I am going to need to pass in the login credentials to the datasource.

    So I thought if I created multiple datasources on SSRS then I could somehow pass in which one the report should used based on a parameter.

    But I can't figure it out.

  • July 25, 2012 at 5:04 am

    #1517276

    Hi Carol,

    I don't think you can change the datasource based on a parameter. You can create linked reports on the report server & change the datasource for each one though. If you've got loads of reports then you may need to look into deploying reports via a script using Rs.exe

    Cheers

    Gaz

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply