OraFAQ Forum: Reports & Discoverer » month display problem

Home » Developer & Programmer » Reports & Discoverer » month display problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

month display problem [message #139745]

Thu, 29 September 2005 07:30

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

have some items displayed by using a query i display the price of sell and in which month in the year

e.g

item price month
aa 23 01
aa 20 02
aa 15 05
aa 21 07
aa 22 12

i want to display the month that months that contains also null
i mean i want it like that

item price month
aa 23 01
aa 20 02
aa 15 03
aa 40 04
aa 15 05
aa 11 06
aa 21 07
aa 15 08
aa 33 09
aa 12 10
aa 43 11
aa 22 12

and when i display it in my report i can arrange them to be each price is under his month