I have Sales Order report with Parts, open QTY and ship date of such parts.
In Crystal, I'd like to divide this data into the next 6 months from current date.
Current Date - 3/27/19 April 19 May 19 June 19
Ship date 4/15/19 50 0 0
Ship Date 6/2/19 0 0 15
Is there anyway to do this? I'd like to do it without a date parameter since I need to capture all Open Orders (any ship dates prior to current date I'd just label as Overdue)
Also I need header to reflect the correct month.
So basically I'm looking for formulas month by month which would retrieve data for following month of current data, and then following month of prior montj and so on. Then using ShipDate populate any QTY for such months.