I've a grid with ajax binding and exports to excel/PDF fine when dealing with less than a thousand records. But when I want to export bigger quantities the grid doesn't do anything at all. I even put breakpoints in both export actions with no luck.
What can I do to solve this issue?
This is my grid:
<script src="~/Scripts/lib/jszip.min.js" type="text/javascript"></script>
<script src="~/Scripts/lib/pako.js" type="text/javascript"></script>
<script src="~/Scripts/KendoUI/ExportPDFCustomizing.js" type="text/javascript"></script>
@(Html.Kendo().Grid(Model)
.Name("OperacionesDelDia")
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("OperacionesDelDia_Read", "Operaciones")
.Data("PasarParametros"))
.Aggregates(a =>
{
a.Add(p => p.oper_monto).Sum();
a.Add(p => p.oper_mont_neg).Sum();
})
.PageSize(30)
)
.Columns(columns =>
{
columns.Bound(foo => foo.esto_codigo).Title(Global.Estado);
columns.Bound(foo => foo.oper_numero)
.Title(Global.Numero)
.ClientTemplate("<a onclick=\"showDetails('#= oper_numero #')\" href='\\#'>#= oper_numero #</a>");
columns.Bound(foo => foo.merc_codigo).Title(Global.Mercado);
columns.Bound(foo => foo.oper_nrobol).Title(Global.Boleto);
columns.Bound(foo => foo.clas_codigo).Title(Global.Clase);
columns.Bound(foo => foo.tope_codigo).Title(Global.TipoOperacion);
columns.Bound(foo => foo.ClieNombre).Title(Global.RazonSocial);
columns.Bound(foo => foo.espe_codigo).Title(Global.Especie);
columns.Bound(foo => foo.cupo_numero).Title(Global.Cupon).Hidden(true);
columns.Bound(foo => foo.clie_alias).Title(Global.ClienteAlias).Hidden(true);
columns.Bound(foo => foo.oper_forigen).Title(Global.FechaOrigen).Format("{0:dd/MM/yyyy}");
columns.Bound(foo => foo.oper_plazo).Title(Global.Plazo).Hidden(true);
columns.Bound(foo => foo.oper_fvence).Title(Global.FechaVence).Format("{0:dd/MM/yyyy}");
columns.Bound(foo => foo.oper_monto).Title(Global.Capital).Format("{0:N}").ClientFooterTemplate("#= kendo.format('{0:N}', sum)#");
columns.Bound(foo => foo.espe_codcot).Title(Global.EspecieNeg).Hidden(true);
columns.Bound(foo => foo.oper_tna).Title(Global.Tna);
columns.Bound(foo => foo.oper_interes).Title(Global.Interes).Hidden(true);
columns.Bound(foo => foo.oper_mont_neg).Title(Global.Monto).Format("{0:N}").ClientFooterTemplate("#= kendo.format('{0:N}', sum)#");
columns.Bound(foo => foo.clie_cuit).Title(Global.Cuit).Hidden(true);
columns.Bound(foo => foo.TipoNroDoc).Title(Global.TipoNroDoc).Hidden(true);
columns.Bound(foo => foo.usua_codigo).Title(Global.Usuario);
columns.Bound(foo => foo.usua_alta).Title(Global.UsuarioAlta).Hidden(true);
columns.Bound(foo => foo.oper_falta).Title(Global.FechaAlta).Format("{0:dd/MM/yyyy}").Hidden(true);
columns.Bound(foo => foo.liquidada).Title(Global.Liquidado).Hidden(true);
columns.Bound(foo => foo.usua_surperv).Title(Global.UsuarioSuperv).Hidden(true);
columns.Bound(foo => foo.oper_nombre).Title(Global.Operador).Hidden(true);
columns.Bound(foo => foo.oper_observ).Title(Global.Observaciones).Hidden(true);
columns.Bound(foo => foo.espedesc).Title(Global.EspecieDesc).Hidden(true);
columns.Bound(foo => foo.orden_numero).Title(Global.Orden).Hidden(true);
})
.Excel(excel => excel
.FileName("Reporte.xlsx")
.Filterable(true)
.AllPages(true)
.ProxyURL(Url.Action("Excel_Export_Save", "Operaciones"))
)
.Pdf(pdf => pdf
.PaperSize("A4")
.AllPages()
.Landscape()
.FileName("Reporte.pdf")
.ProxyURL(Url.Action("Pdf_Export_Save", "Operaciones"))
)
.Events(e => e.PdfExport("ExportarPDF"))
.ToolBar(t => t.Excel().Text("Exportar a Excel"))
.ToolBar(t => t.Pdf().Text("Exportar a PDF"))
.ColumnMenu()
.Pageable()
.Sortable()
.Selectable()
.Scrollable(s => s.Height(320))
.Groupable()
.Resizable(resize => resize.Columns(true))
.Reorderable(reorder => reorder.Columns(true))
.Filterable(ftb => ftb.Mode(GridFilterMode.Menu))
)
<script type="text/javascript">
function PasarParametros() {
var dpFechaDesde = $("#fechaDesde").data("kendoDatePicker");
var valorFechaDesde = dpFechaDesde.element[0].value;
var dpFechaHasta = $("#fechaHasta").data("kendoDatePicker");
var valorFechaHasta = dpFechaHasta.element[0].value;
var ddlLiquidadas = $("#liquidadas").data("kendoDropDownList");
var valorLiquidadas = ddlLiquidadas.element[0].value
return {
fechaDesde: valorFechaDesde,
fechaHasta: valorFechaHasta,
liquidadas: valorLiquidadas
};
}
</script>
And these are my actions:
[HttpPost]
public ActionResult Excel_Export_Save(string contentType, string base64, string fileName)
{
var fileContents = Convert.FromBase64String(base64);
return File(fileContents, contentType, fileName);
}
[HttpPost]
public ActionResult Pdf_Export_Save(string contentType, string base64, string fileName)
{
var fileContents = Convert.FromBase64String(base64);
return File(fileContents, contentType, fileName);
}
Thank you very much
3 Answers, 1 is accepted
Hello Matias,
There are certain limitations in the quantity if items that could be exported using the built in Excel/PDF export. The reason for this is that the file is constructed completely on the client side. The Controller actions will only be hit if the browser cannot serve the file to the user. The exact limit will differ per Grid configuration, browser version, OS etc, but in cases like the current we do not recommend using the built in client side export and use some 3rd party library for server side export instead.
Regards,Dimiter Madjarov
Telerik
Rank 1
Hi Dimiter,
Can you direct us to which 3rd party to use & which technique to use to increase the capacity. Now we are able to export approx 5k rows and we would need 10k rows.
At this stage, you could do Server-Side export with our Telerik Document Processing library:
I would suggest checking the below links:
- https://demos.telerik.com/aspnet-mvc/grid/server-export
- https://demos.telerik.com/aspnet-mvc/spreadprocessing
- https://demos.telerik.com/aspnet-mvc/spreadstreamprocessing
- https://demos.telerik.com/aspnet-mvc/pdfprocessing
- https://docs.telerik.com/aspnet-mvc/helpers/grid/excel-export#use-server-side-processing
Regards,
Preslav
Progress Telerik