Export in pdf, excel, CSV not working

[Alis]

I am using the syncfusion report viewer in my project.  It is working fine except for the export to PDF, CSV etc..  When I click on export, I get the below error:

This localhost page can’t be found

No webpage was found for the web address:http://localhost:58003/api/ApiController/Report/PostReportAction

Below is my code for report viewer:

 public class ReportController : ApiController, IReportController

    {

        //Post action for processing the rdl/rdlc report

        [System.Web.Http.ActionName("PostReportAction")]

        [AcceptVerbs("POST")]

        public object PostReportAction(Dictionary<string, object> jsonResult)

        {

            return ReportHelper.ProcessReport(jsonResult, this);

        }

        //Get action for getting resources from the report

        [System.Web.Http.ActionName("GetResource")]

        [AcceptVerbs("GET")]

        public object GetResource(string key, string resourcetype, bool isPrint)

        {

            return ReportHelper.GetResource(key, resourcetype, isPrint);

        }

        //Method will be called when initialize the report options before start processing the report        

        public void OnInitReportOptions(ReportViewerOptions reportOption)

        {

        }

        //Method will be called when reported is loaded

        public void OnReportLoaded(ReportViewerOptions reportOption)

        {

        }

    }

Below is the javascript calling the controller:

                $("#viewer").ejReportViewer({

                    reportServiceUrl: "/api/ApiController/Report",

                    reportPath: '~/App_Data/GroupingAggregate.rdlc',

                    processingMode: ej.ReportViewer.ProcessingMode.Local,

                    dataSources: [

                        {

                            value: data,

                            name: "Sales"

                        }

                    ],

                });

I have a WebApiConfig where my route is configured as below:

public static void Register(HttpConfiguration config)

        {

            config.MapHttpAttributeRoutes();

            config.Routes.MapHttpRoute(

                name: "DefaultApi",

                routeTemplate: "api/ApiController/{controller}/{action}",

                defaults: new { id = RouteParameter.Optional }

            );

        }

Any idea why I can't do any export please?  Thanks

[Mahendran Shanmugam]

Hi Alis, 

The mentioned issue occurs when application did not find the exact web api service when exporting the report. So could you please change your route config and reportservice URL as shown in below code example. 

Global.aspx. 

Old	New
public static void Register(HttpConfiguration config)          {              config.MapHttpAttributeRoutes();                config.Routes.MapHttpRoute(                  name: "DefaultApi",                  routeTemplate: "api/ApiController/{controller}/{action}",                  defaults: new { id = RouteParameter.Optional }              );          }	public static void Register(HttpConfiguration config)          {              config.MapHttpAttributeRoutes();                config.Routes.MapHttpRoute(                  name: "DefaultApi",                  routeTemplate: "api/{controller}/{action}/{id}",                  defaults: new { id = RouteParameter.Optional }              );          }

Default.html 

Old

New

$("#viewer").ejReportViewer({                      reportServiceUrl: "/api/ApiController/Report",                      reportPath: '~/App_Data/GroupingAggregate.rdlc',                      processingMode: ej.ReportViewer.ProcessingMode.Local,                      dataSources: [                          {                              value: data,                                name: "Sales"                          }                      ],                  });

$("#viewer").ejReportViewer({                      reportServiceUrl: "/api/Report",                      reportPath: '~/App_Data/GroupingAggregate.rdlc',                      processingMode: ej.ReportViewer.ProcessingMode.Local,                      dataSources: [                          {                              value: data,                                name: "Sales"                          }                      ],                  });

If issue still persists then could you please share your issue reproducible sample to validate the mentioned problem at our end. 

Regards, 

Mahendran S. 

[Alis]

Hi Mahendran ,

Thank you for the help but the problem is still unsolved.  I can hit the action PostReportAction(Dictionary<string, object> jsonResult)

but the return ReportHelper.ProcessReport(jsonResult, this) is giving me the below error:

{StatusCode: 404, ReasonPhrase: 'Not Found', Version: 1.1, Content: <null>, Headers:{}}

Any idea what might be wrong?

Thanks,

Alis

[Vinoth Srinivasan]

Hi Alis, 

 

