Dynamic Data Source

• J-174451

  SSChasing Mays

  Points: 602

  More actions

  August 18, 2005 at 9:50 pm

  #110263

  I want to be able to create one report that I can run, but using mutiple datasources that the I can select which data source to use at run-time.

  I want to run the same query against multiple database servers to compare the reults from time to time.

  Does anyone know how to create such a report or dymanic data source?

  I just worked it out from a previous post - RTFM hey?

  FYI - You can add as many data sources as you like, then ad the data from the different data sources into seperate tables on the report.

  ---

  cheers,

  J
  

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  August 20, 2005 at 11:38 pm

  #583776

  As told in other posts:

  u can use Stored procedure and do anything u want...