define Query with logic in report? [message #166579] |
Fri, 07 April 2006 01:47 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
I want to create report with follwing condition
1. select * from table where block1.po=:orderno
2. select * from table where block1.po=:orderno and block1.subpo=:sub
purpose is : field PO is not null while subpo some time empty.
if I define no 1 query only prints that records which empty subpo
if I define no 2 query print records not empty subpo.
what is the solution?
|
|
|