We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
|
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);
};
|
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
