Crosstab Order By

0

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?

jhoe.singh's picture
Joined: Aug 16 2018 - 11:05pm
Last seen: 1 year 2 months ago

0 Answers:

No answers yet
Feedback
randomness