SSRS - Interactive sorting over multiple groups

• spider007

  SSC Veteran

  Points: 226

  More actions

  February 2, 2017 at 8:23 am

  #401536

  Hi everybody,

  i'm trying to get work interactive sorting in my report, but i stoped on this problem:
  In report i got one tablix (Tablix1) and one DataSet (DataSet1). Tablix contains 3 groups hierarchy (Detail, Group1, Group2).
  

  Now, i want to add one interactive sorting on column (Column1), that sort all groups at once.

  I try this setup to sort on group2 (the top group) with sort by Column1 and apply sorting for Tablix1 region. Also try with DataSet1 region. Both with no luck.
  It's there something that i miss?
  

  Thanks for any help.