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