Doc.No. Item No. Sales CommissionCD01 Item-01 100 10CD02 Item-02 200 20CD02 Item-02 250 25CD04 Item-04 300 30Total 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 codeCurrPage.SETSELECTIONFILTER(CommissionHeader); // fetch the marksIF CommissionHeader.FINDFIRST THEN BEGINREPEATIF noFilter <> '' THENnoFilter := noFilter + '|';noFilter := noFilter + CommissionHeader."Document No."; // create filter expr.UNTIL CommissionHeader.NEXT = 0;CLEAR(CommissionHeader);CommissionHeader.SETFILTER("Document No.",noFilter); // create the filterEND;REPORT.RUNMODAL(50082,TRUE,FALSE,CommissionHeader);noFilter:='';Share your ideas Thanks in advance
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.
Can you suggest a solution I can try to solve my issue whether on the RDLC or in nav?