SQL Custom Grouping

• extatic

  SSC Enthusiast

  Points: 158

  More actions

  June 6, 2012 at 6:53 pm

  #262464

  Hi Guys,

  Need some help with some custom grouping in my SSRS reports.

  Here is an example code:

  selectm.division

  fromtable m

  The division field will return the following:

  - Division A

  - Division B

  - Division C

  - Division D

  At the moment when I group by division, it either displays ascending or descending. How can i implement custom group to position the fields in what way i choose, e.g.

  - Division C

  - Division A

  - Division D

  - Division B

  Thank you.

• extatic

  SSC Enthusiast

  Points: 158

  More actions

  June 6, 2012 at 7:34 pm

  #1497971

  Found a solution, i'll add an extra column to the table to include a sort order and place numbers 1 to x in them.

  Thanks