Report not loading using ej report viewer in javascript.

Question

I am using the following code to display a simple report. Below is the code of my controller:

public JsonResult GenerateReport(long reportId)

{

List reportList = GenerateReport(userDetails.Language);

return Json(reportList);

}

My javascript function to generate the report is:

function GenerateReport(event) {

var reportId = event.model.itemValue;

$.ajax({

url: "/Reports/GenerateReport?qid=" + $('body').data('usid'),

type: "POST",

data: { "reportId": reportId},

success: function (data) {

$("#viewer").ejReportViewer({

processingMode: ej.ReportViewer.ProcessingMode.Local,

reportPath: "~/docs/report.rdl",

dataSources: data,

name: "list"

});

},

error: function (jqXhr, textStatus, errorThrown) {

console.log(errorThrown);

}

})

};

I have a div in my view with id viewer.

However the report is not being loaded in my view and I see no error in my console.:

The ajax is getting the data correctly.

I have created my rdl using this link:https://reportserver.syncfusion.com/en-us/report-designer.

Please help on what I am doing wrong here?

Mageshyadav M · Answer

Hi Alis, 
 
Thanks for your interest in Syncfusion products. 
 
We have checked the mentioned problem with your shared code files and found that you are not specified the reportServiceUrl and dataSources is not specified properly. So can you add your reportserviceurl and specify datasource values properly as shown in below code example. 
 
Default.html: 




$("#container").ejReportViewer( 
                    { 
                        reportServiceUrl: "/api/ReportApi", 
                        reportPath: '~/App_Data/GroupingAggregate.rdlc', 
                        processingMode: ej.ReportViewer.ProcessingMode.Local, 
                        dataSources:[{  
                            value: data, 
                            name: "Sales"  
                        }] 
                    }); 
 
We have prepared the sample for your reference and it can be downloaded from below location. 
Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportViewerJS2007679839. 
 
If issue still persist then can you please revert us back with modified sample with issue reproducible case which will be helpful for us to find the exact cause and provide proper solution. 
 
Regards, 
Mageshyadav.M

Alis · Answer

Hello Mageshyadav.M,Tahnk you for your reply.  I have one question, why do we need an APIController for the report?Can we do without the APIController, and use an mvc controller instead?Thanks,Alis

Mageshyadav M · Answer

Hi Alis, 
 




why do we need an APIController for the report? 
 
Can we do without the APIController, and use an mvc controller instead? 
 

In MVC Controller, it will support to bind known type in action argument and did not get unknown type in dictionary jsonResult which we are using in our reportviewer controller.  
 
  
 
So we are using the ApiController in ReportService controller for processing JSON object as shown in below snap.  
 
  
 
 
Regards, 
Mageshyadav.M

Alis · Answer

Hello Mageshyadav M,Reports generating perfectly now.Thanks for your help