protected void btnExport_Click(object sender, EventArgs e)
{
if (dtStart.SelectedDate == null || dtEnd.SelectedDate == null)
{
return;
}
string dateformat = "MMMdd";
if (chkHor.Checked && !chkVer.Checked)
{
RadPivotGrid1.ExportSettings.IgnorePaging = true;
RadPivotGrid1.ExportSettings.FileName = "Press_" + ((DateTime)dtStart.SelectedDate).ToString(dateformat) + "_to_" + ((DateTime)dtEnd.SelectedDate).ToString(dateformat);
RadPivotGrid1.ExportToExcel();
}
if (!chkHor.Checked && chkVer.Checked)
{
RadPivotGrid2.ExportSettings.IgnorePaging = true;
RadPivotGrid2.ExportSettings.FileName = "Press_" + ((DateTime)dtStart.SelectedDate).ToString(dateformat) + "_to_" + ((DateTime)dtEnd.SelectedDate).ToString(dateformat);
RadPivotGrid2.ExportToExcel();
}
}
protected void chkVer_CheckedChanged(object sender, EventArgs e)
{
RadPivotGrid1.Visible = false;
RadPivotGrid2.Visible = true;
RadPivotGrid2.Rebind();
}
