Crystal equivalnet next and previous

[xtreemnet]

Hi

Is there a equivalent function in RS for Next(field) or previous(field) for accessing data from next or previous row?

Thanks.

 

[jymm]

are you trying to do this in a matrix or where?

 

[xtreemnet]

I am just trying this in the detailed section

 

[xlbo]

There is no built in "Next" or "Previous" functions but you can create a "Running count" variable which you could use to refer to RunningCount + 1 or RunningCount - 1

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xtreemnet]

Thanks.

 

[roberthagan]

There is a previous function (at least in RS 2005) in the Expression Editor/Common functions/Miscellaneous section.
It works in the details section of a table: "Returns the value of the expression for the previous row of data." Not sure about in a matrix.

 

[xlbo]

Dammit - really need to get my company to upgrade to 2005! 2000 doesn't even have a functions list that you can see what is available from!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question