ReportViewer with SSRS 2017?

[Erick Stover]

Are there any issues you're aware of when using the ReportViewer control with SSRS 2017? Can render a local RDL file just fine but when connection to 2017 server using your instructions I'm getting the following error (project and screenshot of error also attached):

_reportLoaded:Sf_Exception - System.NullReferenceException: Object reference not set to an instance of an object. at Syncfusion.RDL.Data.ReportModel.ProcessReport()
at Syncfusion.EJ.ReportViewer.Internal.ReportViewerLayoutModel.LoadReport()
at Syncfusion.EJ.ReportViewer.Internal.ReportViewerInternalHelper.ReportLoad()
at Syncfusion.EJ.ReportViewer.Internal.ReportViewerInternalHelper.ProcessReport()

The report I'm trying to render has no datasource. It's just a simple report with a textbox in the middle that says "It worked!". The only authentication is the normal SSRS credentials.

[Osman]

Hi Syncfusion team,

Is there anyone addressing this problem. I am observing the same issue also. 

Repro steps,

1- Download the attached report and upload to SSRS server.

2- In report viewer, configure SSRS url and report path. It gives  _reportLoaded:Sf_Exception - System.NullReferenceException: Object reference not set to an instance of an object. at Syncfusion.RDL.Data.ReportModel.ProcessReport() error message.

[Osman]

Hi Syncfusion team,

Is there anyone addressing this problem. I am observing the same issue also. 

Repro steps,

1- Download the attached report and upload to SSRS server.

2- In report viewer, configure SSRS url and report path. It gives  _reportLoaded:Sf_Exception - System.NullReferenceException: Object reference not set to an instance of an object. at Syncfusion.RDL.Data.ReportModel.ProcessReport() error message.

Uploading attachment

Attachment: SalesAnalysis_ac98e26c.zip

[Mahendran Shanmugam]

Hi Osman,  

 

Currently we don’t have support to load SSRS server report in ASP.NET Core ReportViewer. We have planned to provide the support for SSRS 2017 since it is a WebAPI service and also with ASP.NET Core application which has a combination of .NET Framework. We will provide this support for rendering the SSRS ReportServer 2017 reports in our Volume 2 2018 release and it will be available on end of May.  

   

Regards,  

Mahendran S.  

[Adam Reinking]

Did this support end up going in last May?  I am still getting the same error as OP.

[Erick Stover]

They keep having to push it back. Last they replied to my support ticket, they're saying the next release in the beginning of Oct (aka any day now) should have an update that fixes the issue.

[Mageshyadav M]

Hi Adam, 

 

Erick Stover: Thanks for your reply and we appreciate your follow up on this query by yourself. 

 

We have not yet completed the support to load the SSRS report in ASP.NET Core and we are progressing on it. We will provide this feature support in our upcoming 2018 Volume 3 SP1, 2018 release, which is excepted to be available on end of October, 2018. 

 

Regards, 

Mageshyadav.M      

[Héctor]

I am still getting the same error with SP1.

[Mageshyadav M]

Hi Hector, 

 

Can you confirm whether the below steps has been configured properly to use SSRS 2017 in ASP.NET Core ReportViewer.  

  

1.Client side:  

  

SSRS Configuration.  

You have to set your SSRS server URL to ReportViewer’s report-server-url property and set the relative path of RDL file in SSRS to ReportViewer’s report-path property.  

  

@{  

    ViewData["Title"] = "ReportViewer ASP.NET CORE Support";  

}  

<style>  

    body, html, #reportviewer {  

        overflow: hidden !important;  

        height: 100%;  

        width: 100%;  

    }  

</style>  

<ej-report-viewer id="reportviewer1" report-service-url="/Home" report-server-url="http://synclapn2181" report-path="/ConditionalRowFormatting" processing-mode="Remote"></ej-report-viewer>  

  

<ej-script-manager></ej-script-manager>  

  

Network Credentials for SSRS.  

The Network credentials can be given at Web API Controller to connect the SSRS server.  

  

       public void OnInitReportOptions(ReportViewerOptions reportOption)  

        {  

            //Adds SSRS Server and Database Credentials here.  

            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("guest", "demo");  

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("AdventureWorks", "ssrs1", "RDLReport1"));  

        }  

  

  

2.Controller side:  

  

You have to set your SSRS server URL to ReportViewer’s reportServerUrl property and set the relative path of RDL file in SSRS to ReportViewer’s reportPath property and also provide the Network credentials for  SSRS server and databases.  

  

        public void OnInitReportOptions(ReportViewerOptions reportOption)  

        {  

            reportOption.ReportModel.ReportPath = "/ConditionalRowFormatting";  

            reportOption.ReportModel.ReportServerUrl = "http://synclapn2181";  

            //Adds SSRS Server and Database Credentials here.  

            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("guest", "demo");  

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("AdventureWorks", "ssrs1", "RDLReport1"));  

            reportOption.ReportModel.ProcessingMode = ProcessingMode.Remote;  

        }  

  

Regards, 

Mageshyadav.M