Changing Shared data source connection based on input Parameter value

• dudekula.kareemulla

  Ten Centuries

  Points: 1039

  More actions

  September 2, 2015 at 7:13 am

  #304034

  Hello Frnds,

  I created two shared datasources like Conn1 and conn2,but i created some SSRS reports using Conn1 shared data source connection.

  Actually in my environment for every two years(like 2013-2015,2015-2017) data we are storing in seperate databases.In my reports one input parameter like @Year=(2011-2013/2013-2015/2015-2017) drop down list is there.But here if i send @Year=2011-2013 means i want to connect Conn1 shared datasource connection but if i pass 2013-2015 means i want to connect conn2 shared datasource connection and generate report.

  So please help me out from this.

  Thanks&regards,

  Kareemulla Dudekula