Previous and Next Record

• meghna.bhargav

  SSCrazy

  Points: 2634

  More actions

  March 19, 2008 at 1:32 am

  #180210

  I am working on a report in RS where I have to put in a condition when previous record is null. We can use PreviousIsNull in Crystal to check if the previous record is Null but how to check it in RS.

  Can anybody tell me how to find out Previous and Next record in RS?

• SQLZ

  SSChampion

  Points: 12872

  More actions

  March 19, 2008 at 2:59 am

  #791322

  There's a Previous( ) function you can use. The expression would look something like this.

  =IIf (IsNothing(Previous(Fields!SomeField.Value))=1, [enter some value for condition evaluation to true], [enter some other value for condition evaluating to false])

  I'm not sure about a Next function - don't think there is one.

  Karl
  source control for SQL Server

• lost in SQL

  SSC Enthusiast

  Points: 163

  More actions

  March 19, 2008 at 9:58 pm

  #791846

  Thanks Karl... I was hunting for this...