none
Sorting question in report viewer RRS feed

  • Question

  • I am looking to sort denomination values. When i sort it gives me

    1
    10
    25
    5
    50
    I want it to sort according to the value not the first number
    1
    5
    10
    25
    50
    • Moved by John Chen Msft Wednesday, September 16, 2009 8:24 PM (From:Visual Basic Power Packs)
    Wednesday, September 16, 2009 12:27 PM

Answers

  • Is the type a string or integer?
    If it is a string, it will sort that way. You may want to change yourt type to a number type.
    Just a thought. I am not familar with the report viewer.
    John Chen -- See my team blog: http://blogs.msdn.com/vsdata. All my posts are provided "AS IS" with no warranties, and confer no rights.
    • Marked as answer by VBShaper Tuesday, September 22, 2009 12:25 AM
    Thursday, September 17, 2009 12:26 AM

All replies

  • using the sorting option

    =Fields!Type.Value

    Wednesday, September 16, 2009 1:24 PM
  • Looks like you figure out yourself. :-)
    Next time, you can goto http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/threads for any report viewer questions.


    John Chen -- See my team blog: http://blogs.msdn.com/vsdata. All my posts are provided "AS IS" with no warranties, and confer no rights.
    Wednesday, September 16, 2009 8:23 PM

  • I am using the sorting option

    =Fields!Type.Value


    No this does not work. I get
    1
    10
    25
    5
    50
    I want it to sort according to the value not the first number
    1
    5
    10
    25
    50
    Wednesday, September 16, 2009 8:28 PM
  • Is the type a string or integer?
    If it is a string, it will sort that way. You may want to change yourt type to a number type.
    Just a thought. I am not familar with the report viewer.
    John Chen -- See my team blog: http://blogs.msdn.com/vsdata. All my posts are provided "AS IS" with no warranties, and confer no rights.
    • Marked as answer by VBShaper Tuesday, September 22, 2009 12:25 AM
    Thursday, September 17, 2009 12:26 AM