Conditional Font???

[jazerr]

I am in CR8 with MSSQL running in the Background. i am wouldering a few things...

1. What would the syntax be to change font in the middle of a formula? Also any info on sizing and color would be helpful.
2. What is the syntax to insert a 'hard-return' in the formula?

Any help would be great.

 

[kenhamady]

The CHR(13) will put a hard return in a formula, like:

"AAAA" + CHR(13) + "BBBB"


I don't think you can change font/size/color in a formula. However if you have separate formulas, you can drop them all into a text object and within the text object you can conditionally format each formula or field separately. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[malk]

If you are displayin gthe value pf the formula in the report, you can right click on it and setup formulas for font, color, or whatever else you want. This below turns negative values red:
if Sum ({SJTEST_CSV.NET#INCOME#AMT}, {SJTEST_CSV.BILLING#NUMBER}) < 0 then red

I don;t know if this is what you were looking for.