Crystal 10 w/ Parameters & Select Criteria (V8)

Yahoo Archive
1
Thanks, Adam... it worked!!!

--- In vantage@yahoogroups.com, "Gwizdz, Adam" <Adam.Gwizdz@...>
wrote:
>
> Try this:
>
> (if {?Customer ID} <> "all" then {Customer.CustID} = {?Customer
ID} else
> true) and
> ({OrderDtl.OpenLine}) and
> ({OrderHed.OpenOrder}) and
> ({OrderDtl.ProdCode} in ["SRMA", "SRAC", "PTAC", "PTRK", "RCAC",
> "RCMA"])
> _____
>
> From: how2wow [mailto:mhow@...]
> Sent: Thursday, March 23, 2006 11:21 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal 10 w/ Parameters & Select Criteria
(V8)
>
>
> Here is my formula. Can you show me how you would edit it?
>
> if not ("all" in {?Customer ID}) then {Customer.CustID} = {?
Customer
> ID} else true and
> {OrderDtl.OpenLine} and
> {OrderHed.OpenOrder} and
> {OrderDtl.ProdCode} in
> ["SRMA", "SRAC", "PTAC", "PTRK", "RCAC", "RCMA"]
>
2
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.
3
I THINK! It might be an expression now and you have to use the formula
editor or report-selection - EITHER group or record selection.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of how2wow
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
Yahoo! Groups Links
4
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]
5
Here is my formula. Can you show me how you would edit it?

if not ("all" in {?Customer ID}) then {Customer.CustID} = {?Customer
ID} else true and
{OrderDtl.OpenLine} and
{OrderHed.OpenOrder} and
{OrderDtl.ProdCode} in
["SRMA", "SRAC", "PTAC", "PTRK", "RCAC", "RCMA"]

--- In vantage@yahoogroups.com, "Gwizdz, Adam" <Adam.Gwizdz@...>
wrote:
>
> 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+so
ftw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase
> +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+mortg
age
>
+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+mortgag
e+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata
> 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+sof
twa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+
> 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+mortg
age
>
+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+mortga
ge+
>
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]
>
6
Try this:

(if {?Customer ID} <> "all" then {Customer.CustID} = {?Customer ID} else
true) and
({OrderDtl.OpenLine}) and
({OrderHed.OpenOrder}) and
({OrderDtl.ProdCode} in ["SRMA", "SRAC", "PTAC", "PTRK", "RCAC",
"RCMA"])


_____

From: how2wow [mailto:mhow@...]
Sent: Thursday, March 23, 2006 11:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 10 w/ Parameters & Select Criteria (V8)


Here is my formula. Can you show me how you would edit it?

if not ("all" in {?Customer ID}) then {Customer.CustID} = {?Customer
ID} else true and
{OrderDtl.OpenLine} and
{OrderHed.OpenOrder} and
{OrderDtl.ProdCode} in
["SRMA", "SRAC", "PTAC", "PTRK", "RCAC", "RCMA"]

--- In vantage@yahoogroups.com, "Gwizdz, Adam" <Adam.Gwizdz@...>
wrote:
>
> 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+so
ftw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase
> +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+mortg
age
>
+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+mortgag
e+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata
> 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+sof
twa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+
> 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+mortg
age
>
+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+mortga
ge+
>
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]
>







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