Hi,
How to Dynamically change the Data Source and Initial Catalog of Connection String in Shared Data Source?
I know that there's limitation that we can't give expression connection string to pass the parameter to Shared Data Source, But we can pass parameter to an expression in a local data source of individual report,
="Data Source=" &Parameters!Server.Value & ";Initial Catalog="&Parameters!Database.Value
or
Passing Connection string itself as a parameter [@ConnectionString] in a local data source of individual report.
By these we can do, But we have to add Data Source in each report,eg : if there's 100's of reports, in each report we should add separate Data Source, instead of this with shared Data Source. . .So kindly let me know how to do this with Shared Data Source
