Results for Specific Date Range

[blueboyz]

I have Crystal Reports v9.0.

I want to pull data (quantity of item sold) between two dates. I need to put the quantity sold in a column for each month.

For example:

Item Jan Feb Mar Total
ABC 10 5 5 20
ACC 5 5 0 10
BDD 7 15 7 29
TOTAL 22 20 12 59

I have tried the formula:
If date({JrnlRow.RowDate}) >= date(2005,1,1) and
if date ({JrnlRow.RowDate}) <= date(2005,1,31) then {JrnlRow.Quantity}

I get the error: the keyword "then" is missing

Is there a formula(s)can use to get the data in the right column?

 

[lbass]

Remove the second if:

If date({JrnlRow.RowDate}) >= date(2005,1,1) and
date ({JrnlRow.RowDate}) <= date(2005,1,31) then {JrnlRow.Quantity}

You also might try inserting a crosstab, using date as the column->group options->print on change of month, using item as the row, and quantity as the summary.

-LB