Skip to Content
0
Former Member
Dec 11, 2006 at 07:46 PM

Looking Up Values In Other Fields

32 Views

Good Morning,

Just can not get my head around the following and am sure there is a simple way around this.

In Crystal reports, I just want to create a lookup-type formula which will display a certain value from the same table.

Example:

Ref Value IF R?

---- -

-


-

-



10 £100 £500
11 £200 £0
12 £300 £600
R10 £500 £0
R12 £600 £0
So simply, at each line, the 'IF R' formula would in turn look at the ref fields and display the Value if there is an existance of an R** ref.

Would I have to create a subreport to achive this?

Thank you in advance for your response.

Paul Carruthers