Reportviewer is working when running lightswitch in developers machine, in localhost. When published to the server the control does not work. | This error may occur due to invalid reportpath set to ReportViewer. We are requesting you to ensure the provided reportpath location. |
Where should the ReportTemplate folder be located on the server? | If want to store your RDL report in SSRS server, then you can manually create a folder and save your ReportDefinition. If your requirement is to save your report in Server project then you can place under any folder and mention the reportpath to ReportViewer. |
What is the ReportPath that should be used? | If you want to use local RDLC report then you have to set as show below (ApplicationName.Folder.NameOftheReport). LightSwitchApplication.ReportTemplate.GroupingAggReport.rdlc You can find our locally installed sample from the following location. Syncfusion\LightSwitch\$version$\SL\ReportViewer\ If its SSRS server report then you have to specify relative path to the report located on ReportServer as shown in the below(/FolderName/ReportName). ReportViewer.ReportPath="/ReportProject/InvoiceParameterReport"; |
What are the properties that should be used for the rdlc file? Embedded or content? Copy Always, etc? | You have to set “Build Action” property as “Embedded Resource” to load the report in Light switch Silverlight ReportViewer. |
Appreciate any help as the online documentation is very poor. | We have already created task for updating our ReportViewer Online UG documentation. We will let you know once our Online UG documentation updated successfully. |
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.
http://www.syncfusion.com/downloads/support/directtrac/137062/LSReportDemo-1370621038977318.zip
Kindly refer the below table for more details on Reportviewer properties.
Property | Description |
ProcessingMode | Set ProcessingMode property to Remote for SSRS/RDL reports as shown in below code. //Setstheprocessingmode ReportViewer.ProcessingMode=ProcessingMode.Remote; |
ReportServerUrl | Gets or sets the URL for the report server as shown in below. Please make sure that the server URL is accessible. //SetsthereportserverUrl ReportViewer.ReportServerUrl="http://76.74.153.81/ReportServer"; |
ReportServerCredential | Gets or sets the credentials to be used with the report server. //Setsthereportservercredential ReportViewer.ReportServerCredential=newSystem.Net.NetworkCredential("ssrs","RDLReport1"); |
ReportServiceURL | You have to specify the ServiceURL to access the ReportServer . In our previous update 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://localhost:50073/ReportingService.svc"; |