Looking for NEXT Function | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Looking for NEXT Function

HI All, As in Crystal reports what is the equivalent of NEXT Function. I want to check the value of Next record using this function. I got Previous in Reporting Services but couldn’t use next. Please let me know asap. Regards,
Hi Kiran,
I didnt got ur ques well,
What is ur query exactly, i mean what u r trying to get.
Next function in Crystal or SQL.
Firstly I need this for Reporting Services. Actually, I have to do some calculation based on the value of next record in the report. In case i need to check the previous record i used … =previous(FieldName.Value) But i didnt got anything in for getting the next record value. Hope I am clear.. Kiran