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.