You can either use parenthesis in the filter expression and use the "OR" or
you could create a function to set a flag True or False depending on the
part number and then filter on the calculated field. Directly in the filter
would run faster. Either way it would look like: ((Part >= 'A001' and Part
<= 'A010') or (Part >= 'B001' and Part <= 'B010') ). You could use the
RANGE comparison in the filter but it runs slower than individual tests.
If you see the users of the report ever needing to select different ranges
then put the tests directly in the filter rather than creating a logical
field.
If you need a really exact example I could you send a bitmap image screen
capture of the filter to do this off-group.
-Todd C.
-----Original Message-----
From: KRGENT@... [mailto:KRGENT@...]
Sent: Monday, September 24, 2001 7:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Calculated field question
Goodmorning,
Could anyone give me the exact expression for a calculated field which would
filter out certain part numbers which are in various ranges.
For example:
list all part numbers only from A001 to A010 and B001 to B010
Also, when filtering the report for this calculation what specifics do I
need
to do ?
Thank You,
Gary
KRG Enterprises
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.adserver.yahoo.com/l?M=168643.1620686.3168692.1261774/D=egroupmai
l/S=1705007183:HM/A=799560/rand=572024662>
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
<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
<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]
you could create a function to set a flag True or False depending on the
part number and then filter on the calculated field. Directly in the filter
would run faster. Either way it would look like: ((Part >= 'A001' and Part
<= 'A010') or (Part >= 'B001' and Part <= 'B010') ). You could use the
RANGE comparison in the filter but it runs slower than individual tests.
If you see the users of the report ever needing to select different ranges
then put the tests directly in the filter rather than creating a logical
field.
If you need a really exact example I could you send a bitmap image screen
capture of the filter to do this off-group.
-Todd C.
-----Original Message-----
From: KRGENT@... [mailto:KRGENT@...]
Sent: Monday, September 24, 2001 7:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Calculated field question
Goodmorning,
Could anyone give me the exact expression for a calculated field which would
filter out certain part numbers which are in various ranges.
For example:
list all part numbers only from A001 to A010 and B001 to B010
Also, when filtering the report for this calculation what specifics do I
need
to do ?
Thank You,
Gary
KRG Enterprises
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.adserver.yahoo.com/l?M=168643.1620686.3168692.1261774/D=egroupmai
l/S=1705007183:HM/A=799560/rand=572024662>
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
<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
<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]