private void BindReportGrid(IList <HotelDataEntryLib.Helper.Reports> report)
{
JqGridReport.DataSource = report;
AppendTotal(report);
JqGridReport.DataBind();
JqGridReport.AppearanceSettings.ShrinkToFit = true;
}
protected void btnPDF_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
JqGridReport.ExportSettings.ExportHeaders = true;
JqGridReport.ExportSettings.ExportDataRange = ExportDataRange.All;
var dt = JqGridReport.GetExportData();
dt.Rows.Add("Total", "-", "-", JqGridReport.Columns.FromDataField("RoomActual").FooterValue,
JqGridReport.Columns.FromDataField("RoomBudget").FooterValue,
JqGridReport.Columns.FromDataField("FBActual").FooterValue,
JqGridReport.Columns.FromDataField("FBBudget").FooterValue,
JqGridReport.Columns.FromDataField("SpaActual").FooterValue,
JqGridReport.Columns.FromDataField("SpaBudget").FooterValue,
JqGridReport.Columns.FromDataField("OtherActual").FooterValue,
JqGridReport.Columns.FromDataField("OtherBudget").FooterValue);
ExportToPDF(dt);
}