Hello All, I have requirement to implement ranking in SSRS report. I am providing below example for understanding my issue. As you see that, Rank for each city is being reteived from Oracle database. But I want to implement Rank at Summary level. i.e New York summary should show Rank 1 and New Jersey summary should show Rank 2. Summary rows derived in SSRS report (not from database). Please let me know, how this can be done in SSRS Report. Appreicate if you can respond to this query soon. Thanks. State New Jersey City Sales Rank ------------------------------------------------ City1 5000 3 City2 6000 1 City3 5500 2 Total 16500 State New York City Sales Rank ------------------------------------------------ City1 15000 2 City2 16000 1 Total 31500

Hi Prashu_Gdr, From your description, you want to get the rank based on the total sales of the states. In Reporting Services, you can try to add a sorting on the state group and sort by total sales. If the order is “Z to A”, the report will sort the total sales by descending. If you need to get total sales of the states rank like the city rank above, I suggest you that get the rank at database-level. For more information about Sort Data in a Data Region (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms157462(v=sql.100).aspx Thanks, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks Bin for your response.