General information
Category:
Reports & Report designer
Title:
How to have calculaltion in Report Grouping
Dear all,
In my report the stock is grouped as ItemID and Batch in which ItemID identify the Item in Stock and Batch identity the actual stock level, say If My stock of Acetone I have 1 bottle of 500 ml and 1 bottle of 100 ml.
In the report of dispense, I record the Date, Quantity and BatchID whicn I consumed.
In the report it show the history say
Acetone
xxxxxx001 500ml
2-4-1990 300 Consumed
6-6-1992 100 Consumed
---------------------------
400
Here I can sum up the total consumed volume, but I fail to calcualate the quantity left by OriginalQuantity-sum(ConsumedQuanttiy) at Batch group footer which the program report nonexisting of sum.prg(!)
Is there anything wrong or otherwise calculate the result by another view before getting the report??
Regards,
Ransome
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only