how to disable excel export button in kendo UI if row count in grid is 0

[suman]

Hi, I need to disable excel export button if row count is zero. or show pop up "Now records found" then prevent download.

[Patrick | Technical Support Engineer, Senior]

Hi Suman,

In order to disable exporting when there are no records in the Kendo DataSource, use the excelExport event.  It will fire when the user clicks on the export button.  Then, check to see the total amount of items in the dataSource.  Finally, use e.preventDefault() to prevent exporting.  Optionally, you can add the alert.

excelExport: function(e){
              var grid = $("#grid").data("kendoGrid");
              if (grid.dataSource.total() == 0){
                e.preventDefault();
                alert("No Records Found");
              }
            },

For setting a message when there are no records:

Set the NoRecords property to true to display a message.  If you want to customize this message, set the messages.noRecords property.

$("#grid").kendoGrid({
            ...
            noRecords: true,
            messages:{
              noRecords: "No Records Found"
            },
            ...
          });

Please take a look at the following Kendo UI Dojo by Progress to see the above approaches.

I hope this helps!

Regards,
Patrick
Telerik by Progress

[suman]

Thank you Patrick for quick reply. I created excelExport event to show alert and used preventdefault. Only problem is alerting twice. Any idea why its showing alert twice?

[Patrick | Technical Support Engineer, Senior]

Hello Suman,

I was unable to replicate this issue.  Please create a dojo or update the one from the last post replicating the behavior.  

I look forward to your reply.

Regards,
Patrick
Telerik by Progress