GROUP FOOTER WILL skip value when total negative and total positive quanity=0

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=

  1. 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 ?

What does this statement mean?

You want to excecute this when totalscaused by not equal to Itel Ledger Entry Location field?

I put radio button option in request form field. one is for negative adjustment value and another is for positive adjustment value.

if customer select only negative adjustment, he will see only negative adjustment total. if he select both then he will get both result as like:

total ----------------- barcode------------------------warehouse— cost

positive -------5----------------------------1122333-------------------------chemisaxl1-------------------7

negative--------0----------------------------1122333-----------------------chemisaxl1-------------------7


when total is 0, i do not want to print this in report. problem is that it is group total field item no and location code.

i put total caused by, because it shows two or four times same things.