JasonKaufman
Programmer
I'm using Crystal XI
I am wanting to create a report which shows the inventory value of a product for each month of a given year.
The value of the product will change randomly depending on when goods were sold.
For example, a product valuation for January 2018 could return the valuation from 06/20/2016 because that was the last valuation date created for this product prior to 01/31/2018.
then for February 2018 & March 2018, the valuation could be based from the then last record of 02/06/2018.
The data is from one table. The fields being used are product-code, created-date, & product-value. I imagine that I will be grouping on product-code.
Thanks in advance for the assistance!
I am wanting to create a report which shows the inventory value of a product for each month of a given year.
The value of the product will change randomly depending on when goods were sold.
For example, a product valuation for January 2018 could return the valuation from 06/20/2016 because that was the last valuation date created for this product prior to 01/31/2018.
then for February 2018 & March 2018, the valuation could be based from the then last record of 02/06/2018.
The data is from one table. The fields being used are product-code, created-date, & product-value. I imagine that I will be grouping on product-code.
Thanks in advance for the assistance!