How to filter on a group field in a tablix?

    General discussion

  • I have a tablix in SSRS 2008 R2 which I mean to only display when field value tablix_flag = 2.  My dataset looks like:

    tablix_flag     ACA_N_ACO_Link2                        Details3
    1               CA9CEE16-84FE-418E-933F-33208185A294   C
    1               6921FD87-7244-4AB1-934B-471E6B549AA7   A
    1               014ED434-4C80-48FF-A93E-95C1051B1638   C
    2               6921FD87-7244-4AB1-934B-471E6B549AA7   A
    2               6921FD87-7244-4AB1-934B-471E6B549AA7   B

    As you can see, rows 2 and 4 are identical except for the tablix_flag value.  I want all of the tablix_flag=1 rows to be in tablix1 and the other two in tablix2.  Previously I had an expression to display only tablix_flag=2 records in tablix2, but i have removed this now so that it shows all records, regardless of flag. 

    This is what my output looks like now:

    I only want to see the columns where there is a "2" in the first column on the green rows.  So I want to be able to display just these "2" rows, but the problem is that there are 2 groups in my tablix2:

    • ACA_N_ACO_Link2
    • Details3

    As you can see from the above pictures, the "2" rows appear under the "1" parent group.  In other words, from my dataset, there are two parent rows which are identical (2 and 4).  I just want to see row 4 and row 5 in this case.  How can I do this? 

    The ACA_N_ACO_Link2 group has no filters and no visibility restrictions.  (If it makes a difference, Details3 group does have a filter on it).  But the tablix2 has visibility expression in SSRS:


    but this resulted in 0 records!  Does this make sense what I'm trying to do? 

    Ryan D

    Friday, July 19, 2013 7:23 PM

All replies

  • Hi, it is impossible to hide a parent group and make its child group be visible at the same time. 

    Regards, Leo

    Monday, July 22, 2013 11:48 AM
  • I solved this problem.  I just had to add another field to my row grouping.

    Ryan D

    Monday, July 22, 2013 6:24 PM