Skip to Content
0
Feb 03, 2021 at 12:22 AM

Help with crystal reports formula

65 Views

Can anyone help me with this formula?

declare a variable stringVar catLoc

catLoc is from CAT.LOCATION

IF (USER.LOCATION = A) then catLoc = A1

IF (USER.LOCATION = B) then catLoc = B1 and so on

Then i want to return a value CAT.FIELD1 from the Table CAT depending on the catLoc