Articles in this section
Category / Section

Why do you have to provide SSRS shared/embedded DataSource credential information n WPF 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);
                    };

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied