I am calculating total positive and total negative quanity by putting Item No.,Location Code group total field.
I add two group footer for Itemledger entry . one is for negative quantity viewing and another is for positive quanity viewing
Example below is for negative and same code is for positive viewing.
IF PrintToExcel THEN BEGIN
CurrReport.SHOWOUTPUT(FALSE);
END ELSE BEGIN
IF CurrReport.TOTALSCAUSEDBY = “Item Ledger Entry”.FIELDNO(“Item Ledger Entry”.“Location Code”) THEN BEGIN
//IF CurrReport.TOTALSCAUSEDBY = “Item Ledger Entry”.FIELDNO(“Item Ledger Entry”.“Item No.”) THEN BEGIN
CurrReport.SHOWOUTPUT(FALSE);
END ELSE BEGIN
IF (NegativeValue<>FALSE) THEN BEGIN
CurrReport.SHOWOUTPUT(NegativeValue<>FALSE );
END;
END;
END;
I put two integer tale . one is for postive value calculation and another is for negative value calculation.
my data item indentation is=
- Itemledger entry—> Integer(for positive)
---->Integer (for negative)
I also put skipping code in both integer table onafter get record method: but it is not working.
IF (TotalNegativeQty=0) THEN BEGIN
CurrReport.SKIP;
END;
Because I have two field for view group total-- Item No.,Location Code.
what is the solution to skip ?