Home » Developer & Programmer » Reports & Discoverer » need urgent help in customer aging report
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 200 times)
Previous Topic: runing total error rep-1517 column 'cf_1' reffrence column 'sal' which is incompatible frequency
Next Topic: report is spread out in second page in oracle application
Goto Forum:
  


Current Time: Sat Dec 03 16:30:06 CST 2016

Total time taken to generate the page: 0.11453 seconds