I have customer aging report(group above) having following columns

customer id , customer name ,balance ,balance over 30 days ,balance over 60 days, balance over 90 days.

first two columns are base query while others are formula column, I want to restrict rows base upon balance ..if balance of customer exceed 10000 then it should not show that customer..

To solve it I did following

(1)I created runtime parameter p_bal to restrict rows base upon balance ,

(2) Add if logic in formula column, where balance is assumed as x1

if :x1 > :p_bal then
return (0) ;
else
RETURN(x1);
end if ;

(3)Add if logic in format trigger of repeating frame

if (:x1 = 0 ) then
return(false);
else
return (TRUE);
end if;

Up to this I change those rows with 0 balance having balance more then 10000

but about summary column which are still showing wrong sum...

I used place holders instead of summary column. but still not showing correct sum. it add first group sum into next group sum..

Can any body help me in it ....your guidance will be Appreciated

Regards,

Awan