OK
I have encountered this too. You have to enclose all in parenthesis but
"and's".
See below:
({%OpenRelease}) and
(IF {?CustID} <> "All" Then {Customer.CustID} = {?CustID} Else True) and
(IF {?TerritoryID} <> "All" Then {Customer.TerritoryID} = {?TerritoryID}
Else True)
Adam Gwizdz
Database Manager
Main Tape Company
_____
From: how2wow [mailto:
mhow@...]
Sent: Thursday, March 23, 2006 10:58 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal 10 w/ Parameters & Select Criteria (V8)
I'm hoping there are some Crystal experts out here who can help me,
as I've exhausted my resources!
I wrote a report to show open orders by product code. I have three
criteria- OrdDtl-OpenLine= True, OrdHed-OpenOrd=True, and OrdDtl-
Prod.Code "is one of". I also have a parameter set up for Cust ID.
I had put this report on the Vantage menu and everything was working
great. Then we added a new product code that we wanted to include
in the report. As soon as I did this in select criteria, it "grayed
out" the screens on all of the select criteria. The only way to
make any more changes would be to edit the formula. Now, when we
run the report, it works fine if we select "all" customer ID's, but
if we enter just one, it ignores the criteria and gives us
everything!
I've tried everything I can think of... what am I missing?
I'd appreciate ANY ideas!
Thanks,
Missi How
Operations Accountant
ASV, Inc.
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]