Verify if the mail profile is setup fine.

Also are there any errors in the report server catalog?

You could use a function in the precedence control. Use an expression in the precedence control to check the value of the variable and proceed.

The pseudo cursor method would surely work..

you could also try looping over the table based on the row_number() function and store the previous derived value in a temp variable...