Sum amt by month group by name

[ngcn]

Good day,

Hi, anyone knows how to create a summary report where the amount field of different PO No are sum up by month & group by company name. Report that I have created shows several differrent rows. I group the Company Name field & sum amount field according to, the formula used is :
NumberVar Total :=0;
If month(POMaster.PODate) = 1 then
Total := Total + ({POMaster.Amount});

--------------------------------------------------
this is the result that I want:

Company
Name Jan Feb Mar Total
------- ------ ------- ----- -------
abc co. 210.00 1500.50 28.90 1739.40


this is the result that I get :

Company
Name Jan Feb Mar Total
------- ------ ------- ----- -------
abc co. 210.00 210.00
abc co. 1000.50 1000.50
abc co. 500.00 500.00
abc co. 28.90 28.90

Please help me ! Thank you.

best regards,
ngcn

 

[dgillz]

This is a perfect application for a cross tab report, put the Company in the rows, the date in the columns, and the dollars are your summarized field. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com