I am converting a report from Crystal to Reporting Services and I need the ability to look ahead by one row (the Next command in Crystal) and use this data from the result set to perform certain calculation.
If there is not a similar comman is there a way to do this short of creating a temp table and using a cursor???