protected void loadBtn_Click(object sender, EventArgs e)
{
string fileId = "CustomPersistenceSettingsKey";
RadPersistenceManager1.StorageProviderKey = fileId;
RadPersistenceManager1.LoadState();
RadPivotGrid1.Rebind();
}
protected void ButtonExcel_Click(object sender, EventArgs e)
{
string alternateText = (sender as ImageButton).AlternateText;
RadPivotGrid1.ExportSettings.Excel.Format = (PivotGridExcelFormat)Enum.Parse(typeof(PivotGridExcelFormat), alternateText);
RadPivotGrid1.ExportSettings.IgnorePaging = CheckBox1.Checked;
RadPivotGrid1.ExportToExcel();
}
protected void RadPushButton1_Click(object sender, EventArgs e)
{
CustomerRFDataSource.DataBind();
RadPivotGrid1.Rebind();
BOMDataSource.DataBind();
RadGrid1.Rebind();
//SelectCommand="select distinct(part) as part from part where type = 'F' union select distinct(left(part,7)) as part from part where type = 'F' order by 1 asc">
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (dtStart.SelectedDate == null || dtEnd.SelectedDate == null)
{
return;
}
string dateformat = "MMMdd";
RadPivotGrid1.ExportSettings.IgnorePaging = true;
RadPivotGrid1.ExportSettings.FileName = "Press_" + ((DateTime)dtStart.SelectedDate).ToString(dateformat) + "_to_" + ((DateTime)dtEnd.SelectedDate).ToString(dateformat);
RadPivotGrid1.ExportToExcel();
}
protected void ddlTerm_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlTerm.SelectedItem.Value == "-1")
{
term = string.Empty;
}
else
{
term = ddlTerm.SelectedItem.Value;
}
RadPivotGrid1.Rebind();
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
RadPivotGrid1.ExportSettings.Excel.Format = (PivotGridExcelFormat)Enum.Parse(typeof(PivotGridExcelFormat), "Xlsx");
RadPivotGrid1.ExportSettings.IgnorePaging = true;
RadPivotGrid1.ExportSettings.OpenInNewWindow = true;
RadPivotGrid1.ExportSettings.FileName = "Summary";
RadPivotGrid1.ExportToExcel();
}
catch (Exception ex)
{
RadWindowManager1.RadAlert(ex.Source + " - " + ex.Message, 400, 200, "Error!", null, "");
}
}
protected void Page_Load(object sender, EventArgs e)
{
VehicleRadGridDataSource.DataBind();
RadPivotGrid1.Rebind();
}
protected void RadPushButton2_Click(object sender, EventArgs e)
{
RadPivotGrid1.ExportToExcel();
}
protected void chkHor_CheckedChanged(object sender, EventArgs e)
{
RadPivotGrid2.Visible = false;
RadPivotGrid1.Visible = true;
RadPivotGrid1.Rebind();
}
protected void ButtonWord_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
RadPivotGrid1.ExportSettings.IgnorePaging = CheckBox1.Checked;
RadPivotGrid1.ExportToWord();
}
protected void btn_ConvertToExcel_Click(object sender, ImageClickEventArgs e)
{
RadPivotGrid1.ExportSettings.FileName = "Report";
RadPivotGrid1.ExportToExcel();
}
