Skip record in a Form

jsshivalik

Hi

I want to display only those records in a subform which satisfy below condition. Total Amount is FlowField

ReceiptAmount - "Total amount" > 0

Thanks

Drakonian

Maybe function Mark will help you. Example with pseudocode.

Rec.RESET;
Rec.CLEARMARKS;
Rec.SETRANGE(*here is your filter from subform link*);
IF Rec.FINDSET THEN REPEAT
  Rec.CALCFIELDS("Total amount");
  IF Rec.ReceiptAmount - "Total amnount" > 0 THEN
    MARK(Rec,TRUE);
Until Rec.Next = 0;

MARKEDONLY(Rec,TRUE);

da_neal

Also you can redefine OnFindRecord and OnNextRecord trigger

jsshivalik

Hi

Where to write this Code

Thanks