Home » Developer & Programmer » Reports & Discoverer » Ageing Report (Reports 6i)
Ageing Report [message #500375] Sun, 20 March 2011 07:17 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

I have one view which displays the information of all the receipts with date now i want to make ageing report based on this date. the columns will be
0-30 , 30-60,60-180 and > 180 , i want to distribute the receipts qty based on number of days.

Re: Ageing Report [message #500394 is a reply to message #500375] Sun, 20 March 2011 12:04 Go to previous message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so what is the question?

Number of days is calculated upon ... which date? Sysdate? So subtract SYSDATE - VIEW.DATE_COLUMN and you'll know how many days has passed. CASE could be a good choice here. However, as you use Reports 6i, I'm not sure 6i's engine supports CASE (but you'll know once you try it). Perhaps you could recreate a view and add that "period" column into the view itself, which would make a report quite an easy task.
Previous Topic: REP-1259: Group 'G_CF_ORDER_NUM_LOW' has no break columns
Next Topic: Report Server 6i ORA-24323
Goto Forum:
  


Current Time: Wed Jul 30 16:17:53 CDT 2014

Total time taken to generate the page: 0.10391 seconds