Multiple Databases accessed by Multiple reports by Multiple users...?

Multiple Databases accessed by Multiple reports by Multiple users...?

Post by mag » Sat, 21 Jan 2006 04:54:36


Hello All,
I am somewhat new to MS Reporting Services and I've got a situation
where I have different users needing to access the same report (rdl)
but from different databases?
Ideally I would want to have each report pointing to all databases
dynamically.

Do you know how I would go about setting this up? Multiple reports
pointing to different datasources? Passing a parameter which
determines a specific datasource? - Is it even possible to pass a
parameter to the report to determine which data source to use?

Thanks for your help in advance
Mag
 
 
 

Multiple Databases accessed by Multiple reports by Multiple users...?

Post by Bruce L-C » Sat, 21 Jan 2006 05:30:55

Are you using RS 2000 or RS 2005? In RS 2005 you can use data source
expressions (search books online under expressions, data sources). If RS
2000 it is much harder and a total pain and I strongly suggest going to RS
2005.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services