Kendo Grid SaveAsExcel no data

[Alain]

Hey everyone.  I have a main grid which saves pdfs and excel files just fine, but another grid which i have inside of a kendo window returned from a partial view does not.  However the pdf export works just fine, whereas the excel export only shows the headers.

The only difference I can see is that my second grid has no read method, but rather has its contents returned from an ajax call.

Sample code for popup:

function openQuarterlyGrid(params) {
     (...)
        var data = {
            (...)
        };

        // get the view, load content to kendo window
        $.ajax({
            type: 'POST',
            url: '@Url.Action("ReadQuarterlyGrid", "Grid")',
            data: data,
            datatype: "html",
            success: function (e) {
                wnd.setOptions({
                    title: '',
                    height: '600',
                    width: '868', 
                    modal: true
                });

                // open and center window
                wnd.open().center();
                //  set the window content
                wnd.content(e);
            },
            error: function () {
    (...)
            },
            complete: function (xhr, status) {
                (...)
            }
        });
    }

controller method:

 [HttpPost]
        public ActionResult ReadQuarterlyGrid(...){

(...)

return PartialView("Grids/QuarterlyGrid", model);

}

 

[Alain]

And the actual grid:

 

@(Html.Kendo().Grid(Model.QuarterlyReportGridValues)
        .Name("QuarterlyReportGrid")
        ...     
        .Columns(columns =>
        {
            columns.Bound(

(...)
        })
        .ClientDetailTemplateId(...)
        .Events(e => e.DataBound(...)

.DetailInit(...)

.ExcelExport("onQuarterlyGridExcelExport"))
        .Sortable()
        .Excel(xls => xls.FileName("Quarterly Report.xlsx").AllPages(true))
        .Pdf(pdf => pdf.FileName("Quarterly Report.pdf").AllPages())
        .DataSource(dataSource => dataSource
            .Ajax()            
            .Model(model =>
            {
              (...)
            })
            .Group(  
            .Events(events =>
            {
                events.RequestEnd(...)  
                events.Error("onError");
            })
        )
    )

[Viktor Tachev]

Hi Alain,

I have examined the provided code and noticed that you have configured the Grid to use Ajax binding. Note that in this scenario you should specify a Read() method in order for the component to work as expected.

• http://docs.telerik.com/aspnet-mvc/helpers/grid/binding/ajax-binding

In case you would like to use Server binding for the Grid you can use the approach illustrated below.

• http://docs.telerik.com/aspnet-mvc/helpers/grid/binding/server-binding

Note that mixing the two approaches is not recommended and can result in unexpected behavior.


Regards,
Viktor Tachev
Telerik by Progress

[Alain]

Yup, that was it.  I rewrote all my detail grid code to use the regular ajax/read method and it worked.  Much appreciated.