Crosstab Order By

Hi,

I have a column with StudentName and StudentID and my query shows populated records

ex. StudentID 1, StudentName John has 3 records 

now in my report I want to order it by StudentName. So in my crosstab under rows, I selected the StudentName.

Now I'm having a problem if I have 3 records of John in my database with different StudentID records, it will show in my crosstab 1 record of John

I tried adding the StudentID in rows but the records shows the populated records

Any suggestion?