3,027
Hi
When i print single copy it is showing correct Qty. Suppose i gave 1 no of copy then on second copy in Details it shows Quantity 40 if actual Quantity is 20. It gets doubled. If 3 no of copies then on 3#rd copy it shows 60.
Thanks
*This post is locked for comments
Hi Jsshivalik,
That is because of the way the RDLC report is handling the data. Because you are using the SUM method in RDLC for the scope of the report it will summarise all the Quantities sent through. Run your report in preview and go to help/about this page to see your data.
I think you should create a Global Variable for your Total Quantity, add it to your dataset and calculate it in C/AL.
For example if you look at Report 206, TotalAmount is a Global Variable and in the Sales Invoice Line - OnAfterGetRecord() trigger you will see this line of code: TotalAmount += Amount;
You can do the same in your report after receiving the Lines you can add them to the TotalQuantity variable and display that in your RDLC report instead of using the SUM method.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
