Home » Developer & Programmer » Reports & Discoverer » Excluding zero having records in report (report 6i)
Excluding zero having records in report [message #330258] Sat, 28 June 2008 06:23 Go to next message
mk_sahu
Messages: 6
Registered: March 2007
Junior Member
Dear Friends,

I have attached the reports, problem is that in output I want to see only records those are greated than 0 in balance qty, how can I eliminate the zero having records from this report. the output is as following:-

Vendorname itemname iss qty recd qty bal_qty
abc xx 10 5 5
xyz aa 10 10 0
bcv dd 3 3 0

I don't want the zero having balance qty in my report.Pl help me
Re: Excluding zero having records in report [message #330346 is a reply to message #330258] Sun, 29 June 2008 16:22 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Can't you put a filter in the report query itself?
Otherwise you can also put a format trigger on the repeating frame by putting a check on bal_qty whether to show the record or not.

By
Vamsi
Re: Excluding zero having records in report [message #330397 is a reply to message #330346] Mon, 30 June 2008 01:26 Go to previous messageGo to next message
mk_sahu
Messages: 6
Registered: March 2007
Junior Member
How I can create filter through query and throgh format trigger only bal_qty filed are disappeared and I have to exclude all the records??

Regds

Mukesh Sahu
Re: Excluding zero having records in report [message #330485 is a reply to message #330258] Mon, 30 June 2008 05:00 Go to previous message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

I modified your code in repeating frame.

Find the attached RDF and let me know if any queries.

Mano
Previous Topic: Function Returning CLOB
Next Topic: generating Sequence No in Page level
Goto Forum:
  


Current Time: Sun Dec 11 08:28:49 CST 2016

Total time taken to generate the page: 0.11480 seconds