OraFAQ Forum: Reports & Discoverer » report layout....PROBLEM

Home » Developer & Programmer » Reports & Discoverer » report layout....PROBLEM

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

report layout....PROBLEM [message #269734]

Mon, 24 September 2007 05:55

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

my query is like..
select sum(quantity),avg(rate),.....'S' flag
UNION
select sum(quantity),avg(rate),.....'B' flag

in this s tagged with overall sale and B tagged with overall buying of clients..
now in my report lay out i want this like...

Client s.qty s.rate p.quantity p.rate
001 1000 111 500 25.9

i used formula columns to return value in sale and purchase

..like

if :flag='S'
then return(:sum(quantity)) else return null; ---for s.qty field

and separate formula column for p.qty..
what it do it make layout like..
Client s.qty s.rate p.quantity p.rate
001 1000 111
001 ---------------- 500 25.9 ...i put this line only to clearify

-----------------------------------
but in my requirement i want this in one line..
Can Any one help..

[Updated on: Mon, 24 September 2007 06:02]

Report message to a moderator