i need to access a specific row within my dataset.
how can this be done within a report?
my dataset looks like this
1 asdf
2 qwer
3 yxcv
now i need to get the value for the 3rd row ("yxcv") or the value of row x
i can only acces the first and last row by using First() and Last()
but how can i access the rows inbetween?
Thanks,
Gerhard
Is there a reason you can't do a filter on the report based on the values that you are looking for, or in the query itself? Otherwise the only other way I can fathom doing this is using the code module and writing a script that will manage which row/value you are looking at and only display it if it is equal to x.
Although it might be interesting to use the RowNumber("Scope") in an IIF statement to do what you are looking for....
Hope that helps,
Josh
No comments:
Post a Comment