Post reply

Previous and Next Record

  • 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?

  • 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

  • March 19, 2008 at 9:58 pm

    #791846

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply