Sorting porblem with group and detail fields
I have about 10 columns in which 2 groups are there i.e school and grade . when i want to sort it by detail column and then with the group column in the tablix properties,it is not working for example: i have other columns like lastname,firstname,studentid,gender,school,grade,location,birthdate,age,city. so in this I have 2 groups school and grade, so when i want to sort first with firstname , lastname then grade.....it is not sorting based on the level what i am giving in the sorting tab.it is sorting first by groups then detiail. Is sorting will not work with groups?
April 20th, 2011 4:41pm

Hi aravindt46, According to your description, you would like to sort details first, and then sort groups, right? Please correct me if my understanding is wrong. I suspect that the details data is organized and grouped by groups before rendering. If you sort by the detail data in the data region, the group must be re-organized. So that SSRS does not support sorting details before sorting groups. Moreover, I would suggest you submit a feedback at http://connect.microsoft.com. Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Appreciate your understanding. If you have any question, please feel free to ask. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2011 5:35am

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

Other recent topics Other recent topics