I would like to use the same report for different business units and each
business unit has their own SQL server db (for security reasons).
I would like to have a Business Unit parameter that would change the
connection to the appropriate database. Any suggestions on how to do this?
Is it even possible?
TIA
DeanI have found the answer to my own question, for others that may be
interested see ths 2005 BOL at
http://msdn2.microsoft.com/en-us/library/ms156450.aspx
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:%23MDFCA8zHHA.5948@.TK2MSFTNGP03.phx.gbl...
>I would like to use the same report for different business units and each
>business unit has their own SQL server db (for security reasons).
> I would like to have a Business Unit parameter that would change the
> connection to the appropriate database. Any suggestions on how to do this?
> Is it even possible?
> TIA
> Dean
>sql
No comments:
Post a Comment