SIMS report issue

[localzuk]

I am currently crafting reports for yet another piece of software my manager wants, and one of the things I've just came across is that the report exports the data:

 

 


 001111 
 Ar 
 Mrs M Jules 
 08I/Ar 
 Mrs M Jules 
 

 Dr 
 Mrs H Fredson 
 08I/Dr 
 Mrs H Fredson 
 

 

Now, the issue I've got is this, where is the AdmissionNumber for the second record? It strips out all the AdmissionNumbers until the next student details are listed.

 

Is there a way of getting it to put the admission number on each record? It would make using the data a lot simpler!

[matt40k]

Is the suppress duplicates ticked?

[localzuk]

I didn't even see that box! What an odd place to put it.