Sum No calculated properly

[hemantp]

Following is My problem

Table 1
TR No TR Date Amount Branch
1 1/1/2003 10 MUM
2 1/1/2003 20 BEL

Table 2
Branch
TR No Brokrage Brok Type
1 2 A
1 3 Y
1 1 Z
2 1 A
2 1 Y


Report Requierd
Branch Name MUM
Month Jan-2003 Total Amount Total Brok
Sum(Amount) Sum(Brokrage)
30 8


Actualy Showing in Cross Tabl report group by branch and month(TR Date)

Report Requierd
Branch Name MUM
Month Jan-2003 Total Amount Total Brok
Sum(Amount) Sum(Brokrage)
150 8



Please Let me know how do I resolve this issue

 

[Madawc]

You haven't given details, but what I think is happening is that it associates the table 1 records with the corresponding 5 records on table 2. My recomendation is that you use groups, table 1 as a group containing table 2 values. Totaling for Table 1 is then per group rather than per record.

This is applicable in Crystal 8.5, it helps if you say which version you are using. Madawc Williams
East Anglia
Great Britain