Filtering a particular entry

[Rockstart]

I have a report that has sales , name & date entry , now when I run this
report I get all the three columns populated but there are certain date
fields which have 1/1/1985 now I dont want that date to be displayed instead I want it to display BLANK & leave corresponding sales & name AS IS , Please tell me a way , I tried to create a filter in Universe but am not able to do it


Regards

James

 

[nimmy99]

How about using Edit Formula?
If date = "1/1/1995" then " " else date

 

[Shoot]

You can also use an Alerter.

Keep Smiling
Shoot

 

[blom0344]

Universe solution would be to wrap the object in a CASE (or Decode when ORACLE) statement:

CASE WHEN date = '1/1/1995' THEN '' ELSE date

However, this will have effect on every report that uses the object...

T. Blom
Information analyst
tbl@shimano-eu.com