SSRS 2005 Get Next Record Value

Question

How to get the next entry in SSRS 2005?

SSRS 2005 has a Previous function, but it does not have a Next function.

Is there any other way to achieve this functionality?

+4

Mike Aug 27 '10 at 5:27

1 answer

ErikE · Answer 1 · 2010-08-27T06:37:24+0000

A few ideas:

Shift your logic so that the first row of data is discarded, and then in the next record use Previous for the current row and current row for "Next".
Add the required data to your data set so that it is contained in additional columns. Perhaps some connections on Row_Number() to Row_Number() + 1 might be ok.
Create a stored procedure using a temporary table, and in it update the additional columns with the values of the next row. Be sure to disable the pre-check so that the SP does not explode due to temporary tables (for example, when a stored procedure is started using SET FMTONLY ON , the temporary tables will not be filled and the check will not complete).

If you give more details about what you are trying to accomplish, I could come up with more ideas.