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?
Hey Alemayehu Ayele That is what Eric is trying to explain - You have a Datasets first which goes to Report and then all manipulation happens in there with IIF Conditions, visibility and all, and you saying you using SUM operation means SUM() of one columns, So any specific row which you don't want to entertain try to stop it from NAV side only which makes our Datasets , it will be solve your case and is good from performance perspective.