Adding multiple data sources in SSRS report

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  July 22, 2015 at 1:39 pm

  #306005

  Hi All,

  I have a question related to adding multiple data sources in SSRS report. Basically I have 10 reports with embedded Data source pointing to individual servers. All 10 reports are selecting data from same table from their respective servers.

  We are looking to consolidate these 10 reports in one report. Afteall everything is similar between all 10 reports other than each report is querying it's own individual data source. Is there any option to combine all reports into one?

  Thanks.

• pietlinden

  SSC Guru

  Points: 63552

  More actions

  July 22, 2015 at 1:49 pm

  #1814217

  Sorry for the vague response, but I think I remember seeing this in Teo Lachev's SSRS book on SSRS 2008. You can basically build an expression for the datasource and change it under the covers.

  I think this covers it...

  http://stackoverflow.com/questions/19827625/ssrs-report-dynamic-connection-string-and-parameters