How to check if a column is empty or not in crystal report.

See more:

CrystalReports

VB15

I HAVE THREE COLUMNS IN CRYSTAL REPORT WHEREBY IF COLUMN ONE IS EMPTY THEN ITS PICK COLUMN TWO AND COLUMN TWO PICKS COLUMN THREE.

What I have tried:

IF ISNULL({V_SAMPLE2.VT5}) THEN
{V_SAMPLE2.VT6}
ELSE IF ISNULL({V_SAMPLE2.VT5}) THEN
{V_SAMPLE2.VT7}
ELSE
{V_SAMPLE2.VT5}