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]
-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]