Interactive Sort Collapses Tablix

Hello,

I have a tablix with say 5 columns and 2 row groups. Upon initially opening the tablix, only one row group is shown, the other row is set to invisible but can be toggled by the first row. I put an interactive sort on columns 2-5. If I display row 2 then use the interactive sort, row 2 becomes hidden again, and I have to toggle again to see the row and the newly sorted column.

Is there any way to change this so that only the column that is sorted is re-rendered, or is it an all or nothing thing?

Thanks,

John

I'm having the same issue with grouped rows. All the groups collapse as soon as I sort any of the columns in the detail section of any of the grouped rows.

Were you able to find any solution?

Thanks!

Sorry, I never did. It has been so long I don't even remember what I did for a workaround.

Good luck!