Parameter driven data connections

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

Paging in Business Intelligent Reports

I have finally been able to create a simple master detail report of the records in the database. Is there any way to create a new page after each record, or to keep a record all together on the same page? It took me two days to get SQL Express installed properly so I could get this simple report. They don't make it easy.

Any help would be appreciated.

Thanks
CalI'd be interested in hearing how you got BIDS to run. I'm still not able to use it. No devenv.exe file!!!!!!!!!!!!|||Well, it wasn't easy. I had installed to Sql Server included with Visual Basic Express. I then downloaded and installed the SQL Express Editon with Advanced Services. I then installed the SQL Express Edition Toolkit SP1. I did this twice before it worked. I hope this helps.

Cal|||I have installed the tool kit twice but still no devenv.exe. I haven't tried to re-nstall 2005 express advanced yet.|||

I'm going to move this question to the RS forum, they'll have specific advice about writting reports.

(we're working on the BIDS install issue in several other threads)

Mike