public ReportResult ChequeBookReport(int pgId = 1)
{
ReportGenerator reportGen = new ReportGenerator();
//string rname = userManager.getReportbyName(pgId);
string rname = _repository.Fetch<ChequeReport>().Single(p => p.report_Id == pgId).reportName;
ViewBag.msgTitle = rname;
ViewBag.Title = rname;
var query = reportGen.getCheckBookReportsexel(rname);
//if (!column.Contains(""))
//{
// if (!item.Contains(""))
// {
// // query = reportGen.getCheckBookReports(rname);
// query = reportGen.getCheckBookReports(rname.Trim(), column.Trim(), item.Trim());
// }
//}
// 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 = 5;
return new ReportResult(report);
}
