Filtering Against Nested Data Fields

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:

smarttag

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

complexfieldlist

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:

complexfilter

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:

filterstringtext

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
Email: sethj@devexpress.com
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: http://www.devexpress.com/Downloads/NET/

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

Follow SethJuarez on Twitter

3 comment(s)
Mark Harby

Hi Seth

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

15 June, 2011
George (DevExpress)

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

15 June, 2011
Holger Kammerer

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

15 June, 2011

Please login or register to post comments.