DYnamic Datasouces

• Carol Adams

  SSCrazy

  Points: 2320

  More actions

  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.

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  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