1. Home
  2. Forum
  3. ASP.NET Core
  4. Error when attempting to use SSRS
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

Error when attempting to use SSRS

_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()

Reading the forums, I read that this could be caused by a missing nuget package but I have all of them referenced.

    <PackageReference Include="Syncfusion.Compression.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.DocIO.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.EJ.AspNet.Core" Version="16.1600.0.32" />
    <PackageReference Include="Syncfusion.EJ.ReportViewer.AspNet.Core" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.OfficeChart.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.Pdf.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.Report.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="Syncfusion.XlsIO.NETStandard" Version="16.3.0.21" />
    <PackageReference Include="System.Data.SqlClient" Version="4.5.1" />

Is there anyway to identify what object is null?

                <ej-report-viewer id="reportviewer1"
                                  report-service-url="/Application/SSRS_Action"
                                  report-path="--Valid Path--"
                                  report-server-url="http://--SSRS Server--/reportserver"
                                  render-mode="Desktop"
                                  processing-mode="Remote"
 />

        public void OnInitReportOptions(ReportViewerOptions reportOption)
        {
            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("----", "", "----");
        }

5 Replies
MM Mageshyadav M Syncfusion Team September 28, 2018 02:19 PM UTC

Hi Christoper, 
 
We have not provided the support to load the SSRS report in ASP.NET Core when used with combination of .Net Standard. We can provide this feature support only for SQL 2017 Reporting services API in our upcoming 2018 Volume 3 SP1 release. 
 
Regards, 
Mageshyadav.M  


CK CHRISTOPHER KELLY September 28, 2018 02:58 PM UTC

Mageshyadav.M  sigh... that was not the answer I wanted!!!

MM Mageshyadav M Syncfusion Team September 28, 2018 03:50 PM UTC

Hi Christopher, 
 
In our previous update, we have provided an update that ReportViewer will not support to load the report from SSRS server in pure ASP.NET Core application. If you are using the ASP.NET Core application with the combination of .NET Framework as shown in below code example, then we have an support to load the report from SSRS server.  
 
 
 
We suspect that you have used the pure ASP.NET Core application to load the report from SSRS server as shown in below shared screenshot, hence the mentioned crash issue occurs at your end. This issue will solve once we provided support in this combination as promised in previous update. 
 
 
 
Regards, 
Mageshyadav.M 


CK CHRISTOPHER KELLY September 28, 2018 04:10 PM UTC

Unfortunately you indicated <quote>only for SQL 2017 Reporting services API in our upcoming 2018 Volume 3 SP1 release. </quote> We are utilizing SSRS 2016

MM Mageshyadav M Syncfusion Team October 1, 2018 09:14 AM UTC

Hi Christopher, 
 
We don’t have exact API’s available to access the server when using pure .Net Core application for earlier Reporting Services API hence we can provide support for only SQL Server 2017 Reporting Services API in our October end 2018 Volume 3 SP1 release.  
 
Regards, 
Mageshyadav.M 


Loader.
Up arrow icon