Crystal formula error

Try to rewrite it as

({SerialNo.SNStatus} in ["INVENTORY"]) and
(not {SerialNo.Scrapped}) and
(not {SerialNo.Voided}) and
(not {SerialNo.PartNum} in ["0700-028", "0700-029", "0702-001", "0702-
002", "0703-182", "0703-183"]) and
({Part.ProdCode} in ["CUCA", "PTRK", "RCMA", "SRMA"])


_____

From: how2wow [mailto:mhow@...]
Sent: Sunday, April 02, 2006 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal formula error


I know there have been several posts on this- including my own- but I
guess I just don't understand how I have to rewrite a formula when I
add criteria. I had a report that worked fine, just added another
product group to include. It won't include it. I've tried altering
this formula many, many times. What is wrong with it?

({SerialNo.SNStatus}) in ["INVENTORY"] and
not ({SerialNo.Scrapped}) and
not ({SerialNo.Voided}) and
not ({SerialNo.PartNum} in ["0700-028", "0700-029", "0702-001", "0702-
002", "0703-182", "0703-183"]) and
{Part.ProdCode} in ["CUCA", "PTRK", "RCMA", "SRMA"]





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




SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

_____

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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 know there have been several posts on this- including my own- but I
guess I just don't understand how I have to rewrite a formula when I
add criteria. I had a report that worked fine, just added another
product group to include. It won't include it. I've tried altering
this formula many, many times. What is wrong with it?

({SerialNo.SNStatus}) in ["INVENTORY"] and
not ({SerialNo.Scrapped}) and
not ({SerialNo.Voided}) and
not ({SerialNo.PartNum} in ["0700-028", "0700-029", "0702-001", "0702-
002", "0703-182", "0703-183"]) and
{Part.ProdCode} in ["CUCA", "PTRK", "RCMA", "SRMA"]