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!" });
            }
        }
    }
}

Employee

using ChorkeAcademiaPersis.Entity;
using ChorkeAcademiaPersis.Utility;
using Microsoft.AspNetCore.Mvc;
using NHibernate;
using System.Collections.Generic;
using FastReport.Export.PdfSimple;
using System.IO;
using System.Linq;

namespace ChorkeAcademiaPersis.Controllers
{
    [Route("api/rest/[controller]")]
    [ApiController]
    public class EmployeeController : ControllerBase
    {
        // GET: api/rest/<EmployeeController>/pdf
        [HttpGet("pdf")]
        public IActionResult Get()
        {
            using (ISession session = NHibernateHelper.OpenSession())
            {
                var employees = session.Query<Employee>().ToList();
                var data = DataTableUtil.ToDataTable<Employee>(employees);

                data.TableName = "Employee";
                data.WriteXmlSchema("./Generated/Employee.xml");
                using (var report = new FastReport.Report())
                {
                    report.Load("./FastReports/Employee.frx");
                    report.RegisterData(data, "Employee");
                    report.Prepare();

                    using (var ms = new MemoryStream())
                    {
                        var pdfExport = new PDFSimpleExport();
                        report.Export(pdfExport, ms);
                        return File(ms.ToArray(), "application/pdf");
                    }
                }
            }
        }
    }
}

References

PDF Export in FastReport Open Source using ASP .Net Core Return PDF to the Browser using ASP.NET Core Report export in FastReport.OpenSource FastReport Open Source Documentation 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

Fast Report on Raspberry PI Nuget FastReport.Core