How to Skip Certain Row from summation in RDLC

Doc.No. Item No. Sales Commission
CD01      Item-01 100       10
CD02      Item-02 200       20
CD02     Item-02 250        25
CD04     Item-04 300        30
Total                    850       85


* I have the above Rdlc summary report and I want to skip summation of any row if only when there is more than on document number appear in the list as indicated above.


FYI: The summary report is executed from Document list using the following filter code
CurrPage.SETSELECTIONFILTER(CommissionHeader); // fetch the marks
IF CommissionHeader.FINDFIRST THEN BEGIN
REPEAT
IF noFilter <> '' THEN
noFilter := noFilter + '|';
noFilter := noFilter + CommissionHeader."Document No."; // create filter expr.
UNTIL CommissionHeader.NEXT = 0;
CLEAR(CommissionHeader);
CommissionHeader.SETFILTER("Document No.",noFilter); // create the filter
END;
REPORT.RUNMODAL(50082,TRUE,FALSE,CommissionHeader);
noFilter:='';
Share your ideas
Thanks in advance

Parents Reply Children
No Data
Related
Recommended