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

Report message to a moderator

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: 2112
Registered: October 2003
Location: Cincinnati, OH
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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 16:10:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.