I have been trying to export my radgrid into CSV format, but somehow it'snot working even after following settings.
<CommandItemSettings ShowExportToExcelButton="true" ShowExportToCsvButton="true"
ShowAddNewRecordButton="false" ShowRefreshButton="false" />
It does not even hit OnGridExporting="radInvoiceDetails_GridExporting" method.
<CommandItemSettings ShowExportToExcelButton="true" ShowExportToCsvButton="true"
ShowAddNewRecordButton="false" ShowRefreshButton="false" />
It does not even hit OnGridExporting="radInvoiceDetails_GridExporting" method.
3 Answers, 1 is accepted
0

Shinu
Top achievements
Rank 2
answered on 22 Jun 2012, 05:36 AM
Hi,
I tried with the scenario and it is working fine at my end.If you are Ajaxifying the RadGrid ,the exporting feature of the control work with regular postbacks only. To bypass the limitation you can wire the OnRequestStart event of the ajax panel or ajax manager, determine whether the target control is ajaxified and explicitly disable its ajax mode to export with regular postback.
ASPX:
Javascript:
Please take a look into this help documentation.Provide the code if it doesn't help.
Thanks,
Shinu.
I tried with the scenario and it is working fine at my end.If you are Ajaxifying the RadGrid ,the exporting feature of the control work with regular postbacks only. To bypass the limitation you can wire the OnRequestStart event of the ajax panel or ajax manager, determine whether the target control is ajaxified and explicitly disable its ajax mode to export with regular postback.
ASPX:
<
telerik:RadAjaxManager
ClientEvents-OnRequestStart
=
"onRequestStart"
ID
=
"ajax"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadGrid1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
Javascript:
<script type=
"text/javascript"
>
function
onRequestStart(sender, args)
{
if
(args.get_eventTarget().indexOf(
"ExportToCsvButton"
) >= 0) {
args.set_enableAjax(
false
);
}
}
</script>
Please take a look into this help documentation.Provide the code if it doesn't help.
Thanks,
Shinu.
0

hitonline
Top achievements
Rank 1
answered on 22 Jun 2012, 03:23 PM
I am getting this extra button and image in exported report. (See the attachment) looks like a command item which has been disabled in code
telerik:RadGrid ID="radInvoiceDetails" runat="server" Skin="WebBlue" AllowSorting="true"
OnGridExporting="radInvoiceDetails_GridExporting" OnPreRender="radInvoiceDetails_PreRender"
ExportSettings-HideStructureColumns="true" ExportSettings-ExportOnlyData="true"
EnableLinqExpressions="false" Width="100%" AutoGenerateColumns="False" Height="100%"
OnItemDataBound="radInvoiceDetails_ItemDataBound" PageSize="10" AllowPaging="True"
EnableAJAX="True
protected void radInvoiceDetails_GridExporting(object sender, GridExportingArgs e)
{
if (e.ExportType == ExportType.Excel)
{
string fileName = radInvoiceDetails.ExportSettings.FileName + "." + radInvoiceDetails.ExportSettings.Excel.FileExtension;
Response.ClearHeaders();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + fileName + "\"");
Response.Write(e.ExportOutput);
}
}
" RetrieveAllDataFields="true" OnNeedDataSource="radInvoiceDetails_NeedDataSource">
0

Shinu
Top achievements
Rank 2
answered on 25 Jun 2012, 07:01 AM
HI,
Try setting ExportOnlyData as true.
C#:
Thanks,
Shinu.
Try setting ExportOnlyData as true.
C#:
RadGrid1.ExportSettings.ExportOnlyData =
true
;
RadGrid1.MasterTableView.ExportToExcel();
Thanks,
Shinu.