public ReportResult destroyedexcel(int pgId = 1) { ReportGenerator reportGen = new ReportGenerator(); //string rname = userManager.getReportbyName(pgId); string rname = "Destroy Check Books"; ViewBag.msgTitle = rname; ViewBag.Title = rname; var query = reportGen.getCheckBookReportspend(rname); // var query = reportGen.getCheckBookReports(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); }