Enable Sorting for SSRS eport while grouping
Hi, Can any provide me solution ,how to enable sorting while grouping has been enabled. I have grouped @ 3 levels, When clicking on one column on table header, enter dataset has to be sorted based on clicked column. I could able to sort but within group not entire report. All the data under one group get sorted but not all. With regards, MahenderMahender
November 15th, 2010 5:06am

Hi, To achieve Interactive sorting on each column of a grouped row, 1) First of all, remove the default Detail group created for any tablix. 2) Create a new row group, named group1. 3) In group expressions, add the expression you want to group on. 4) To provide sorting to any column, right click on the column header cell. 5) Go to Interactive Sort tab, check Enable interactive sorting. 6) Select the "choose what to sort" radio button, and select groups 7) choose Group1 in the groups drop-down and select the field you want to sort the tablix. Hope it helps!
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 6:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics