Post reply

Using Report Server to run reports from Multiple databases

  • February 2, 2011 at 9:12 am

    #231025

    All,

    Is it possible to use 1 report server to generate reports from multiple databases across multiple servers? Or should I try to load all the databases in one location via SSAS and then report from SSAS?

    All the databases have SAME exact structure but different data of course...

    Thanks...Michelle

  • February 2, 2011 at 9:58 am

    #1281536

    Michelle-164472 (2/2/2011)

    All,

    Is it possible to use 1 report server to generate reports from multiple databases across multiple servers?

    Absolutely. In fact, this is one of the core parts of SSRS's architecture. You can have reports that point to any number of different data sources.

    However, if you need to join/manipulate data across different data sources within the same reports then moving the data to a common location would make sense.

  • February 2, 2011 at 10:02 am

    #1281538

    Great thanks :hehe:

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

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