Click here to Skip to main content
11,639,861 members (61,375 online)

JMAM asked:

Open original thread
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:

secret_code
inv_date
inv_pro_category
inv_pro_sub_category
inv_pro_code
inv_pro_name
inv_beg
inv_pur_ref
inv_pur_ret
inv_dam
inv_sal_rel
inv_sal_ret
inv_ending
inv_actual


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
Tags: VB.NET, MySQL, CrystalReports

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web01 | 2.8.150731.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100