OraFAQ Forum: Reports & Discoverer » ignoring null values

Home » Developer & Programmer » Reports & Discoverer » ignoring null values (oracle 8i , report 6)

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

ignoring null values [message #461857]

Mon, 21 June 2010 22:38

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

I have a report in report 6 which has static field where values are shown for previous year and for current year. the output of the report will be like this

sl no department prev year cur year
01 revenue 2000 5000
02 costing 500 1000
03 excise 8000 900
and so on....

I have a created a fomula field for each and every department and get the value from a particular table. What i require is if suppose the department revenue does not have any value then that row should not be visible. for eg if revenue has a null value then the report should be like this

sl no department prev year cur year
01 costing 500 1000
02 excise 8000 900

Is it possible . if so pl suggest me the methods

thanks in advance

Report message to a moderator

Re: ignoring null values [message #461865 is a reply to message #461857]

Tue, 22 June 2010 00:43

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

2 Methods for this.
1) control within your sql
2) Write a Format trigger for this to hide the row when ever the two fields are null the trigger should return false.

Try your self and come back here fi you have any problems

sriram Smile

[Updated on: Tue, 22 June 2010 05:05]

Report message to a moderator

Re: ignoring null values [message #461962 is a reply to message #461865]

Tue, 22 June 2010 04:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

ramoradba

2) Write a trigger

It is a "Format Trigger" (found in the Properties window), I presume.

Report message to a moderator

Re: ignoring null values [message #461966 is a reply to message #461962]

Tue, 22 June 2010 05:05

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Littlefoot wrote on Tue, 22 June 2010 15:28

ramoradba

2) Write a trigger

It is a "Format Trigger" (found in the Properties window), I presume.

That's a sentence "Format" ing error.

sriram Smile

Report message to a moderator

Re: ignoring null values [message #462012 is a reply to message #461966]

Tue, 22 June 2010 06:17

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

I really wouldn't do it that way if possible though - it'll just make the report do more work than needed.
Can you do what the formula column does in the main query?

EDIT: typo

[Updated on: Tue, 22 June 2010 06:17]

Report message to a moderator

Re: ignoring null values [message #462015 is a reply to message #462012]

Tue, 22 June 2010 06:23

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Can you do what the formula column does in the main query?

Some times yes,sometimes no it depends.

Quote:

Is it possible . if so pl suggest me the methods

So OP has to decide.
And here i just given the possible ways to do that.Nothing more than that

sriram Smile

Report message to a moderator

Re: ignoring null values [message #462029 is a reply to message #462015]

Tue, 22 June 2010 07:33

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

ramoradba wrote on Tue, 22 June 2010 12:23

Quote:
Can you do what the formula column does in the main query?

Some times yes,sometimes no it depends.

I wouldn't be asking the question if the answer was always yes would I?

ramoradba wrote on Tue, 22 June 2010 12:23

Quote:
Is it possible . if so pl suggest me the methods

So OP has to decide.
And here i just given the possible ways to do that.Nothing more than that

sriram

I realised that. I'm suggesting my approach should be considered first and only if it can't be achieved should another approach be tried.

Report message to a moderator

Previous Topic:	REPORT
Next Topic:	Pl/Sql function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 05:35:07 CST 2024