Change font using formula.(Crystal Rep)

Yahoo Archive
1
example: I have a word "BART" and it's in arial now I want to change only "A" for new font example symbol.... and it should be "B(a in symbol)RT"

thank you.

sarah.vareschi@... wrote:
Can you give and example what you would start with and want to end up
with?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 3:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Ok, Another question is How to change One letter in word for symbol
example :) . I try use Replace() function and doesn't work... any other
idea?

Thanks for everybody for help !!

"Hernandez, Dolores" <dhernandez@...> wrote:
Ex: if {checkhed.Voided} = True then "Times New Roman"

Or

If {checkhed.checkAmt} . 100.00 then "Times New Roman"

If you need more help, maybe you can send me specifics off line and we
can work from there.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Yeah, I know about that, but still doesn't work If you can give me any
example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...
<mailto:dhernandez%40energycranes.com> > wrote:
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com> <http://mail.yahoo.com
<http://mail.yahoo.com> >

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

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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

<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________<DIV><FONT>




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
2
Hello,
Is anybody know, How to change font conditionaly , using formula in Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
3
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Change font using formula.(Crystal Rep)



Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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





[Non-text portions of this message have been removed]
4
Yeah, I know about that, but still doesn't work If you can give me any example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...> wrote:
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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

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





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
5
Here is one that we use on our PO report EXTCOST field for the font
color:
if {podetail.EXTCOST} = 0 then red else black

And here's an example of the same field for changing font type:
if{podetail.EXTCOST} > 100 then "Garamond" else "Courier"


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 2:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Yeah, I know about that, but still doesn't work If you can give me any
example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...> wrote:
If you want to conditionally change font on a field, just
right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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

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





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
6
Ex: if {checkhed.Voided} = True then "Times New Roman"

Or

If {checkhed.checkAmt} . 100.00 then "Times New Roman"



If you need more help, maybe you can send me specifics off line and we
can work from there.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)



Yeah, I know about that, but still doesn't work If you can give me any
example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...
<mailto:dhernandez%40energycranes.com> > wrote:
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com> <http://mail.yahoo.com
<http://mail.yahoo.com> >

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

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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





[Non-text portions of this message have been removed]
7
Ok, Another question is How to change One letter in word for symbol example :) . I try use Replace() function and doesn't work... any other idea?

Thanks for everybody for help !!

"Hernandez, Dolores" <dhernandez@...> wrote:
Ex: if {checkhed.Voided} = True then "Times New Roman"

Or

If {checkhed.checkAmt} . 100.00 then "Times New Roman"

If you need more help, maybe you can send me specifics off line and we
can work from there.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Yeah, I know about that, but still doesn't work If you can give me any
example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...
<mailto:dhernandez%40energycranes.com> > wrote:
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com> <http://mail.yahoo.com
<http://mail.yahoo.com> >

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

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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

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





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
8
Can you give and example what you would start with and want to end up
with?


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 3:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Ok, Another question is How to change One letter in word for symbol
example :) . I try use Replace() function and doesn't work... any other
idea?

Thanks for everybody for help !!

"Hernandez, Dolores" <dhernandez@...> wrote:
Ex: if {checkhed.Voided} = True then "Times New Roman"

Or

If {checkhed.checkAmt} . 100.00 then "Times New Roman"

If you need more help, maybe you can send me specifics off line and we
can work from there.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Change font using formula.(Crystal Rep)

Yeah, I know about that, but still doesn't work If you can give me any
example which is working it will be more helpful..

Thank you very much.

"Hernandez, Dolores" <dhernandez@...
<mailto:dhernandez%40energycranes.com> > wrote:
If you want to conditionally change font on a field, just right click on
that field, go to the font tab, click on the x-2 button next to font and
put in you conditional formula. You can select which font you want to
change it to by selecting the fonts from the function window.

Hope this helps.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bartosz Niemczewski
Sent: Wednesday, October 17, 2007 12:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Change font using formula.(Crystal Rep)

Hello,
Is anybody know, How to change font conditionaly , using formula in
Crystal Reports?

Thank you,

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com> <http://mail.yahoo.com
<http://mail.yahoo.com> >

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

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

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

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





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>