none
Sorting of Items on a Report RRS feed

  • Question

  • Hi,

     

    Am using the reportviewer control. Have four columns(No. , School Name, Girls Attendance, Boys Attendance, Average Attendance). When I put a sort on  Average score, the end result is that the data is sorted by the AverageAttendance column. I chose descending order. All values are sorted, but only two rows come out with data not following the descending order.

     

    To reproduce the error, Right click on the table >> properties >> sorting

    Under expression, I selected the column to sort by, thats =Fields!AvgColumn.Value

    Under expression, I selected Descending

    NB: The AvgColumn holding float values such as 45.094, 67.0098, 32.989

    What could I have missed out?

    Simon.

    Wednesday, September 15, 2010 5:53 AM