I tried that and it doesnt work. Basically i have 4 tables Event,Event_case,Bill_Sum,Recovery_Sum
and the joins are like this
Event.Event_id =Event_case.Event_id
Event_case.case_id(+)=Bill_Sum.case_id()
Event_case.case_id(+)=Recovery_Sum.case_id()
Basically the @Amount which is a formula i.e.(If isNull({BILL_SUM.SUM_PAID}) then 0 else
{BILL_SUM.SUM_PAID) is placed in the GroupHeader4 i.e. Event_Case.Case_id.
Hence basically grouping the Amount once per Case_id.
Example: If i remove the amount from Groupheader and place it in Detail. It will show up the Amount 3 times.
Without anything hidden the data is like below
EVentid Caseid coverage Amount
467 3458 LA $3431
567 8888 LA $1000
8888 LA $1000
8888 LA $1000
567 9999 LB $2000
9999 LB $2000
9999 LB $2000
567 1111 LC $3000
1111 LC $3000
1111 LC $3000
What i need is
Total Amount of LA as 4431
Total Amount of LB as 2000
and LC as 3000.
Makes sense now?
IP Logged
