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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Using SSRS

Thread ID:

Created:

Updated:

Platform:

Replies:

117972 Jan 15,2015 05:08 AM UTC Jun 18,2015 01:39 PM UTC LightSwitch Silverlight 3
loading
Tags: ReportViewer
Johann Alexander Quintero Cortes
Asked On January 15, 2015 05:08 AM UTC

Hello,

I'm trying to configure the ReportViewer to display .rdl files that my users will create and upload on a SSRS server, so in my application I had stored in a table the report's names and paths on the server. I'm trying to show the report from the SSRS but I can't find where I can set the SSRS credentials, the SSRS URL and how to configure the ReportViewer to show the reports.

How can I do this? do you have any examples of using the ReportViewer with SSRS?

Thanks.

Anandakumar S [Syncfusion]
Replied On January 15, 2015 05:20 PM UTC

Hi Johann,

Thanks for your interest Syncfusion Products.

As of now, rendering SSRS reports not supported in Lightswitch ReportViewer. We have considered this as feature request “Support to view SSRS reports in lightswitch ReportViewer”, however to access this, we request you contact us at Syncfusion Support or you may also create your customer account under Direct Trac and open a new incident so that our support engineer will assist you accordingly.

Our Direct Trac support system can be accessed from the following link:

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

However adding Silverlight ReportViewer as  custom control in LightSwitch screen allows you to render SSRS reports in Lightswitch platform. We have prepared a sample based on this and it can be downloaded from the following location.

http://www.syncfusion.com/downloads/support/directtrac/129745/SSRSLSReportViewer1600270045.zip

We have given details of the properties used to render SSRS reports in ReportViewer.

Property

Usage

ReportPath

Path to the Server report in SSRS server.
reportViewer.ReportPath = @"/SSRSSamples/Territory Sales";

ReportServerUrl

URL path of the ReportingServer.
reportViewer.ReportServerUrl = @"http://76.74.153.81/ReportServer";

ReportServiceURL

URL path of the WCF ReportingService which is running on the server machine (ReportingService and ReportServer must run in same machine).
reportViewer.ReportServiceURL = @"http://ssrs.syncfusion.com/ReportingService2013Vol4/ReportingService.svc";
Please refer the following link to create a ReportingService.
http://help.syncfusion.com/ug/silverlight/default.htm#!documents/loadingssrsreportinr.htm

ProcessingMode

Gets or sets the processing mode of the ReportViewer control. Set Remote ProcessingMode for rendering SSRS reports.
reportViewer.ProcessingMode = ProcessingMode.Remote;

ReportServerCredential

Credential information’s to connect with the ReportingServer.
reportViewer.ReportServerCredential = new System.Net.NetworkCredential("ssrs""RDLReport1");

Set DataSource Credentials

You can specify credential information to each datasources used within the report in loaded event of ReportViewer as shown below.
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 = "ssrs1";
        credn.Password = "RDLReport1";
        crdentials.Add(credn);
    }
 
    reportViewer.SetDataSourceCredentials(crdentials);
};
Note: DataSource credentials must be added to the ReportViewer for Shared DataSources which do not have credentials in the connection string and used in the SSRS Reports.

Please let us know if you have any questions.

Regards,

Anandakumar S



Victor Perez
Replied On June 17, 2015 11:24 AM UTC

hi

this feature was added to the component to lightswitch?

Silverlight supports the reportviewer for SSRS with custom authentication?
the reportviewer for silverlight support the function "go to report"?

Victor Perez

Nithya B [Syncfusion]
Replied On June 18, 2015 01:39 PM UTC

Hi Victor,

Thanks for your update.

Query
Response
Silverlight supports the reportviewer for SSRS with custom authentication?
Kindly refer our online UG documentation for more details about supported authentication in ReportViewer.
http://help.syncfusion.com/ug/silverlight/index.html#!Documents/canweuseazuressrsreportsinreportviewer.htm


the reportviewer for silverlight support the function "go to report"?
Our Silverlight ReportViewer have  “DrillThrough” action supports in SSRS reports. Kindly refer the below link to create a report with “DrillThrough” action.
https://msdn.microsoft.com/en-us/library/ff519554.aspx

Please let us know if you have any questions.

Regards,
Nithya B


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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

;