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.

Running SSRS + authentication...

Thread ID:

Created:

Updated:

Platform:

Replies:

125685 Sep 2,2016 05:53 AM Sep 15,2016 01:32 AM LightSwitch Silverlight 6
loading
Tags: ReportViewer
Tom
Asked On September 2, 2016 05:53 AM

Good Afternoon,

I am trying to use your Report Viewer control for desktop client and I cannot run the report which sits on a remote server. I have read few other threads about SSRS here and I know that this is not officially supported. However I have found this:
"[...] adding Silverlight ReportViewer as  custom control in LightSwitch screen allows you to render SSRS reports in Lightswitch platform."

One of the samples I've found contains this code:

using System;

using System.Linq;

using System.IO;

using System.IO.IsolatedStorage;

using System.Collections.Generic;

using Microsoft.LightSwitch;

using Microsoft.LightSwitch.Framework.Client;

using Microsoft.LightSwitch.Presentation;

using Microsoft.LightSwitch.Presentation.Extensions;

using Syncfusion.Windows.Reports.Viewer;

using Syncfusion.Windows.Reports;

namespace LightSwitchApplication

{

public partial class SLReport

{

partial void SLReport_Activated()

{

this.FindControl("ScreenContent").ControlAvailable += SLReport_ControlAvailable;

}

void SLReport_ControlAvailable(object sender, ControlAvailableEventArgs e)

{

ReportViewer viewer = e.Control as ReportViewer;

//Sets the report path

viewer.ReportPath = "/Report Project1/InvoiceParameterReport";

//Sets the report server Url

viewer.ReportServerUrl = "http://76.74.153.81/ReportServer";

//Sets the report service URL

viewer.ReportServiceURL = "/ReportingService.svc";

//viewer.ReportServiceURL = "http://localhost:50073/ReportingService.svc";

//Sets the processing mode

viewer.ProcessingMode = ProcessingMode.Remote;

//Sets the report server credential

viewer.ReportServerCredential = new System.Net.NetworkCredential("ssrs", "RDLReport1");

//Refresh the report

viewer.RefreshReport();

viewer.ReportLoaded += (Sender, arg) =>

{

//Sets the data source credentials

var crdentials = new List<DataSourceCredentials>();

foreach (var datasource in viewer.GetDataSources())

{

var credn = new DataSourceCredentials();

credn.Name = datasource.Name;

credn.UserId = "ssrs1";

credn.Password = "RDLReport1";

crdentials.Add(credn);

}

viewer.SetDataSourceCredentials(crdentials);

//Sets the default parameter

List<ReportParameter> parameters = new List<ReportParameter>();

ReportParameter param = new ReportParameter();

param.Labels.Add("10251");

param.Values.Add("10251");

param.Name = "InvoiceID";

parameters.Add(param);

viewer.SetParameters(parameters);

};

}

}

}



This gave me hope, but for some reason I still cannot make it to work. Is the following required for it to work properly?

viewer.ReportServiceURL = "/ReportingService.svc


There is also

viewer.ReportPath = "/Report Project1/InvoiceParameterReport"

Does the same path need to be included in Properties of the control as well?


As pictures are worth more than 1000 words, I was wondering if you would be so kind and record short video showing how you configure the project in Visual Studio 2013 for remote SSRS reports with authentication from start to finish, please? I have talked to few people and they couldn't work this out either, hence having visual instructions would be really helpful.

Thank you very much in advance for your help and support in this matter.


Kind regards,

Tom


Tom
Replied On September 2, 2016 06:32 AM

Good Afternoon,

I am trying to use your Report Viewer control for desktop client and I cannot run the report which sits on a remote server. I have read few other threads about SSRS here and I know that this is not officially supported. However I have found this:
"[...] adding Silverlight ReportViewer as  custom control in LightSwitch screen allows you to render SSRS reports in Lightswitch platform."

One of the samples I've found contains this code:

using System;

using System.Linq;

using System.IO;

using System.IO.IsolatedStorage;

using System.Collections.Generic;

using Microsoft.LightSwitch;

using Microsoft.LightSwitch.Framework.Client;

using Microsoft.LightSwitch.Presentation;

using Microsoft.LightSwitch.Presentation.Extensions;

