Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pjnovak007
Starting Member
19 Posts |
 Posted - 2010-08-11 : 08:19:24
|
| Does anyone know how to setup a parameter to select a certain DB?Example: I have a report that I have designed to access a DB named Atlanta_RMS. I want to use the same report but access a DB on that same server named Dallas_RMS. Can i use a parameter in the report to access Dallas_RMS?If so does anyone know a link to a white paper to do so?Patrick |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-11 : 10:25:19
|
| isnt it matter of creating separate datasets to pull data from both dbs and using parameter display them selectively?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Reporting Services and access to dif Db's