OraFAQ Forum: Reports & Discoverer » TWO QUERIES IN REPORT

Home » Developer & Programmer » Reports & Discoverer » TWO QUERIES IN REPORT

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

TWO QUERIES IN REPORT [message #267084]

Wed, 12 September 2007 08:03

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

there are two queries in my report q-1 and q-2
q-1 shows all the selling of shares by client
q-2 show all the buying of shares from client.

now i have parameter with values
BUY
SELL
ALL
....
i want when i select buy only 2nd query records show on report mean buying of client
and vice versa for sell..
if select all then both queries record show on report mean buying and selling of client ..
...................
how to do this .pplz help

Report message to a moderator

Re: TWO QUERIES IN REPORT [message #267100 is a reply to message #267084]

Wed, 12 September 2007 08:29

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

Use the conditional formatting trigger in your Group Frame depending on the parameter value.

See the attached file for details.
This report will run on HR Schema.

Cheers
Soumen

Attachment: HIDING.rdf
(Size: 96.00KB, Downloaded 1140 times)

[Updated on: Wed, 12 September 2007 08:30]

Report message to a moderator

Re: TWO QUERIES IN REPORT [message #267113 is a reply to message #267100]

Wed, 12 September 2007 09:10

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

wow..
thanks it`s really working ..

Report message to a moderator

Re: TWO QUERIES IN REPORT [message #267716 is a reply to message #267100]

Fri, 14 September 2007 06:17

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

no plz tell me if on selecting (ALL) from parameter my result is like

sale of share: --based on first query--
member 76
client share rate
a 100 123
b 1200 111
member 77
client share rate
f 100 123
z 200 111
Purchase of share ----- from 2nd query
member 76
client share rate
x 100 123
y 1200 111
member 79
client share rate
f 100 123
z 200 111
-----------------if i want to display like in my report
member 76
sale against 76 ---based on first query
purchase against 76 -- based on 2nd query
member 77
sale against 77 ---based on first query
purchase against 77 -- based on 2nd query
--------------------------------------------
can i do this in format trigger...

Report message to a moderator

Previous Topic:	Report items doesn't appears
Next Topic:	Sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:46:21 CDT 2024