SSRS 2005 Get Next Record Value

Question

Hello,

How to get Next Record value in SSRS 2005? In SSRS 2005 has previous function but it has not NEXT function.

Any other way to implement this function?

Prompt reply will be appreciated.

Thanks,

Dhruval Shah

Answer 1

A few ideas:

1. Shift your logic so that the first row of data is discarded, then on the next record, use Previous for the current row and the current row for "Next".

2. Add the desired data to your dataset so it is contained in additional columns. Perhaps some joins on row_number to row_number + 1 could be in order.

3. Create a stored procedure that uses a temp table, and in the stored procedure update additional columns with the next-row values. Be sure to turn off pre-validation so the SP won't blow up because of the temp tables.

If you give more detail on what you're trying to accomplish, I might be able to come up with more ideas.