There is no way I can do it on the report side.
I will have to write a stored procedure then.
I was thinking I can add some generator to my Select statement and make
it increment automatically for each row.
Thank you for your help.