Skip record in a Form

Hi

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

ReceiptAmount - "Total amount" > 0

Thanks

Answers

  • DrakonianDrakonian Member Posts: 14
    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_nealda_neal Member Posts: 76
    Also you can redefine OnFindRecord and OnNextRecord trigger
  • jsshivalikjsshivalik Member Posts: 67
    Hi

    Where to write this Code

    Thanks
Sign In or Register to comment.