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);
}