Filter table before grouping

5 posts, 0 answers
  1. Saba
    Saba avatar
    4 posts
    Member since:
    Oct 2015

    Posted 14 Oct 2015 Link to this post

    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?

  2. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 19 Oct 2015 Link to this post

    Hello Saba,

    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
  3. DevCraft banner
  4. Saba
    Saba avatar
    4 posts
    Member since:
    Oct 2015

    Posted 19 Oct 2015 in reply to Nasko Link to this post

    Thanks, that did the trick, but now I still see a group header even after the group members have been filtered out. Any ideas?
  5. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 22 Oct 2015 Link to this post

    Hello Saba,

    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
  6. Saba
    Saba avatar
    4 posts
    Member since:
    Oct 2015

    Posted 22 Oct 2015 in reply to Nasko Link to this post

    I haven't had too much luck there but I will give it another shot. Thanks.
Back to Top
DevCraft banner