If @DataSourceName = 'DataSource1'

select [Server] + ' ;Initial Catalog='+[Database] as 'Server'

from DBA.dbo.Report_Connection

where ID = 108

Your select will return this: INFHO-SRV-FMSC ;Initial Catalog=DBname

@DataSource is a parameter in the report with Values,...

Hi,

I had the same problem in 2005 and now in 2008 as well. The thing is, we have over 200 datasources and I can't re-enter them every single time. The...