Post reply

Dynamical use of Data Source in one Report

  • August 17, 2006 at 12:38 am

    #173898

    Hy.

    I'm working with SQL Server 2005 Reporting Services.

    I have made a report which should use different Data Sources to connect to different SQL Servers where data is stored. Is it possible to dynamicly choose which Data Source to use from a parameter which comes from preceding report. Or is the only way to make the same report for every SQL Server.

    Thanks for an answer or a hint where to read more about this.

    Tomaz

  • August 22, 2006 at 12:59 am

    #656056

    Hay!

    It seems that it's not possible. Or ....??

    I made a workaround. Created linked servers (I hate them). In a report I call a stored procedure with a parameter which is the name of linked server. In stored procedue I dinamicly create a select statement and execute it.

    Tomaz

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

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