Hi experts,

I have a problem in my report, I want to get the Not Null value in my field. But I don't know how to go to the next row.
Here's my scenario, In the first row, if it is NULL then move next, if the second row is NULL then move next, until I got NOT NULL value. How can I do this?

I used this formula:

Local numberVar oLoop;
Local numberVar oCount := COUNT({VW_table.baseref});
Local stringVar oCounterRef;

For oLoop := 0 To oCount Do
    (       
        oCounterRef := ToText({VW_table.DocType});
     );
oCounterRef;


Hope to hear positive feedback.
Regards,