CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008-r2
Pedram
Pedram

Reputation: 6498

SSRS: Grouping column data sorting by A to Z

I've made one grouping with "Name". Now when I retrieving the data from Dataset it shows something like this,

Eadadfadasdas
Masdadadad
Dadasdasdad
Sasdadadasd
Asdffff

I do not want to change the order In Dataset. Is it possible to do it with Expressions in SSRS Report.

I want the result like this,

Asdffff 
Dadasdasdad
Eadadfadasdas
Masdadadad
Sasdadadasd

Thanks for your time and help.

Upvotes: 0

Views: 598

Answers (2)

Jonnus
Jonnus

Reputation: 3028

In the SSRS table (which I assume you are displaying this data in) YOu need to sort by the Fieldname as follows

  1. Right click the Row Header and click Row Group -> Group Properties

  2. Then select the Sort Tab and set the Column to sort on to be your Column Name as shown

enter image description here

  1. This will display your data in alphabetical order

enter image description here

Upvotes: 1

bushell
bushell

Reputation: 550

Click on the Group Properties for 'Name'.

Under the Sorting tab, sort by name A-Z.

Upvotes: 1

Related Questions