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