Vander Eduardo


How can I take the value of the next record in my report

Thanks,

Vander




Re: Value of next record

Shyam Sundar


You can do this way because a dataset field is nothing but an array of values:

Fields!YourField.Value(RowNumber("DataSet1")+1)

but make sure you check for the last record as it will give error when it reaches last record.

Shyam






Re: Value of next record

Vander Eduardo

Shyam thanks for the answer, but I think you don't understood what I want.

With your example what happened was:

OrderNumber Value NextOrderNumber

123456 $50.00 3 --> because here the RowNumber is 1 plus 1 = 2 and "3" is in position 2 of the value

452145 $30.00 1

And what I want is this:

OrderNumber Value NextOrderNumber

123456 $50.00 452145

452145 $30.00 68745

68745 $35.00 -

Of corse that the colluns used here are only for demostrate.

Thanks

Vander






Re: Value of next record

Vander Eduardo

up



Re: Value of next record

Shyam Sundar

Is your problem solved If yes, can you please mark my post as answer

Shyam