using Syncfusion.Windows.Reports.Viewer;

using Syncfusion.Windows.Reports;

namespace LightSwitchApplication

{

public partial class SLReport

{

partial void SLReport_Activated()

{

this.FindControl("ScreenContent").ControlAvailable += SLReport_ControlAvailable;

}

void SLReport_ControlAvailable(object sender, ControlAvailableEventArgs e)

{

ReportViewer viewer = e.Control as ReportViewer;

//Sets the report path

viewer.ReportPath = "/Report Project1/InvoiceParameterReport";

//Sets the report server Url

viewer.ReportServerUrl = "http://76.74.153.81/ReportServer";

//Sets the report service URL

viewer.ReportServiceURL = "/ReportingService.svc";

//viewer.ReportServiceURL = "http://localhost:50073/ReportingService.svc";

//Sets the processing mode

viewer.ProcessingMode = ProcessingMode.Remote;

//Sets the report server credential

viewer.ReportServerCredential = new System.Net.NetworkCredential("ssrs", "RDLReport1");

//Refresh the report

viewer.RefreshReport();

viewer.ReportLoaded += (Sender, arg) =>

{

//Sets the data source credentials

var crdentials = new List<DataSourceCredentials>();

foreach (var datasource in viewer.GetDataSources())

{

var credn = new DataSourceCredentials();

credn.Name = datasource.Name;

credn.UserId = "ssrs1";

credn.Password = "RDLReport1";

crdentials.Add(credn);

}

viewer.SetDataSourceCredentials(crdentials);

//Sets the default parameter

List<ReportParameter> parameters = new List<ReportParameter>();

ReportParameter param = new ReportParameter();

param.Labels.Add("10251");

param.Values.Add("10251");

param.Name = "InvoiceID";

parameters.Add(param);

viewer.SetParameters(parameters);

};

}

}

}



This gave me hope, but for some reason I still cannot make it to work. Is the following required for it to work properly?

viewer.ReportServiceURL = "/ReportingService.svc


There is also

viewer.ReportPath = "/Report Project1/InvoiceParameterReport"

Does the same path need to be included in Properties of the control as well?


As pictures are worth more than 1000 words, I was wondering if you would be so kind and record short video showing how you configure the project in Visual Studio 2013 for remote SSRS reports with authentication from start to finish, please? I have talked to few people and they couldn't work this out either, hence having visual instructions would be really helpful.

Thank you very much in advance for your help and support in this matter.


Kind regards,

Tom


In addition to my first post, could you please tell me where I can find Syncfusion.Reports.Server assembly? I'm trying to add WCF, but it is missing from all Assemblies folder etc.

Thanks,

Kind regards,
Tom 

Vinoth Srinivasan [Syncfusion]
Replied On September 5, 2016 06:31 AM

  
Thanks for contacting Syncfusion support. 
  
Query 
Response 
I am trying to use your Report Viewer control for desktop client and I cannot run the report which sits on a remote server. I have read few other threads about SSRS here and I know that this is not officially supported. However I have found this: 
"[...] adding Silverlight ReportViewer as  custom control in LightSwitch screen allows you to render SSRS reports in Lightswitch platform." 
  
Our LightSwitch Silverlight ReportViewer extension didn’t have support to Load/View SSRS RDL reports. But we can achieve this by using Silverlight ReportViewer as custom control inside lightswitch screen. We have prepared a sample for you reference and it can be downloaded from below location. 
  
  
We have prepared a document to create Report Viewer Lightswitch Silverlight application and it can be downloaded from the following location. 
  
This gave me hope, but for some reason I still cannot make it to work. Is the following required for it to work properly? 
viewer.ReportServiceURL = "/ReportingService.svc 
There is also 
viewer.ReportPath = "/Report Project1/InvoiceParameterReport" 
Does the same path need to be included in Properties of the control as well? 
  
  
Kindly refer the below table for more details on Reportviewer properties. 
  
                        Property 
Description 
ReportServiceURL 
You have to specify the ServiceURL to access the ReportServer . In our shared sample we have given the sample with WCF Reporting service embedded in application. Set the WCF service URL to the ReportServiceURL property as shown below.
ReportViewer.ReportServiceURL="/ReportingService.svc";
//viewer.ReportServiceURL="
http://ssrs.syncfusion.com/ReportingService/ReportingService.svc"; 
Kindly refer the below link for creating a WCF service. 
  
  
In addition to my first post, could you please tell me where I can find Syncfusion.Reports.Server assembly? I'm trying to add WCF, but it is missing from all Assemblies folder etc. 
You can find the “Syncfusion.Reports.Server” assembly from following installed location of our Essential Studio. 
  
C:\Program Files (x86)\Syncfusion\Essential Studio\14.1.0.41(Product Version)\Assemblies\4.0. 
  
Regards, 
Vinoth S. 
 


Tom
Replied On September 5, 2016 11:31 AM

  
Thanks for contacting Syncfusion support. 
  
Query 
Response 
I am trying to use your Report Viewer control for desktop client and I cannot run the report which sits on a remote server. I have read few other threads about SSRS here and I know that this is not officially supported. However I have found this: 
"[...] adding Silverlight ReportViewer as  custom control in LightSwitch screen allows you to render SSRS reports in Lightswitch platform." 
  
Our LightSwitch Silverlight ReportViewer extension didn’t have support to Load/View SSRS RDL reports. But we can achieve this by using Silverlight ReportViewer as custom control inside lightswitch screen. We have prepared a sample for you reference and it can be downloaded from below location. 
  
  
We have prepared a document to create Report Viewer Lightswitch Silverlight application and it can be downloaded from the following location. 
  
This gave me hope, but for some reason I still cannot make it to work. Is the following required for it to work properly? 
viewer.ReportServiceURL = "/ReportingService.svc 
There is also 
viewer.ReportPath = "/Report Project1/InvoiceParameterReport" 
Does the same path need to be included in Properties of the control as well? 
  
  
Kindly refer the below table for more details on Reportviewer properties. 
  
                        Property 
Description 
ReportServiceURL 
You have to specify the ServiceURL to access the ReportServer . In our shared sample we have given the sample with WCF Reporting service embedded in application. Set the WCF service URL to the ReportServiceURL property as shown below.
ReportViewer.ReportServiceURL="/ReportingService.svc";
//viewer.ReportServiceURL="
http://ssrs.syncfusion.com/ReportingService/ReportingService.svc"; 
Kindly refer the below link for creating a WCF service. 
  
  
In addition to my first post, could you please tell me where I can find Syncfusion.Reports.Server assembly? I'm trying to add WCF, but it is missing from all Assemblies folder etc. 
You can find the “Syncfusion.Reports.Server” assembly from following installed location of our Essential Studio. 
  
C:\Program Files (x86)\Syncfusion\Essential Studio\14.1.0.41(Product Version)\Assemblies\4.0. 
  
Regards, 
Vinoth S. 
 


Hi Vinoth,

Thank you very much for your reply and detailed instructions. That is all very useful, but I'm still having problems with finding Syncfusion.Reports.Server assembly. Please have a look at the file attached. It is simply not there for some reason. Any ideas would be appreciated.

Thank you very much in advance,

Kind regards,
Tom

Attachment: MissingAssemblies_fe58585f.zip

Vinoth Srinivasan [Syncfusion]
Replied On September 6, 2016 06:48 AM

Hi Tomasz, 
 
We have shared the “Syncfusion.Reports.Server” assembly in both versions (14.1.0.41 and 14.2.0.26), and it can be downloaded from the below location. Please replace the assemblies to your required location. 
 
 
Regards, 
Vinoth S. 


Tom
Replied On September 14, 2016 03:56 AM

Hi Tomasz, 
 
We have shared the “Syncfusion.Reports.Server” assembly in both versions (14.1.0.41 and 14.2.0.26), and it can be downloaded from the below location. Please replace the assemblies to your required location. 
 
 
Regards, 
Vinoth S. 


Hi Vinoth,

Thank you very much for your help. I'm going to try it later this week and will report back in case of any problems.

Thanks once more,

Regards,
Tom

Vinoth Srinivasan [Syncfusion]
Replied On September 15, 2016 01:32 AM

Hi Tomasz, 
 
Thanks for your update. We will wait until we hear from you. 
 
Regards, 
Vinoth S. 


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.

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.

;