That makes sense.  we are turning the filter on/off based upon user click and were were binding to the setting as follows:

var binding = new Binding{

Path = new PropertyPath("FieldSettings.AllowRecordFiltering"),

Converter = new NullableBooleanConvertor(),

Mode = BindingMode.TwoWay

};    

I think we will have to write code to get at the top fieldlayout.

Setting it in code only loads the top row with values from that band.  It does not collect data from the other bands.  I really want this to work like Excel with subtotals activated.  In that scenario, all values appear in the filter list.  Thanks.

public static void SwitchFilter(XamDataGrid grid)        {

if (grid.FieldLayouts == null || grid.FieldLayouts.Count == 0) return;

grid.FieldLayouts[0].FieldSettings.AllowRecordFiltering =

!(grid.FieldLayouts[0].FieldSettings.AllowRecordFiltering ?? false);

}

I have taken a different approach and I need a little help with applying the filter.  Again, I am trying to filter all values in the grid column, allowing the parent record to stay visible when a child record matches a filter.

Here is how I am successfully loading the filter drop down.  The event handler and the recursive routine do the job.  But the magic that happens after is where I am struggling.  See below.

private void xdGrid_RecordFilterDropDownPopulating(

object sender, RecordFilterDropDownPopulatingEventArgs e)

        {

            e.IncludeUniqueValues = true;

            var comparer = e.Field.FilterOperatorDefaultValueResolved;

            var viewModel = ViewModel;

            var collection = viewModel.BindableAffiliation;

            var list = new List<string>();

            foreach (var child in collection.SelectMany(item => item.ChildAffiliation))

                list.AddRange(GetChildField(child, e.Field.Name));

            foreach (var item in list)

                e.DropDownItems.Add(new FilterDropDownItem(new ComparisonCondition(comparer, item), item));

            e.Handled = true;

        }

        private static IEnumerable<string> GetChildField(BusinessAffiliateEditObject businessAffiliate, string fieldName)

        {

            object container = businessAffiliate;

            var list = new List<string>

{ (ObjectHelper.GetPropertyValue(ref container, fieldName) ?? string.Empty).ToString() };

            if (businessAffiliate.ChildAffiliation != null)

                foreach (var child in businessAffiliate.ChildAffiliation)

                    list.AddRange(GetChildField(child, fieldName));

            return list;

        }

Applying filter:  Here is where things get a little hairy.  I have tried so many different ways to get at the datarecords in child bands.  Nothing I try seems to work and even when I can get at the datarecords, the filter.MeetsCriteria often returns true when it should return false.

private void xdGrid_RecordFilterChanging(object sender, RecordFilterChangingEventArgs e)

        {

            foreach (var fieldLayout in xdGrid.FieldLayouts)

                ClearExistingFilterConditions(fieldLayout);

            SetRowVisibility(xdGrid.RecordManager.DataPresenter.Records, e.NewRecordFilter);

            e.NewRecordFilter.Conditions.Clear();

            e.Handled = true;

        }

private static void ClearExistingFilterConditions(FieldLayout fieldLayout)

        {

            if (fieldLayout.RecordFilters != null && fieldLayout.RecordFilters.Count > 0)

                foreach (var recordFilter in fieldLayout

                    .RecordFilters

                    .Where(recordFilter => recordFilter.Conditions != null

                                           && recordFilter.Conditions.Count > 0))

                {

                    recordFilter.Conditions.Clear();

                }

        }

        private static void SetRowVisibility(IEnumerable<Record> records, RecordFilter filter)

        {

            foreach(var record in records)

            {

                var dataRecord = record as DataRecord;

                if (dataRecord == null) continue;

                var criteriaMet = filter.MeetsCriteria(dataRecord);

                if (criteriaMet || (record.HasChildren &&

                    ChildMeetsCriteria(dataRecord.ViewableChildRecords, filter)))

                {

                    record.Visibility = Visibility.Visible;

                    SetRowVisibility(dataRecord.ViewableChildRecords, filter);

                }

                else

                    record.Visibility = Visibility.Hidden;

            }

        }

private static bool ChildMeetsCriteria(IEnumerable<Record> records, RecordFilter filter)

        {

            return (from ExpandableFieldRecord expandableFieldRecord in records

                    select expandableFieldRecord

                        .ViewableChildRecords

                        .OfType<DataRecord>()

                        .Any(dataRecord =>

                             filter.MeetsCriteria(dataRecord)

                             || (dataRecord.HasChildren

                                 && ChildMeetsCriteria(dataRecord.ViewableChildRecords, filter))))

                .FirstOrDefault();

        }