I am attempting to convert a Safari report to Crystal Reports CR8
The Rows in the table are like:
Customer Ship_Date Ship_Qty, etc.
I want the report to look like this:
Customer Date_1 Date_2 Date_3
XYZ Corp 10/11/02 10/12/02 10/13/02
QTY: 23 50 45
In Safari they use a calculation:
If (SHIPPING_DATE = WEEK_02_BEGIN) Then CalcResult(ssctest9.SHS_QUANTITY) Else CalcResult(0)
Is there any way to duplicate this in Crystal ?
or Can I use a Union Query in Crystal?
The Rows in the table are like:
Customer Ship_Date Ship_Qty, etc.
I want the report to look like this:
Customer Date_1 Date_2 Date_3
XYZ Corp 10/11/02 10/12/02 10/13/02
QTY: 23 50 45
In Safari they use a calculation:
If (SHIPPING_DATE = WEEK_02_BEGIN) Then CalcResult(ssctest9.SHS_QUANTITY) Else CalcResult(0)
Is there any way to duplicate this in Crystal ?
or Can I use a Union Query in Crystal?