SSRS: Sorting rows in report according to a specific dataset field
Hello,
I need to sort the rows of my report according to dataset field X. This field contains numbers from 1 to 10.
When I set sorting of a certein Row Group in Group Properties to
dataset field X, it won't work properly because dataset field X is of type TEXT:
1
10
2
3
4
5
6
7
8
9
How can I change the type of dataset field X to numeric in order to get the following sorting order:
1
2
3
4
5
6
7
8
9
10
Thanks
axel
November 11th, 2010 5:32am
Sorting expression =CInt(Fields!X.Value) does the job!
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 7:09am
just use this in the sorting expression:
=Cint(Fields!x.value)
Cheers,
Srid Malt
November 11th, 2010 7:11am
=cint() function will do the job for u
Amit
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 8:57am