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
• Nuget FastReport.Core