Crystal calculation

Yahoo Archive
1
Use True (no quotes).


-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Wednesday, May 29, 2002 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation


Hey everyone!

I'm creating a calculation in Crystal. It keeps saying that a "Boolean is
required here". I'm not sure what to put in as a Boolean.

My calculation is basically: "If an invoice is open show me the sales minus
the invoice amount, otherwise show me just the sales"

This is the calculation: IIF ({InvcHead.OpenInvoice} =
'y',(({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}) - {InvcDtl.ExtPrice}),
({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}))

I believe that it needs to be where I have my little 'y' letter. But, I'm
not sure what a Boolean is and why I need it.

Thanks!


Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[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/.
<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]
2
Hey everyone!

How would I set up a parameter/formula in Crystal for it to only include alpha characters? We are setting up our unattended machine time as alpha character employees. So I only want the report to pull in unattended employees with alpha characters as their ID.

Any suggestions?

Thanks!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

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

If your unattended IDs are something like "M25" and normal employee IDs
"39", it seems to me that you could just use "Select Expert", add
EmployeeNum (or whatever the actual field name) formula: > "99999999". This
should do the trick because in ASCII collation sequences, Alpha characters
sort after numeric characters.

HTH
Jim Stetter
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Monday, March 25, 2002 10:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation


Hey everyone!

How would I set up a parameter/formula in Crystal for it to only include
alpha characters? We are setting up our unattended machine time as alpha
character employees. So I only want the report to pull in unattended
employees with alpha characters as their ID.

Any suggestions?

Thanks!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

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


Yahoo! Groups Sponsor
ADVERTISEMENT




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.



[Non-text portions of this message have been removed]
4
Wendy this might work numeric text function. Look at the sample formula at
the bottom of the help file. I would personally be inclined to create a user
defined field or another unused field and use that in my filter.

Dan Shallbetter
States Electric. Mfg.



-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Monday, March 25, 2002 9:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation


Hey everyone!

How would I set up a parameter/formula in Crystal for it to only include
alpha characters? We are setting up our unattended machine time as alpha
character employees. So I only want the report to pull in unattended
employees with alpha characters as their ID.

Any suggestions?

Thanks!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

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





[Non-text portions of this message have been removed]
5
If NumericText ({file.FIELD}) Then
ToNumber ({file.FIELD})
Else
0


A variation of the above example may work for you.

In the Record Selection Formula include a line like

NumericText ({WrkCenter.WCCode}) = False

This would exclude all records that are completely numeric in nature.

Is that what you wanted?

Jim Carnes
IS Administrator
Kenlee Precision Corp
jcarnes@...
1700 Morrell Park Ave
Baltimore, MD 21230

-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Monday, March 25, 2002 10:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation

Hey everyone!

How would I set up a parameter/formula in Crystal for it to only include
alpha characters? We are setting up our unattended machine time as alpha
character employees. So I only want the report to pull in unattended
employees with alpha characters as their ID.

Any suggestions?

Thanks!

Wendy Bowen



[Non-text portions of this message have been removed]
6
Mike, Jim S, Dan, & Jim C,

Thanks! All the suggestions helped!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
----- Original Message -----
From: Jim Carnes
To: vantage@yahoogroups.com
Sent: Monday, March 25, 2002 2:55 PM
Subject: RE: [Vantage] crystal calculation


If NumericText ({file.FIELD}) Then
ToNumber ({file.FIELD})
Else
0


A variation of the above example may work for you.

In the Record Selection Formula include a line like

NumericText ({WrkCenter.WCCode}) = False

This would exclude all records that are completely numeric in nature.

Is that what you wanted?

Jim Carnes
IS Administrator
Kenlee Precision Corp
jcarnes@...
1700 Morrell Park Ave
Baltimore, MD 21230

-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Monday, March 25, 2002 10:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation

Hey everyone!

How would I set up a parameter/formula in Crystal for it to only include
alpha characters? We are setting up our unattended machine time as alpha
character employees. So I only want the report to pull in unattended
employees with alpha characters as their ID.

Any suggestions?

Thanks!

Wendy Bowen



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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.


[Non-text portions of this message have been removed]
7
Hey everyone!

I'm creating a calculation in Crystal. It keeps saying that a "Boolean is required here". I'm not sure what to put in as a Boolean.

My calculation is basically: "If an invoice is open show me the sales minus the invoice amount, otherwise show me just the sales"

This is the calculation: IIF ({InvcHead.OpenInvoice} = 'y',(({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}) - {InvcDtl.ExtPrice}), ({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}))

I believe that it needs to be where I have my little 'y' letter. But, I'm not sure what a Boolean is and why I need it.

Thanks!


Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

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