195
Dear Experts:
How to make a cumulated variable in cal code appears on the layout?
When I put this variable in a textbox in the layout, it gives me a weird number.
This is my small code:
"
IF ItemRec.GET("Trans. Sales Entry"."Item No.") THEN BEGIN
UnitCost:=ItemRec."Unit Cost";
TotCost:=TotCost-"Trans. Sales Entry".Quantity*UnitCost;
END
"
So how to make Totcost variable appears on the layout when i run the report?
Best Regards
Hi, It's not clear to me where you put this code.
But generally you can use the following method to cumulate.
Share
Report
All responses (
Answers (
ItemRec.Reset();
ItemRec.SetRange("No.", "Trans. Sales Entry"."Item No.");
if ItemRec.FindSet() then
repeat
TotCost = ItemRec."Unit Cost";
until ItemRec.Next() = 0;
Hope this can give you some hints.
Thanks.
ZHU
Hi, I think you should at least show us the screenshot about your Report Dateset Designer and where you allocate your variable code. And what is the objective for the TotCost.
TotCost for single item or the whole inventory?
If for single item, you need to initialize your variable Totcost := 0; when next item.
On the report layout, you may try use LAST(Fields!Totcost.Value)
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156