Tuesday, May 22, 2007

Use dynamic datasource in SSRS

In some cases you will need to use different datasourse (ex: connection string) in the same report.

Do SSRS support dynamic datasourse?
The answer is YES
CHK this MSDN article it is very usefull (specially "Data Source Expressions" section)
http://msdn2.microsoft.com/en-us/library/ms156450.aspx
and remember don't use shared datasource(it will not work)

No comments: