Local Report Rendering in 2.1 But Fails in 3.0

[Bevan Coaton]

Downloaded and executed the following example solution provided in a previous thread:

https://www.syncfusion.com/forums/143289/show-ssrs-reports-on-ssrs-report-server-using-reportviewer

ReportSample_core797180486.zip (Core 2.1)

After adding a local .rdl report, we were able to connect to a SQL database and render the report without issue.

Problem: Created a new project in asp.net Core 3.0 adding the same file structure and nuget packages. When the report (index) page loads in Core 3, the following error is shown in the report view:

Unable to cast object of type 'System.Text.Json.JsonElement' to type 'System.String'.

Any help would be greatly appreciated.

Note: using the trial package and files.

[Vinoth Srinivasan]

Hi Paul, 

 

In our ASP.NET Core Report Viewer application we are using Json.NET serializer for ReportService which has been removed from ASP.NET Core 3.0 shared framework. So, could you please use AddNewtonsoftJson() with services to works with Json.NET serializer as per the migration information in below link,   

https://docs.microsoft.com/en-us/aspnet/core/migration/22-to-30?view=aspnetcore-3.0&tabs=visual-studio#jsonnet-support  

  

1.      Add a package reference to Microsoft.AspNetCore.Mvc.NewtonsoftJson.  

2.      Update Startup.ConfigureServices to call AddNewtonsoftJson.  

  

Startup.cs  

  

public void ConfigureServices(IServiceCollection services)  

{  

    services.AddControllersWithViews().AddNewtonsoftJson();  

}  

 

 

Regards, 

Vinoth S. 

[Bevan Coaton]

Thank you very much.  Worked like a charm.

[Mahendran Shanmugam]

Hi Paul,  

Thanks for your update. 

We are happy your issue was resolved. 

Regards, 

Mahendran S.