Category / Section
Why we do provide SSRS shared/embedded DataSource credential information in LightSwitch HTML ReportViewer?
1 min read
Reporting Service information retrieval limitation
RDL reports have limitations to retrieve a password from the SQL Reporting Service (SSRS) due to security reasons. Therefore, the credentials are provided when the DataSource credentials are saved in the Reporting Server for the shared or embedded DataSources.
The following code provides information on SSRS shared/embedded DataSource credentials.
JS, ASP, LSHTML and ASP.NET MVC
public void OnInitReportOptions(ReportViewerOptions reportOptions)
{
reportOptions.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("datasourcename", "username", "password"));
}
WPF, WinRT and SilverLight
this.ReportViewer.ReportLoaded += (sen, arg) =>
{
List<DataSourceCredentials> crdentials = new List<DataSourceCredentials>();
foreach (var dataSource in ReportViewer.GetDataSources())
{
DataSourceCredentials credn = new DataSourceCredentials();
credn.Name = dataSource.Name;
credn.UserId = " username ";
credn.Password = " password ";
crdentials.Add(credn);
}
this.ReportViewer.SetDataSourceCredentials(crdentials);
};
