Filter out Null value

Thanks!

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Thursday, July 03, 2003 9:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Filter out Null value


If the field is a text field, create a calculated field: length (target
field) then filter on if “length = 0”

Shirley

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, July 03, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Filter out Null value

Good Morning all!

I'm sure this has been asked before but I must ask again.

When you create a filter in Report Builder, how do you ask if a field is
empty or not empty. I just want to filter out a certain field that is
empty.

Thanks,

Jasper





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





Yahoo! Groups Sponsor


< http://rd.yahoo.com/M=249982.3512844.4795476.1261774/D=egroupweb/S=1705
007183:HM/A=1524963/R=0/SIG=12o72ctft/*http:/hits.411web.com/cgi-bin/aut
oredir?camp=556&lineid=3512844∝=egroupweb&pos=HM>


< http://us.adserver.yahoo.com/l?M=249982.3512844.4795476.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=272130619>

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/.
< 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

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1652964/R=0/SIG=11t2ts2ch/*http://www.netflix.com/Default?mqso=60178276&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1652964/rand=471425115>

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

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]
Good Morning all!

I'm sure this has been asked before but I must ask again.

When you create a filter in Report Builder, how do you ask if a field is empty or not empty. I just want to filter out a certain field that is empty.

Thanks,

Jasper





[Non-text portions of this message have been removed]
If the field is a text field, create a calculated field: length (target
field) then filter on if “length = 0”

Shirley

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, July 03, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Filter out Null value

Good Morning all!

I'm sure this has been asked before but I must ask again.

When you create a filter in Report Builder, how do you ask if a field is
empty or not empty. I just want to filter out a certain field that is
empty.

Thanks,

Jasper





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





Yahoo! Groups Sponsor


<http://rd.yahoo.com/M=249982.3512844.4795476.1261774/D=egroupweb/S=1705
007183:HM/A=1524963/R=0/SIG=12o72ctft/*http:/hits.411web.com/cgi-bin/aut
oredir?camp=556&lineid=3512844∝=egroupweb&pos=HM>


<http://us.adserver.yahoo.com/l?M=249982.3512844.4795476.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=272130619>

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/.
<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

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


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