Home
Designing Analytics Reports
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?
Find more posts tagged with
Analytics
reports
#BIRT
Comments
Virgil
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