Post reply

Adding multiple data sources in SSRS report

  • 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.

  • 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

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

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