Adding a Rank to sorted groups

• Ashley Green

  SSC Rookie

  Points: 37

  More actions

  December 15, 2008 at 3:56 am

  #383571

  Hi,

  I'm new to this forum. I receive the daily emails which I often find informative but have never ventured a request for assistance before.

  I am trying to add group ranking to a report automatically generated and exported via Excel Email from Reporting Services. I need to replicate an existing manually generated Excel workbook which includes a Rank against each row. I cant seem to find a way of doing this automatically.

  The data might look like this.

  Rank Group Name Value

  1 Top Group 1234.00

  2 Second Group 788.50

  3= Third Group No 1 500.00

  3= Third Group No 2 500.00

  5 Last Group 350.67

  This is just a made up example but the excel Rank function does exactly this and users have come to rely on it.

  Can anyone be of any assistance?

• brainy

  SSCrazy

  Points: 2445

  More actions

  December 15, 2008 at 4:25 am

  #912372

  select rank() OVER ( partition by group_name ORDER BY group_name ) as rank, group_name, value, from group

  Try the above code for getting rank.

• Ashley Green

  SSC Rookie

  Points: 37

  More actions

  December 15, 2008 at 7:50 am

  #912468

  Thanks Gauthama,

  I will try this syntax.

  I have not used Partions before so it may take a little while to work it out.