Home » Developer & Programmer » Reports & Discoverer » TWO QUERIES IN REPORT
TWO QUERIES IN REPORT [message #267084] Wed, 12 September 2007 08:03 Go to next message
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
Re: TWO QUERIES IN REPORT [message #267100 is a reply to message #267084] Wed, 12 September 2007 08:29 Go to previous messageGo to next message
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 154 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 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

wow..
thanks it`s really working ..
Re: TWO QUERIES IN REPORT [message #267716 is a reply to message #267100] Fri, 14 September 2007 06:17 Go to previous message
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...
Previous Topic: Report items doesn't appears
Next Topic: Sql query
Goto Forum:
  


Current Time: Sat Dec 03 13:38:58 CST 2016

Total time taken to generate the page: 0.06406 seconds