Good day to all of you.
I would like to ask if someone knows an idea to solve my problem, i am dealing with this for almost a week and i still don't get what i want to achieve.
Here it is, First I have table "Product_Inventory" where it has the ff fields:
Example date screen shots here: https://dl.dropbox.com/u/65392916/Product_Inventory.png
This is the result output from crystal report: https://dl.dropbox.com/u/65392916/Report.png
Where beginning inventory should not be 53 when i set the date range from Nov 15, 2012 to Nov, 17, 2012
What happens is that crystal report summarized all beg inventory from nov 15 to nov 17. Inv_beg should start from the beginning of date range "Nov 15, 2012" = 25 pcs
Hope someone can understand me and help. thanks a lot in advance hope to hear from you soon