This is a migrated thread and some comments may be shown as answers.

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

1 Answer 25 Views
Grid
This is a migrated thread and some comments may be shown as answers.
nzsr
Top achievements
Rank 1
nzsr asked on 23 Sep 2019, 03:39 AM

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">

 

 

1 Answer, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 25 Sep 2019, 06:52 PM

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.
Tags
Grid
Asked by
nzsr
Top achievements
Rank 1
Answers by
Attila Antal
Telerik team
Share this question
or