| How to exclude NULL dates from parameter - why 25 views w/no replies? [message #432994] |
Sat, 28 November 2009 09:24  |
pstern
Messages: 2
Registered: November 2009
|
Junior Member |
|
|
I'm new to this forum but would expect/hope that after being viewed 25+ times someone would be able to suggest a solution.
I realize most questions are of a far more technical nature than mine but... any input?
I've created a report that provides users with Service Request data down to the Task level.
Included are Task Actual End Date From (and To) parameters.
An "Actual End Date From" of 01-NOV-2009 with "Actual End Date To" of 25-NOV-2009 returns all tasks closed in that range as well as any NULL (task actual end date) values.
I have Administrator access and added an item called "Task End Date or Null" to the cs_sr_tasks_v folder "NVL2(Actual_End_Date, Actual_End_Date, 31-DEC-2009)"
My expectation was a condition using a date range from 01-NOV-2009 to 25-NOV-2009 on this new NVL2... item should exclude any Null (now 31-DEC-2009) values but instead it's returning only the records with a null value in the Task Actual End Date column.
I don't doubt that the solution is a simple one, can anyone point out what I'm doing wrong?
[Updated on: Sat, 28 November 2009 11:02] Report message to a moderator |
|
|
|
| Re: How to exclude NULL dates from parameter - why 25 views w/no replies? [message #433006 is a reply to message #432994] |
Sat, 28 November 2009 11:47  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Unfortunately, there aren't many OraFAQ Forum members who know much about Discoverer. Several months ago we have had Sabine (skooman) who helped a lot, but recently she doesn't visit the Forum. Therefore, perhaps it would be a good idea to ask for help elsewhere (please, don't think that I'm scaring you away, but the fact is that you might wait for the answer quite a long time here), such as Oracle Technology Network's Discoverer forum.
As of your problem, keeping in mind that I really have no idea about tool you use, is it possible to add another condition to the report which would look likeand actual_end_date IS NOT NULL [Updated on: Sat, 28 November 2009 11:51] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
