Filtering Against Nested Data Fields

DevExpress Data Blog
14 June 2011

Often there is a need to look at complex data in a complex way. A cool new feature I just learned about does just that!

A cool “post-lookup” filtering feature available in our reporting suite allows you to filter the data shown in a report. This little gem can be found by selecting the report smart tag and clicking the ellipsis next to the FilterString property:


Lets see how it can be used. Suppose we are building a categorized product report with the following structure:


Here we see that categories are at the root of the report with products under each category. Generally filtering data of this nature can be difficult. Enter our FilterString Editor:


Note that you can filter on the top level categories but also the sub-level products as well. This editor also shows you how this would look as a textual filter string:


Anyone out there using this feature? I’d love to see it in action!

As always, if there are any comments and/or questions, feel free to get a hold of me!

Seth Juarez
Twitter: @SethJuarez

Want The Best Reporting Tool Ever?

Get The No-Compromise Reporting Tool for WinForms, ASP.NET, Silverlight and WPF! - Native integration with DevExpress WinForms and ASP.NET Controls, unequalled design-time productivity, industrial-grade features. Try a fully-functional version of DXperience for free now:

Let us know what you think of our Reporting Suite by rating it in the VS Gallery!

Follow SethJuarez on Twitter

Free DevExpress Products – Get Your Copy Today

The following free DevExpress product offers remain available. Should you have any questions about the free offers below, please submit a ticket via the DevExpress Support Center at your convenience. We’ll be happy to follow-up.
Mark Harby
Mark Harby

Hi Seth

Do you know if this can be exposed to the end user ?

15 June 2011
George (DevExpress)
George (DevExpress)

2Mark: Yes, this feature is available in the End-User Designer as well.

15 June 2011
Holger Kammerer
Holger Kammerer

Looks very nice! Is this also available in the independent FilterControl?

15 June 2011

Please login or register to post comments.