accessing a particular row in a data set

lektuvas

Hello,

I have SQL query that returns exactly 8 rows. I want to use a column of the 3rd row of this data set. Is there a way to access a specified row?

Virgil Dodson

There might be more ways to do this but here is one way.

Add a table (or list) to the report.
Select the table, and then the Filters tab in the Property Editor
Add a filter of:

Expression: row[0]
Operator: Equal to
Value: 2 --- (This should return the 3rd row since rows are zero based)

Oh yeah, then add the column you want to the table's detail section.

Virgil