Monday, February 13, 2012

Accessing specific rows within a dataset

hi guys!

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