We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel-Like Filter Error In Grid, Does not display menu for only one Field

Thread ID:





144040 Apr 15,2019 10:36 PM UTC Apr 18,2019 05:34 AM UTC ASP.NET Web Forms 3
Tags: Grid
Levi Leonards
Asked On April 15, 2019 10:36 PM UTC

I am having an error with one of  the fields in my Grid Control. All other fields create the Excel-Like Filtering menus when the Column Filter Icon is pressed, but one filter does not display the menu, but instead creates input boxes and blank buttons below the Grid.
It look like this:
Show rows where

Attached is an image of what is created after clicking the Column Filter

Attachment: Excel_Menu_Filter_Error_39d500fd.zip

Vignesh Natarajan [Syncfusion]
Replied On April 16, 2019 11:26 AM UTC

Hi Levi, 
Thanks for contacting Syncfusion Support. 
Query: “ but instead creates input boxes and blank buttons below the Grid. 
From your query, we understand that you are facing issue while opening a excel filter dialog for certain column.The reported issue may occur when there is no record in ejGrid. Or Initially rendering the Grid with empty data and later updated the dataSource. By default Grid column will assign its type based on first record.  But when we bind empty dataSource to Grid, values will be null and column type will not be assigned. Hence the reported issue occur.  
To overcome the reported issue, we suggest you to specify Type property of the column to perform the filtering operation.   
Refer to the code example:- 
<ej:Grid ID="Grid1" runat="server" AllowPaging="true"> 
            <ej:Column Field="OrderID" /> 
            <ej:Column Field="CustomerID" Type="string" /> 
            <ej:Column Field="EmployeeID" Type="number" /> 
            .   .    . 
Refer our UG and KB document fr your reference 
Please get back to us if you need any further assistance. 
Vignesh Natarajan. 

Levi Leonards
Replied On April 17, 2019 05:15 PM UTC

Specifying the type fixed my error...thanks!

Vignesh Natarajan [Syncfusion]
Replied On April 18, 2019 05:34 AM UTC

Hi Levi, 

Thanks for the update. 

We are glad to hear that your query has been resolved by our solution.  

Please get back to us if you have further queries. 

Vignesh Natarajan.  


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon