need urgent help in customer aging report [message #252152] |
Wed, 18 July 2007 00:25 |
awan
Messages: 9 Registered: September 2005 Location: Riyadh
|
Junior Member |
|
|
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
-
Attachment: Arm2932.rdf
(Size: 276.00KB, Downloaded 1131 times)
|
|
|