The requirement can be achieved relatively easy for reports without parameters fetching their AvailableValues from an SqlDataSource, which connection string should be modified dynamically.
In the Report or other Data item (Table, List, etc.) where the connection string is supposed to be changed dynamically introduce a new Binding
The Binding can use the exposed UserIdentity
properties to set the connection string based on the user. For example:
Property path | Expression
DataSource.ConnectionString | = IIF(UserIdentity.Name = "user1", "user1_ConnectionString",
| IIF(UserIdentity.Name = "user2", "user2_ConnectionString",
| IIF(UserIdentity.Name = "user3", "user3_ConnectionString",AND SO ON...)))
Note that DataSource.ConnectionString
property is not listed
in the dropdown and must be typed manually.
The proposed approach cannot be used to modify the Connection String of Report Parameter
-> AvailableValues -> DataSource as report parameters do not expose Bindings.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items