I have a matrix report, and the rows have certain sections. Imagine along the left a series of "1" "2" "3" "4" "5" "6" "7" And I want some rows to be able to be hidden. For example, row 7 are totals of row 5 and 6, so I'd want to +/- next to row 7 that will show/hide rows 5 and 6. (Note that I don't calculate these totals, they were done by an accountant and I should use the values in the database.) Now I have this "parent/child" relationship in the database, and I could add that as a group on the row "4" "1" "4" "2" "4" "3" "4" "4" "7" "5" "7" "6" "7" "7" And then I could add the toggle to that first column, BUT I don't want the values to be subtotaled when they are rolled up. I simply want rows 5/6 to disappear and only show row 7. Kind of new to SSRS so any suggestions would be great.

Hi, To this requirement, you could utilize the Inscope function in the reporting services, Just like below expression: Your expression should be like this: =iif(inscope("SubCategory"),Expession1,Expression2) Here "SubCategory" is the your group name which set the toggle function. Similar thread, please see: http://forums.asp.net/p/1601570/4076185.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.