We suspect that the issue may occur when missed to add our dependent assemblies, so could you please ensure whether the assemblies mentioned in below link are referred in your application. 

 

https://help.syncfusion.com/js/reportviewer/create-aspnet-web-api-service#list-of-dependency-libraries 

 

If you still face any issue, then please share your application with us and it will be helpful for us to provide the solution at the earliest. 

 

Regards, 

Vinoth S. 

[Alis]

Hello Vinoth,

I check the assemblies and they are all present in the project.  We changed the syncfusion version to Syncfusion.Web.ReportViewer v16.3.0.21.  For the report viewer, when we export a report, the export is done but then there is a server error "Server cannot set status after HTTP headers have been sent."

We are also having another issue with pdf viewer, after changing the Syncfusion.Web.ReportViewer version:

1. For the pdf viewer: the plugin load the pdf with the exact number of page but all blank.
2. To convert a word, docx, to pdf, we have a "ReadTimeout" internal error and the file stream becomes null.

 The version we  are using is Syncfusion.AspNet.Mvc5.PdfViewer v16.4.0.52.

Can you please provide any solutions for those issues?

[Vinoth Srinivasan]

Hi Alis, 

 

Please find the below response for your queries. 

 

Query	Response
I check the assemblies and they are all present in the project.  We changed the syncfusion version to Syncfusion.Web.ReportViewer v16.3.0.21.  For the report viewer, when we export a report, the export is done but then there is a server error "Server cannot set status after HTTP headers have been sent."	We have checked the mentioned issue with 16.3.0.21 version assemblies, but we were not able to reproduce the mentioned issue. So we have prepared a simple MVC report viewer sample and it can be downloaded from below location. Could you please confirm whether the below sample is working fine at your end.  Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/MVC5ReportViewer-293573495.zip    If issue persists then could you please revert the sample with issue reproducible case to validate the mentioned problem at our end.
We are also having another issue with pdf viewer, after changing the Syncfusion.Web.ReportViewer version:  For the pdf viewer: the plugin load the pdf with the exact number of page but all blank. To convert a word, docx, to pdf, we have a "ReadTimeout" internal error and the file stream becomes null.    The version we  are using is Syncfusion.AspNet.Mvc5.PdfViewer v16.4.0.52.	We suspect the mentioned issue occurs when dependent assembly versions are mismatching. So is this possible for you to modify the sample to reproduce the mentioned issue in above sample.

 

 

Regards, 

Vinoth S. 

[Alis]

Hello Vinoth,

I noticed that for the pdf viewer, when analysing the html generated, that the pdf content is here, but actually is not visible.

Any idea why?

My JS is as below:

                   $("#pdfviewerJs").ejPdfViewer({

                        serviceUrl: '/api/ApiController/PdfViewer',

                        pdfService: ej.PdfViewer.PdfService.Local,

                        serverActionSettings: { load: "Load", fileUpload: "FileUpload", download: "Download" }

                    });

                    var _ejPdfViewer = $("#pdfviewerJs").data("ejPdfViewer");

                    _ejPdfViewer.setModel({ locale: lang });

                    _ejPdfViewer.showDownloadTool(false);

                    _ejPdfViewer.showSignatureTool(false);

                    _ejPdfViewer.load(data["data"]);

Data is the pdf content in base64 string.

Any idea of how to correct it?

The version we are using is Syncfusion.AspNet.Mvc5.PdfViewer v16.4450.0.52.

Thanks.

Alis

[Vinoth Srinivasan]

Hi Alis, 

 

We are unable to reproduce the reported issue with the details provided in the forum. We have created a sample with the provided code snippet and shared the same in the following location, 

 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/PdfViewer_MVCsample_(2)-1512538010 

 

Please try with this and revert us with the modified sample, culture and the PDF document in which the issue could be reproduced. These details will be helpful for us to investigate further and assist you better. 

 

Regards, 

Vinoth S. 

[Lingaraj S]

Hi Alis,

You have created this forum thread for ReportViewer export issue but your last query is not related to this thread. If you have new queries related to our other products or the query is not related to this thread then we are recommending to create the new forum for a better follow-up.

Regards,

Lingaraj S.