Hello Ribao,

The Excel-style filtering is available for the XMLADataSource which implements the ISupportFilters interface. Supporting the Excel-style filtering by setting the EnableAdvancedFiltering property to true is a product idea for the FlatDataSource. The same product idea has already been submitted here http://ideas.infragistics.com/forums/192363-wpf/suggestions/6268134-add-excel-style-filtering-for-flatdatasource-in-xa. As a member of the Infragistics Community you can vote for the features and suggestions you want to see added to the products, resulting in the most popular features bubbling up to the top. When planning new releases, our Product Management team will look at the most popular features and use your feedback to prioritize upcoming work.

There are many benefits to submitting/ voting for an idea through the ideas site:

-          Communicate directly with our product management team. They'll see the idea described in your words and respond to you personally.

-          Receive notifications whenever new information regarding your idea becomes available.

-          Vote on your favorite product ideas to let us know which ones are the most important to you.

-          You and other developers can discuss existing product ideas with members of our Product Management team.

Thank you for your request.

Hello Ribao,

You can customize the default FlatDataSource by deriving from it and extending its filtering functionality. If you need a guidance on how the ISupportFilters interface is implemented for the XmlaDataSource you can review the source code under the XmlaDataSource class. The source code could be downloaded under your account at My Keys & Downloads section. When you select a registered product from the list the Source Code tab for the specified version will be displayed in a tab below the list.