public ReportResult pendingdelexcel(int pgId = 1) { ReportGenerator reportGen = new ReportGenerator(); string rname = "Pending Delivery Check Books Report"; ViewBag.msgTitle = rname; ViewBag.Title = rname; var query = reportGen.getCheckBookReportspending(rname); var report = new Report(query.ToReportSource()); // Customize the Text Fields report.TextFields.Title = rname;//"User Menus Report"; // report.TextFields.SubTitle = "This is a sample report showing how Doddle Report works"; report.TextFields.Footer = "\n\n Copyright 2015 (c) Citi"; // Render hints allow you to pass additional hints to the reports as they are being rendered report.RenderHints.BooleanCheckboxes = true; report.RenderHints.BooleansAsYesNo = true; report.RenderHints.FreezeRows = 9; report.RenderHints.FreezeColumns = 2; return new ReportResult(report); }