Home » Developer & Programmer » Reports & Discoverer » ignoring null values (oracle 8i , report 6)
ignoring null values [message #461857] Mon, 21 June 2010 22:38 Go to next message
lacchhii
Messages: 142
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
Re: ignoring null values [message #461865 is a reply to message #461857] Tue, 22 June 2010 00:43 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21561
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.
Re: ignoring null values [message #461966 is a reply to message #461962] Tue, 22 June 2010 05:05 Go to previous messageGo to next message
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
Re: ignoring null values [message #462012 is a reply to message #461966] Tue, 22 June 2010 06:17 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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 Go to previous messageGo to next message
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
Re: ignoring null values [message #462029 is a reply to message #462015] Tue, 22 June 2010 07:33 Go to previous message
cookiemonster
Messages: 13894
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 Smile


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.
Previous Topic: REPORT
Next Topic: Pl/Sql function
Goto Forum:
  


Current Time: Sat May 30 11:22:45 CDT 2020