or
protected void RadGridInventory_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.ExportToExcelCommandName || e.CommandName == RadGrid.ExportToCsvCommandName)
{
RadGridInventory.PageSize = RadGridInventory.MasterTableView.VirtualItemCount;
}
if (e.CommandName == RadGrid.ExportToExcelCommandName)
{
var headerItem = (GridHeaderItem)RadGridInventory.MasterTableView.GetItems(GridItemType.Header)[0];
headerItem.Visible = true;
isExport = true;
}
if (e.CommandName == RadGrid.ExportToCsvCommandName)
{
RadGridInventory.MasterTableView.GetColumn("CSVAcountId").Display = true;
RadGridInventory.MasterTableView.GetColumn("AccountId").Display = false;
RadGridInventory.MasterTableView.GetColumn("CSVStatus").Display = true;
RadGridInventory.MasterTableView.GetColumn("Status").Display = false;
}
}
protected void RadGridInventory_GridExporting(object source, GridExportingArgs e)
{
if (e.ExportType == ExportType.Excel)
{
string customText = "<
h1
style
=
'text-align:center;'
>Inventory Report for " + _applicationUser.Customer.Name + "</
h1
>";
customText += "<
p
style
=
'text-align:center;'
><
b
>Current Date:</
b
> " + DateTime.Now + "<
br
/>";
if(RadDatePickerStarting.SelectedDate != null && RadDatePickerEnding.SelectedDate != null){
customText += "<
b
>Date Range Covered:</
b
> " + RadDatePickerStarting.SelectedDate + " - " + RadDatePickerEnding.SelectedDate + "<
br
/>";
} else {
customText += "<
b
>Date Range Covered:</
b
> " + RadComboBoxChoices.SelectedItem.Text + "<
br
/>";
}
customText += "<
b
>Clients:</
b
>";
foreach (var client in ClientSelector1.SelectedClients)
{
customText += " " + client.Name + ",";
}
customText = customText.TrimEnd(',');
customText += "</
p
>";
e.ExportOutput = e.ExportOutput.Replace("<
body
>", "<
body
>" + customText);
}
isExport = false;
}
<
script
type
=
"text/javascript"
>
function onRequestStart(sender, args) {
if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||
args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) {
args.set_enableAjax(false);
}
}
function onCommand(sender, args) {
}
</
script
>