How do I get nth row from a table?



Can someone please tell me how can I get the nth row in Jet Reports?

I have tried using "LIMIT=", but it is not working. I am using the following query to get the 'Value Code' from 2nd row only using the query as following:


=NL("Last","Item Marketing Category Value","Value Code","Category Code","APPLICATION","Item No.","SCARLET792","LIMIT=",2)


But this is returning only last row. Please help me and tell me what query can I use to get just the 2nd row values?


Please sign in to leave a comment.