More crystal help needed

Yahoo Archive
1
This is mine and it works fine. I named my formula unitpricedesc

if {quoteqty.UNITPRICE} = 0 then "No Charge"
else if {quoteqty.UNITPRICE} = .01 then "To be Determined"
else if {quoteqty.UNITPRICE} = .02 then "Customer Supplied"
else ' '
2
Sorry, I have yet another Crystal Reports Question



I am trying to write an "if" statement. What I want it to do is - if my
price is .01 then instead of .01 I want it to say "To Be Determined" instead
of .01 Which I thought I could accomplish this by the following



if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''





But I get "To be Determined" written over the .01. Any idea's?



Thanks..





Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com





[Non-text portions of this message have been removed]
3
Did you place the QuoteQty.UnitPrice on top of the formula field on
the report?


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Sorry, I have yet another Crystal Reports Question
>
>
>
> I am trying to write an "if" statement. What I want it to do is -
if my
> price is .01 then instead of .01 I want it to say "To Be
Determined" instead
> of .01 Which I thought I could accomplish this by the following
>
>
>
> if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
>
>
>
>
>
> But I get "To be Determined" written over the .01. Any idea's?
>
>
>
> Thanks..
>
>
>
>
>
> Have a Nice Day,
>
>
>
> Dina Hieber
>
> Vamco International, Inc.
>
> Phone (412) 963-7100
>
> Fax; (412) 963-7160
>
>
>
> www.vamcointernational.com
>
>
>
>
>
> [Non-text portions of this message have been removed]
4
You will need to also change the formula behind the field that is displaying
the .01 so that it prints '' if unitprice = .01


-----Original Message-----
From: dhieber [mailto:dhieber@...]
Sent: January 05, 2005 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] MORE CRYSTAL HELP NEEDED


Sorry, I have yet another Crystal Reports Question



I am trying to write an "if" statement. What I want it to do is - if my
price is .01 then instead of .01 I want it to say "To Be Determined" instead
of .01 Which I thought I could accomplish this by the following



if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''





But I get "To be Determined" written over the .01. Any idea's?



Thanks..





Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com





