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:
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?