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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics