FastReport

FastReport.dll
FastReport.Bars.dll
FastReport.Json.dll
FastReport.Editor.dll
Oracle.ManagedDataAccess.dll

using FastReport.Export.Pdf;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace ChorkeAcademiaReport.Controllers.Report
{
    public class ReportController : Controller
    {
        //private readonly ReportDao reportDao;
        private readonly IWebHostEnvironment hostingEnvironment;
        public ReportController(IConfiguration configuration, IWebHostEnvironment _hostingEnvironment)
        {
            //this.reportDao = new ReportDao(configuration);
            this.hostingEnvironment = _hostingEnvironment;
        }

        [HttpGet("/api/rest/report")]
        public IActionResult GetData(string FromDate, string ToDate)
        {
            try
            {
                using (var report = new FastReport.Report())
                {
                    report.Load($"{hostingEnvironment.WebRootPath}/reports/R0TM00X00.frx");
                    var data = reportDao.GetData("EN", FromDate, ToDate);
                    report.SetParameterValue("FromDate", FromDate);
                    report.SetParameterValue("ToDate", ToDate);
                    report.RegisterData(data, "M00TM00X00");
                    report.Prepare();
                    using (var ms = new MemoryStream())
                    {
                        var pdfExport = new PDFExport();
                        report.Export(pdfExport, ms);
                        return File(ms.ToArray(), "Application/PDF");
                    }
                }
            }
            catch (Exception e)
            {
                string text = e.Message;
                Console.WriteLine(e.Message);
                return BadRequest(new { msg = "No data found!" });
            }
        }
    }
}

References

• How to use multi-level JSON in a Report
• Register Json data in FastReport.NET
• Use Multiple Databases in a Report
• How to use data in JSON format
• FastReport .NET Download
• FastCube .NET Download
• Nuget FastReport.Core