[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
5
Yes. But I have also placed a "not quoted" on top of the field. I can get
this statement to work for a zero but no other number. I was going to use
the following

0 = No Charge
.01 = To Be Determined
.02 = Customer supplied

Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com

-----Original Message-----
From: fselliott1 [mailto:fselliott1@...]
Sent: Wednesday, January 05, 2005 2:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED



Did you place the QuoteQty.UnitPrice on top of the formula field on
the report?


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Sorry, I have yet another Crystal Reports Question
>
>
>
> I am trying to write an "if" statement. What I want it to do is -
if my
> price is .01 then instead of .01 I want it to say "To Be
Determined" instead
> of .01 Which I thought I could accomplish this by the following
>
>
>
> if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
>
>
>
>
>
> But I get "To be Determined" written over the .01. Any idea's?
>
>
>
> Thanks..
>
>
>
>
>
> Have a Nice Day,
>
>
>
> Dina Hieber
>
> Vamco International, Inc.
>
> Phone (412) 963-7100
>
> Fax; (412) 963-7160
>
>
>
> www.vamcointernational.com
>
>
>
>
>
> [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
6
Try making just one field with multilple if statements and remove
the QuoteQty.Unitprice from the report all together. Something like
this.

if QuoteQty.UnitPrice = 0 then "No charge"
else if QuoteQty.Uniprice = .01 then "To be Determined"
else if QuoteQty.Unitprice = .02 then "Customer Supplied"
else ' '

Use just that formula field on the report.


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Yes. But I have also placed a "not quoted" on top of the field. I
can get
> this statement to work for a zero but no other number. I was
going to use
> the following
>
> 0 = No Charge
> .01 = To Be Determined
> .02 = Customer supplied
>
> Have a Nice Day,
>
> Dina Hieber
> Vamco International, Inc.
> Phone (412) 963-7100
> Fax; (412) 963-7160
>
> www.vamcointernational.com
>
> -----Original Message-----
> From: fselliott1 [mailto:fselliott1@y...]
> Sent: Wednesday, January 05, 2005 2:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED
>
>
>
> Did you place the QuoteQty.UnitPrice on top of the formula field
on
> the report?
>
>
> --- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> > Sorry, I have yet another Crystal Reports Question
> >
> >
> >
> > I am trying to write an "if" statement. What I want it to do
is -
> if my
> > price is .01 then instead of .01 I want it to say "To Be
> Determined" instead
> > of .01 Which I thought I could accomplish this by the following
> >
> >
> >
> > if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
> >
> >
> >
> >
> >
> > But I get "To be Determined" written over the .01. Any idea's?
> >
> >
> >
> > Thanks..
> >
> >
> >
> >
> >
> > Have a Nice Day,
> >
> >
> >
> > Dina Hieber
> >
> > Vamco International, Inc.
> >
> > Phone (412) 963-7100
> >
> > Fax; (412) 963-7160
> >
> >
> >
> > www.vamcointernational.com
> >
> >
> >
> >
> >
> > [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
7
Look at the formula behind your unit price field, you will need to modify
this so that it displays '' for 0, .01 and .02 (the default formula displays
'' for 0 only)


-----Original Message-----
From: dhieber [mailto:dhieber@...]
Sent: January 05, 2005 2:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: MORE CRYSTAL HELP NEEDED


Yes. But I have also placed a "not quoted" on top of the field. I can get
this statement to work for a zero but no other number. I was going to use
the following

0 = No Charge
.01 = To Be Determined
.02 = Customer supplied

Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com

-----Original Message-----
From: fselliott1 [mailto:fselliott1@...]
Sent: Wednesday, January 05, 2005 2:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED



Did you place the QuoteQty.UnitPrice on top of the formula field on
the report?


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Sorry, I have yet another Crystal Reports Question
>
>
>
> I am trying to write an "if" statement. What I want it to do is -
if my
> price is .01 then instead of .01 I want it to say "To Be
Determined" instead
> of .01 Which I thought I could accomplish this by the following
>
>
>
> if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
>
>
>
>
>
> But I get "To be Determined" written over the .01. Any idea's?
>
>
>
> Thanks..
>
>
>
>
>
> Have a Nice Day,
>
>
>
> Dina Hieber
>
> Vamco International, Inc.
>
> Phone (412) 963-7100
>
> Fax; (412) 963-7160
>
>
>
> www.vamcointernational.com
>
>
>
>
>
> [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











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
8
I receive an error "a number, currency amount, Boolean date, time and
date-time or string is expected here.

I removed "@unitprice" from the form and attempted your formula.



Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com

-----Original Message-----
From: fselliott1 [mailto:fselliott1@...]
Sent: Wednesday, January 05, 2005 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED



Try making just one field with multilple if statements and remove
the QuoteQty.Unitprice from the report all together. Something like
this.

if QuoteQty.UnitPrice = 0 then "No charge"
else if QuoteQty.Uniprice = .01 then "To be Determined"
else if QuoteQty.Unitprice = .02 then "Customer Supplied"
else ' '

Use just that formula field on the report.


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Yes. But I have also placed a "not quoted" on top of the field. I
can get
> this statement to work for a zero but no other number. I was
going to use
> the following
>
> 0 = No Charge
> .01 = To Be Determined
> .02 = Customer supplied
>
> Have a Nice Day,
>
> Dina Hieber
> Vamco International, Inc.
> Phone (412) 963-7100
> Fax; (412) 963-7160
>
> www.vamcointernational.com
>
> -----Original Message-----
> From: fselliott1 [mailto:fselliott1@y...]
> Sent: Wednesday, January 05, 2005 2:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED
>
>
>
> Did you place the QuoteQty.UnitPrice on top of the formula field
on
> the report?
>
>
> --- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> > Sorry, I have yet another Crystal Reports Question
> >
> >
> >
> > I am trying to write an "if" statement. What I want it to do
is -
> if my
> > price is .01 then instead of .01 I want it to say "To Be
> Determined" instead
> > of .01 Which I thought I could accomplish this by the following
> >
> >
> >
> > if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
> >
> >
> >
> >
> >
> > But I get "To be Determined" written over the .01. Any idea's?
> >
> >
> >
> > Thanks..
> >
> >
> >
> >
> >
> > Have a Nice Day,
> >
> >
> >
> > Dina Hieber
> >
> > Vamco International, Inc.
> >
> > Phone (412) 963-7100
> >
> > Fax; (412) 963-7160
> >
> >
> >
> > www.vamcointernational.com
> >
> >
> >
> >
> >
> > [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





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
9
Frank,

Forget it -- Your statement worked. I had a blonde moment. Thank you for
all your help. You saved me a lot of work.


Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com

-----Original Message-----
From: dhieber [mailto:dhieber@...]
Sent: Wednesday, January 05, 2005 2:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: MORE CRYSTAL HELP NEEDED


I receive an error "a number, currency amount, Boolean date, time and
date-time or string is expected here.

I removed "@unitprice" from the form and attempted your formula.



Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com

-----Original Message-----
From: fselliott1 [mailto:fselliott1@...]
Sent: Wednesday, January 05, 2005 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED



Try making just one field with multilple if statements and remove
the QuoteQty.Unitprice from the report all together. Something like
this.

if QuoteQty.UnitPrice = 0 then "No charge"
else if QuoteQty.Uniprice = .01 then "To be Determined"
else if QuoteQty.Unitprice = .02 then "Customer Supplied"
else ' '

Use just that formula field on the report.


--- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> Yes. But I have also placed a "not quoted" on top of the field. I
can get
> this statement to work for a zero but no other number. I was
going to use
> the following
>
> 0 = No Charge
> .01 = To Be Determined
> .02 = Customer supplied
>
> Have a Nice Day,
>
> Dina Hieber
> Vamco International, Inc.
> Phone (412) 963-7100
> Fax; (412) 963-7160
>
> www.vamcointernational.com
>
> -----Original Message-----
> From: fselliott1 [mailto:fselliott1@y...]
> Sent: Wednesday, January 05, 2005 2:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MORE CRYSTAL HELP NEEDED
>
>
>
> Did you place the QuoteQty.UnitPrice on top of the formula field
on
> the report?
>
>
> --- In vantage@yahoogroups.com, "dhieber" <dhieber@v...> wrote:
> > Sorry, I have yet another Crystal Reports Question
> >
> >
> >
> > I am trying to write an "if" statement. What I want it to do
is -
> if my
> > price is .01 then instead of .01 I want it to say "To Be
> Determined" instead
> > of .01 Which I thought I could accomplish this by the following
> >
> >
> >
> > if {QuoteQty.UnitPrice} = .01 then '(To Be Determined)' else ''
> >
> >
> >
> >
> >
> > But I get "To be Determined" written over the .01. Any idea's?
> >
> >
> >
> > Thanks..
> >
> >
> >
> >
> >
> > Have a Nice Day,
> >
> >
> >
> > Dina Hieber
> >
> > Vamco International, Inc.
> >
> > Phone (412) 963-7100
> >
> > Fax; (412) 963-7160
> >
> >
> >
> > www.vamcointernational.com
> >
> >
> >
> >
> >
> > [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





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











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