Reporting 2 Rows Data into One Row

[lakehouse]

Hi-

Newbie to Crystal Report's formulas.
I have a DB with either one or two rows of records per item. I want to report last months units sold and this months units sold in the same row and add total column.

Currently my report looks like the database.

Database & Current Report:

Item Month Qty Sold
======= ======== =========
Apples August 250
Apples Sept 1100
Oranges August 2000
Grapes Sept 2500
Cantaloupe August 0
Cantaloupe Sept 800

I want the report to look like this:

Item August Sept Total
======= ======= ====== ======
Apples 250 1100 1360
Oranges 2000 <blank> 2000
Grapes <blank> 2500 2500
Cantaloupe 0 800 800

Thanks in advance.

 

[synapsevampire]

Try Insert->Crosstab

Place the date in the row area and select for each month.

Place the item in the columns, and then the qty in the summary field.

-k

 

[synapsevampire]

I should have mentioned that you should place the crosstab in the report footer.

-k