Home » Developer & Programmer » Reports & Discoverer » Supress Records with 0 value.HELP!!!!!!!!!!!!!!!!!!!!!!!
Supress Records with 0 value.HELP!!!!!!!!!!!!!!!!!!!!!!! [message #88818] Wed, 09 April 2003 13:11 Go to next message
avinash
Messages: 22
Registered: February 2001
Junior Member
I created a report using 4 different querries.Now the report is returning records which have 0 values in all of its column which I don't want
for example: in a Stock ledger if an item has 0 opening balance 0 receiving 0 issue and 0 closing balance that particular item should not be displayed.
The columns are item name,opening balance,issue receiving and closing balance.
Re: Supress Records with 0 value.HELP!!!!!!!!!!!!!!!!!!!!!!! [message #88827 is a reply to message #88818] Sun, 20 April 2003 02:31 Go to previous messageGo to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

You can avoid the 0 values line to be displayed on the report.

Add the condition in your query where openingbalance>0 and/or balance>0 etc.,

Muzzammil.
Re: Supress Records with 0 value.HELP!!!!!!!!!!!!!!!!!!!!!!! [message #88841 is a reply to message #88818] Sun, 27 April 2003 23:27 Go to previous message
Jayasri
Messages: 28
Registered: July 2000
Junior Member
If you are using reports version greater than 2.5, then you can do it using 'Conditional formatting' property.
Previous Topic: EUL Compatibility
Next Topic: Oracle Discoverer
Goto Forum:
  


Current Time: Sat Jul 04 11:27:07 CDT 2020