Skip to Content
Mar 28, 2019 at 06:32 AM

SAP Crystal Reports - Divide data into Months following Current Date



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.

So basically...

Current Date - 3/27/19 April 19 May 19 June 19

Item A

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.

Thank you