Skipping records when dispalying a form

Business Central/NAV Developers Forum
1

Hi everyone,
I have a form for which I want to skip certain records.
In the OnAfterGetRecord trigger, there is a code that calculates a decimal varaiable X.
I want to be able to display only the records for which X > 0.
How can I achieve that?
Thanks in advance :)

2

As far as I know there’s no way to skip record in a form (like how you should do in a report): a solution can be in OnOpenPage mark the records adding code like this:

IF FINDSET THEN

REPEAT

// Calculate decimal

MARK(X > 0);

UNTIL NEXT = 0;

MARKEDONLY(TRUE);

IF FINDFIRST THEN; //For auto-placement on first record