Filter table before grouping

Saba

I've applied both grouping and a filtering rule to my table. If one of the elements in a group is rejected by the filter, the entire group is rejected. It appears as if Report Designer filters out every entry in a group if any entry doesn't meet the filtering criteria.

Has anyone run into this problem before? Is there any way to filter data before grouping it?

Nasko

Instead of filtering the data rows you need to add filters to the table groups inside the Group Explorer window. This will filter the groups instead of the data.

Regards,
Nasko
Telerik

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items

Nasko

Depending on your table layout you can again use filtering, or use conditional formatting to set the visibility of the group header.
Without any knowledge of the table structure we will be unable to give you specific suggestions.

Regards,
Nasko
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.