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
No Data
Reply
  • Not at all sure what you are trying to do. Skip a certain row from summation? What do you want to do with that row?

    Basically if you want to skip a row from being included in RDLC, then you should prevent it from even going into the report. In RDLC you would be able to hide a line, but not exclude it from summation, if you are using RDLC's build in group/summation functionality.

    So you need to change the way the report is build, so that this is done in NAV, before it creates the dataset used for RDLC.

Children
Related
Recommended