We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Pie Chart not working in export as PDF

Thread ID:

Created:

Updated:

Platform:

Replies:

149191 Nov 18,2019 09:56 AM UTC Jun 16,2020 01:02 PM UTC AngularJS 19
loading
Tags: ejReportViewer
Joe Samraj
Asked On November 18, 2019 09:56 AM UTC

Hi,

   I'm using report viewer control in AngularJS. When I export a report with pie chart as pdf, the pie chart is not coming in the pdf file. Is this a bug?

Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On November 19, 2019 08:56 AM UTC

Hi Joe, 

We were not able to reproduce the mentioned pie chart not exporting in PDF export at our end. So, could you please share your issue reproducible report file and our scripts and assemblies versions to validate the mentioned problem at our end. 

Regards, 
Vinoth S. 


Joe Samraj
Replied On November 19, 2019 11:45 AM UTC

Hi Vinoth,

  Thanks for your reply. I have attached the rdl and html files I'm using. One more question, are you supporting SSRS 2019?

Thanks,
Joe

Attachment: Report_b6b4051.zip

Vinoth Srinivasan [Syncfusion]
Replied On November 22, 2019 10:59 AM UTC

Hi Joe, 
 
Please find the below response for your queries. 
 
Query 
Response 
When I export a report with pie chart as pdf, the pie chart is not coming in the pdf file. 
We have checked the mentioned issue with your shared report file and it is exporting properly at our end. So, could you please confirm are you using ASP.NET or ASP.NET Core Web API service with Angular JS application. If you are using ASP.Net Core, then we need to use PhantomJS to export the data visualization report items. 
One more question, are you supporting SSRS 2019? 
We are getting some issue when installing the SSRS 2019 in our local system. We will fix and provide the details with SSRS 2019 and our Report Viewer control ASAP. 
 
 
Regards, 
Vinoth S. 


Vinoth Srinivasan [Syncfusion]
Replied On November 27, 2019 03:07 AM UTC

Hi Joe, 
 
We are facing some technical issue while installing 2019 SSRS Server and will update you the details by 28th November 2019. 
 
Regards, 
Vinoth S. 


Vinoth Srinivasan [Syncfusion]
Replied On November 28, 2019 03:24 PM UTC

Hi Joe, 
 
Thanks for your patience. 
 
We have checked SSRS 2019 reports in our Report Viewer control and reports are rendering properly in our Report Viewer control. 

Regards, 
Vinoth S. 


Joe Samraj
Replied On December 5, 2019 06:57 AM UTC

Thanks for the update Vinoth. I'm using .Net Core for the API. Do you have any example for using PhantomJS to export the data visualization report items

Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On December 5, 2019 11:24 AM UTC

Hi Joe, 

Please find the below step for how to add the PhantomJS in ASP.NET Core Service application. 

Step 1: Add the below attached folder in “wwwroot” folder. 

Step 2: Add the script and PhantomJS exe in OnInitReportOption method as shown in below snap. 
 
public void OnInitReportOptions(ReportViewerOptions reportOption) 
        { 
            reportOption.ReportModel.ExportResources.UsePhantomJS = true; 
            reportOption.ReportModel.ExportResources.PhantomJSPath = _hostingEnvironment.WebRootPath + @"\PhantomJS\"; 
 
            reportOption.ReportModel.ExportResources.Scripts = new List<string> 
            { 
            }; 
 
            reportOption.ReportModel.ExportResources.DependentScripts = new List<string> 
            { 
            }; 
        } 
 

Regards, 
Vinoth S. 


Joe Samraj
Replied On December 9, 2019 05:47 AM UTC

Thanks Vinoth,


   I have tried that, but it seems I'm missing some reference here.

reportOption.ReportModel.ExportResources - is not found.

should I add any other library here?

Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On December 9, 2019 01:17 PM UTC

Hi Joe, 

We suspect are you using the older version of our assembly. Could you please share the assembly version details with us proceed further on this? 

Regards, 
Vinoth S. 


Joe Samraj
Replied On December 10, 2019 04:54 AM UTC

Hi Vinoth,

   I'm using the below assemblies

Syncfusion.EJ.AspNet.Core - 17.3.0.33
Syncfusion.EJ.ReportViewer.AspNet.Core - 17.3.0.33

Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On December 10, 2019 03:12 PM UTC

Hi Joe, 

We have provided PhantomJS support with Bold Reports, so please consider to migrate for Bold Reports and we have shared Bold Reports details in the forum #149790. 

Regards, 
Vinoth S 


Joe Samraj
Replied On December 11, 2019 08:47 AM UTC

Thanks for the details Vinoth. We are using AngularJS, is it supported in Bold Reports? if yes could you please provide the link.

Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On December 12, 2019 10:55 AM UTC

Hi Joe, 

We did not considered AngularJS for Bold Reports, since it’s in LTS from July 1st 2018 onwards. Please refer the below forum. 


So, we suggest you to render our jQuery control in your AngularJS application and you can refer the below online forum for using the jQuery control in an AngularJS application. 


Regards, 
Vinoth S. 


Joe Samraj
Replied On June 10, 2020 05:22 PM UTC

Hi Vinoth,

  I have updated the code according to the document as below. Still the pdf export doesn't have the pie chart.

Below are the versions I'm using

BoldReports.Net.Core - 2.2.34
Microsoft.AspNetCore.App - 2.2.0


using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using BoldReports.Web;
using BoldReports.Web.ReportViewer;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using SSRSAuth.Configuration;

