)
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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Why do you have to provide SSRS shared/embedded DataSource credential information?

Platform: LightSwitch HTML |
Control: ReportViewer |
Published Date: October 21, 2015 |
Last Revised Date: May 23, 2019

 

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);
                    };

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon 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.Close Icon

Live Chat Icon For mobile
Live Chat Icon