Report for "Open" Corrective Actions?

Try filtering on ? (question mark) - no quotes around it.
-Todd C.

-----Original Message-----
From: Todd Gilbert [mailto:todd@...]
Sent: Friday, February 25, 2005 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report for "Open" Corrective Actions ??


I must be missing something obvious here: I'm trying to run a report for
"open" Corrective Actions in Vantage. As far as I can tell, an "open"
corrective action is defined by any record with DMRCorAct.ActionComp =
blank. I can't filter on:



DMRCorAct.ActionComp = '' or

DMRCorAct.ActionComp = 00/00/00 or something like that.



I've already used conditional print fields all over the place. Is there
a way to right a formula to state that "DMRCorAct.ActionComp = unknown"
and then filter on that?



Thanks in advance,



Todd Gilbert

Altair Technologies, Inc.

5.10.132



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129oisig4/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1109449054/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=547268243>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
I must be missing something obvious here: I'm trying to run a report for
"open" Corrective Actions in Vantage. As far as I can tell, an "open"
corrective action is defined by any record with DMRCorAct.ActionComp =
blank. I can't filter on:



DMRCorAct.ActionComp = '' or

DMRCorAct.ActionComp = 00/00/00 or something like that.



I've already used conditional print fields all over the place. Is there
a way to right a formula to state that "DMRCorAct.ActionComp = unknown"
and then filter on that?



Thanks in advance,



Todd Gilbert

Altair Technologies, Inc.

5.10.132



[Non-text portions of this message have been removed]