namespace SSRSAuth.Controllers
{
    [Route("api/[controller]/[action]")]
    [Microsoft.AspNetCore.Cors.EnableCors("AllowAllOrigins")]
    public class ReportAPIController : Controller,IReportController
    {
        private Microsoft.Extensions.Caching.Memory.IMemoryCache _cache;
        private Microsoft.AspNetCore.Hosting.IHostingEnvironment _hostingEnvironment;
        private ReportServerConfig _reportServerConfig { get; }
        private PowerBIDBConfig _powerBIDBConfig { get; }
        private readonly ILogger _logger;


        // Post action to process the report from server based json parameters and send the result back to the client.
        public ReportAPIController(Microsoft.Extensions.Caching.Memory.IMemoryCache memoryCache,
            Microsoft.AspNetCore.Hosting.IHostingEnvironment hostingEnvironment,
            ReportServerConfig reportServerConfig,
            PowerBIDBConfig powerBIDBConfig,
            ILogger<ReportAPIController> logger
            )
        {
            _cache = memoryCache;
            _hostingEnvironment = hostingEnvironment;
            _reportServerConfig = reportServerConfig;
            _powerBIDBConfig = powerBIDBConfig;
            _logger = logger;
        }

        // Post action to process the report from server based json parameters and send the result back to the client.
        [HttpPost]
        public object PostReportAction([FromBody] Dictionary<string, object> jsonArray)
        {
            return ReportHelper.ProcessReport(jsonArray, this, this._cache);
        }

        // Method will be called to initialize the report information to load the report with ReportHelper for processing.
        public void OnInitReportOptions(ReportViewerOptions reportOption)
        {
            reportOption.ReportModel.ExportResources.UsePhantomJS = true;
            reportOption.ReportModel.ExportResources.PhantomJSPath = _hostingEnvironment.WebRootPath + @"\PhantomJS\";
            reportOption.ReportModel.ExportResources.Scripts = new List<string>
            {
                "https://cdn.boldreports.com/2.2.32/scripts/common/bold.reports.widgets.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/common/bold.reports.common.min.js",
                //Chart component script
                "https://cdn.boldreports.com/2.2.32/scripts/data-visualization/ej.chart.min.js",
                //Gauge component scripts
                "https://cdn.boldreports.com/2.2.32/scripts/common/ej2-base.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/common/ej2-data.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/common/ej2-pdf-export.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/common/ej2-svg-base.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/data-visualization/ej2-lineargauge.min.js",
                "https://cdn.boldreports.com/2.2.32/scripts/data-visualization/ej2-circulargauge.min.js",
                //Map component script
                "https://cdn.boldreports.com/2.2.32/scripts/data-visualization/ej.map.min.js",
                //Report Viewer Script
                "https://cdn.boldreports.com/2.2.32/scripts/bold.report-viewer.min.js"
            };

            reportOption.ReportModel.ExportResources.DependentScripts = new List<string>
            {
                 "https://code.jquery.com/jquery-1.10.2.min.js"
            };

            try
            {
                string basePath = _hostingEnvironment.WebRootPath;
                var credential = new DataSourceCredentials()
                {
                    ConnectionString = _powerBIDBConfig.ConnectionString,
                    Name = _powerBIDBConfig.Name,
                    UserId = _powerBIDBConfig.Username,
                    Password = _powerBIDBConfig.Password
                };
                reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential(_reportServerConfig.Username, _reportServerConfig.Password);
                reportOption.ReportModel.DataSourceCredentials.Add(credential);
            }
            catch (Exception ex)
            {
                _logger.LogError(ex.Message);
            }

        }

        // Method will be called when reported is loaded with internally to start to layout process with ReportHelper.
        public void OnReportLoaded(ReportViewerOptions reportOption)
        {

        }

        //Get action for getting resources from the report
        [ActionName("GetResource")]
        [AcceptVerbs("GET")]
        // Method will be called from Report Viewer client to get the image src for Image report item.
        public object GetResource(ReportResource resource)
        {
            return ReportHelper.GetResource(resource, this, _cache);
        }

        [HttpPost]
        public object PostFormReportAction()
        {
            return ReportHelper.ProcessReport(null, this, _cache);
        }
    }
}

Vinoth Srinivasan [Syncfusion]
Replied On June 12, 2020 04:19 AM UTC

Hi Joe, 

We were able to reproduce the issue and validating with our source. We will update you the details by 12th June 2020. 

Regards, 
Vinoth S. 


Vinoth Srinivasan [Syncfusion]
Replied On June 14, 2020 05:28 AM UTC

Hi Joe, 

Sorry for the delay. 

We are still validating the export issue with our source and update you the details by 15th June 2020. 

Regards, 
Vinoth S. 


Vinoth Srinivasan [Syncfusion]
Replied On June 15, 2020 05:29 PM UTC

Hi Joe, 

Thanks for your patience. 

We have further validate the reported export issue and the issue occurs due to the below script. 

"https://cdn.boldreports.com/2.2.32/scripts/common/ej2-data.min.js", 

So, as of now we request you to comment the above script in Controller file to export the chart report items and if you still face any issue then please share the sample with us to validate this further. We will check and correct the changes in our documentation. 

Regards, 
Vinoth S. 


Joe Samraj
Replied On June 16, 2020 12:37 PM UTC

Thanks a lot Vinoth. This fixed the issue.

Regards,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On June 16, 2020 01:02 PM UTC

Hi Joe, 

Thanks for your update. We are glad to hear that the issue has been resolved at your end. 

Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon