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
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) ;
 end if ;

(3)Add if logic in format trigger of repeating frame
 if (:x1 = 0 ) then
   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


  • Attachment: Arm2932.rdf
    (Size: 276.00KB, Downloaded 210 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: Fri Aug 18 22:45:33 CDT 2017

Total time taken to generate the page: 0.10525 seconds