OraFAQ Forum: Reports & Discoverer » Matrix Report Diplaying zero's for non existing cell field values

Home » Developer & Programmer » Reports & Discoverer » Matrix Report Diplaying zero's for non existing cell field values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Matrix Report Diplaying zero's for non existing cell field values [message #87944]

Mon, 12 November 2001 15:57

waris
Messages: 115
Registered: November 2001

Senior Member

Hi ..

Could anybody suggest me how to display zero for non existing cell field values in a matrix report.i tried by putting 0 behind the cell field .. it does diplay on screen..but while printing if the value exists.it displays both value and zero...thanx in advance..i hope iam clear with the question...please do let me know if still u need calrification..thanx

waris

----------------------------------------------------------------------

Report message to a moderator

Re: Matrix Report Diplaying zero's for non existing cell field values [message #88053 is a reply to message #87944]

Mon, 28 January 2002 21:58

Fadwa
Messages: 4
Registered: January 2002

Junior Member

you need to put the zero behind the repeating frame, and set the background of the cell field to white, so the zero will not appear. The description in this site:http://technet.oracle.com/doc/reports25/bror2/ch5a.htm#one-query%20steps
Hope this will help you.

Report message to a moderator

Re: Matrix Report Diplaying zero's for non existing cell field values [message #88068 is a reply to message #87944]

Tue, 05 February 2002 02:27

waris
Messages: 115
Registered: November 2001

Senior Member

Hi Fadwa ..

Thanx for ur reply...

i did try this out...but my problem remains unsolved...since while displaying its o.k. but when i take print out of the report ..value and zero will come one above the other..so please could u help me in this problem..thanx in advance....

rgds
waris

Report message to a moderator

Re: Matrix Report Diplaying zero's for non existing cell field values [message #88073 is a reply to message #87944]

Sun, 10 February 2002 01:29

Fadwa
Messages: 4
Registered: January 2002

Junior Member

Hi,
It seems that I am not understanding your problem good. About what I suggested to you, I tried it and it worked fine in displaying and on the screen and also on the paper.
Hope you will solve your problem, and I am ready for help if I can

Report message to a moderator

Previous Topic:	convert report to excel
Next Topic:	Re: Issues with Oracle Reports?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 21:31:25 CST 2024