AspNetCore.Reporting.LocalProcessingException: An error occurred during local report processing

Hi gandhipriyans...,

Are you passing any parameter to the Report?

Please share the code and the line throughing the error?

Yes, I am passing parameters to the report.

I have Shared the Code

public async Task<IActionResult> GetCareSummary(CareSummaryReq request)
{
try
{
string mintype = "";
int extension = 1;
string ReportPath = "", ReportPathSave = "";
string webRootPath = _hostingEnvironment.WebRootPath;

System.Data.DataTable dt1 = new System.Data.DataTable();
System.Data.DataTable dt2 = new System.Data.DataTable();

Report_Service fmr = new Report_Service();
ReportPath = "Reports\\CareSummary.rdlc";
ReportPathSave = "ReportPdf\\CareSummary.pdf";

string path = Path.Combine(webRootPath, ReportPath);
string pathSave = Path.Combine(webRootPath, ReportPathSave);
LocalReport localReport = new LocalReport(path);

dt1 = await fmr.GetData("EXEC pr_RDL_CareSummary '" + request.FrmDt + "','" + request.ToDt + "'," + Convert.ToString(request.Skillid) + "," + Convert.ToString(request.BranchId) + ",'" + request.Mode + "'," + Convert.ToString(request.RptUserId) + "");
localReport.AddDataSource("SaylussNewDataset", dt1);

dt2 = await fmr.GetData("EXEC Pr_GetReportHeader " + Convert.ToString(request.RptUserId) + "," + Convert.ToString(request.BranchId) + "");
localReport.AddDataSource("ReportDataset", dt2);

Dictionary<string, string> parameters = new Dictionary<string, string>();
parameters.Add("FrmDt", request.FrmDt.ToString());
parameters.Add("ToDt", request.ToDt.ToString());
parameters.Add("Skillid", request.Skillid.ToString());
parameters.Add("BranchId", request.BranchId.ToString());
parameters.Add("Mode", request.Mode.ToString());
parameters.Add("RptUserId", request.RptUserId.ToString());

System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);

var result = localReport.Execute(RenderType.Pdf, extension, parameters, mintype);
byte[] file = result.MainStream;
System.IO.Stream stream = new System.IO.MemoryStream(file);
return File(stream, "application/pdf", "CareSummary.pdf");
}
catch (Exception ex)
{
return Ok(ex.ToString());
}
}

There is an issue of caching with this library. Because of this issue, "Index out of bound" exception is thrown.

The work around of this problem is to create a console application and take your report generation logic to that console application.

Once the report is generated from this new console application, you can save it in a shared location from where your actual app can access it.

You have to run this new console application as a separate process from your main/actual app.

In this way, once the report is generated, the process will end and the cache will also be cleared. So, you will never face this issue again.

Reference: https://github.com/amh1979/AspNetCore.Reporting/issues/16#issuecomment-922505776