Post reply

Reporting Services redirection

  • July 2, 2008 at 6:52 am

    #193407

    Hello

    I am currently trying to see if there is any way of redirecting a report to use different datasources based on the user. For example I have 2 databases with the same schema but containing different data, based on which user accesses the report I want a different datasource to be used by that report, can anyone help with this, I thought there maybe a dataset/datasource property somewhere that I could set as an expression to pick up a global parameter?

    Any input on this would be much appreciated.

    Thanks

    Caralyn

  • July 2, 2008 at 9:14 am

    #837299

    You can dynamically change connection strings.

    http://www.sqlservercentral.com/articles/Development/2945/%5B/url%5D

    If you are using NT authentication, you should be able to build a data source based on the current user.

  • July 2, 2008 at 9:36 am

    #837307

    Hi Michael

    Perfect thats exactly what I am looking for!

    Thanks

    Caralyn 😀

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

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