Export to excel not exporting anything when choosing more than 4 choices in combo box

2 posts, 0 answers
  1. nzsr
    nzsr avatar
    2 posts
    Member since:
    Sep 2016

    Posted 22 Sep 2019 Link to this post

    I have a grid that will bind upon choosing date with RadDatePicker and code in RadComboBox.
    I have set the combo box like this:

    <telerik:RadComboBox DropDownAutoWidth="Enabled" ID="cboCode" runat="server" AutoPostBack="true" CheckBoxes="true" EnableCheckAllItemsCheckBox="true"></telerik:RadComboBox>

     

    When I choose more that 4 options, click the Search button, the grid shows the searched data but when i click the export to excel button, it exported nothing.

    Meanwhile, if I choose less than 4 options, the data did get exported in the excel - please refer image attached.

     

    Below is the code for export setting:

    <ExportSettings ExportOnlyData="true" Excel-Format="Biff" IgnorePaging="true" ></ExportSettings>
     
    <MasterTableView AllowMultiColumnSorting="true" DataKeyNames="some column name here" AllowNaturalSort="true" CommandItemDisplay="Top" UseAllDataFields="true">

     

     

  2. Attila Antal
    Admin
    Attila Antal avatar
    523 posts

    Posted 25 Sep 2019 Link to this post

    Hi,

    Such behavior usually occurs due the Data Binding. 

    I advise that you use either the Declarative or Programmatic data binding technique and if already used, ensure that DataBind() method is not being called anywhere in the code behind. Check out the following article for more information: How to bind RadGrid properly on server-side

    Additionally, you could share the markup and code behind for the Grid so that we can see how the Filtering/Exporting is handled for the Grid. 

    Kind regards,
    Attila Antal
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top