sql server reporting services: Can someone please tell me how I can return the Nth item in a dataset

I can get the first element out like so:

=First(Fields!ID_Month___Year_Jul_.Value, "ds_Set")

But how to get the Nth element

Many thanks

P.S I'm using RS2005

Hi,

I am not sure in which situation you require it, there is no funtion which
will give you the nth element. instead you can use
=RowNumber(Nothing) as a column which will return row number of the
particular dataset. So from the no. you can find out the record or go to that
record.
Or you can bring it from query itself.
Correct me if I am wrong. are you trying to give it to the user to select
the nth element? then there are otherways of doing it.

Amarnath



[quoted text, click to view]