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 |
|
Bob Crystal
Starting Member
3 Posts |
 Posted - 2009-07-17 : 12:40:00
|
| Would you be able to pass the database name to a report and based on the database name, this would be used to show that particular tables from that database passed? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-17 : 14:15:19
|
| you can do that with help of dynamic query but why do it this way?why is database dynamic in your case? |
 |
|
|
Bob Crystal
Starting Member
3 Posts |
Posted - 2009-07-17 : 15:26:30
|
| We have various product groups, each group is housed in a different Database. Some customers sell more than one product group. So for their reports, they could tell the Report which database to select from. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-18 : 01:46:01
|
quote:
Originally posted by Bob Crystal
We have various product groups, each group is housed in a different Database. Some customers sell more than one product group. So for their reports, they could tell the Report which database to select from.
are you asking about database engine as such or report server? |
|
|
|
Bob Crystal
Starting Member
3 Posts |
Posted - 2009-07-20 : 15:50:21
|
| Yes report server is in use for the reports. |
|
|
|
|
|
|
Passing the database to Conectivity