One approach is to create your own data access layer, where connection strings are decrypted and used to retrieve data based on permissions and other custom requirements. This layer with custom object can be used in report via ObjectDataSource
component. With this approach you can save further modifications on reports.
The other approach is to work with the selected report instance and its Items collection. Each item can be accessed
from the report instance and modified e.g:
(report.DataSource, Telerik.Reporting.SqlDataSource).ConnectionString = NewString()
'get inner data item to change its data source as well
)(0), Telerik.Reporting.Table).DataSource = GetNewData()
'get sub report
'check the report definition to determine what is the used report source type for the SubReport item
subreportReport.DataSource = GetData()
I hope this information helps you.
New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.