Hi folks,
I have integrated the below code in my application to generate a 'pdf' file using crystal reports in MVC project.
However, after the request is processed, i get to see only 2 pages in the pdf file while my 'data' returns more than 2 records.
Also, the pdf isn't rendered as soon as the page is processed but instead i have to refresh atleast once, then the pdf is rendered on the browser.
using CrystalDecisions.CrystalReports.Engine;
public FileStreamResult Report()
{
ReportClass rptH = new ReportClass();
List<sampledataset> data = objdb.getdataset();
rptH.FileName = Server.MapPath("[reportName].rpt");
rptH.Load();
rptH.SetDatabaseLogon("un", "pwd", "server", "db");
rptH.SetDataSource(data);
Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, System.IO.SeekOrigin.Begin);
return new FileStreamResult(stream, "application/pdf");
}
I took the code from here in SO but modified it like above.
TIA.