Home » Developer & Programmer » Reports & Discoverer » report layout....PROBLEM
report layout....PROBLEM [message #269734] Mon, 24 September 2007 05:55 Go to next message
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

icon14.gif  Re: report layout....PROBLEM [message #269920 is a reply to message #269734] Tue, 25 September 2007 02:22 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

resolved...
Previous Topic: Oracle Report Migration from RPT/RPF to RDF
Next Topic: Calender Selection for generating Report
Goto Forum:
  


Current Time: Sat Dec 10 11:10:05 CST 2016

Total time taken to generate the page: 0.05977 seconds