thanks. Is there no way to do this in SSRS? Seems like an obvious issue if you can't use this with a list

indeed Sybase has window functions however i believe my version is older and still does not support window functions (i get Incorrect syntax near keyword 'OVER')

select ROW_NUMBER() OVER (PARTITION BY...

Hi Lian,

Forgot to mention that my database is sybase and as far as i know i can't do row number within the query using partition. I meant putting the Rownumber()...