Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Bold Text in Formula 2
- Thread starter ruan123
- Start date
-
1
- #2
The only way to do this through one formula is to change the formula to be html text, and then have the formula interpret it as HTML:
Formula code would look like this:
"<html>Is it possible to <b>bold</b> or <u>underline</u> some text in a formula, using Crystal 10?</html>"
Now when you place the formula on the report, right click it, choose Format Field, and then under Paragraph tab, change the Text Interpretation to HTML Text.
~Brian
Formula code would look like this:
"<html>Is it possible to <b>bold</b> or <u>underline</u> some text in a formula, using Crystal 10?</html>"
Now when you place the formula on the report, right click it, choose Format Field, and then under Paragraph tab, change the Text Interpretation to HTML Text.
~Brian
- Thread starter
- #3
Thank you very much, I never knew that you can use html in a formula, but how do you bold for example this,
"Such notice can only be given as from "+{RENTALS.NOTICE_DATE}+" , which is after the first initial (4) (10) months of the Agreement." - where {RENTALS.NOTICE_DATE} must be bold and is an database field.
"Such notice can only be given as from "+{RENTALS.NOTICE_DATE}+" , which is after the first initial (4) (10) months of the Agreement." - where {RENTALS.NOTICE_DATE} must be bold and is an database field.
-
1
- #4
Hi,
OOPS, I left an extra " in that code , and assumed that the Date was a string..:
Should have been:
Sorry 'bout that..
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
OOPS, I left an extra " in that code , and assumed that the Date was a string..:
Should have been:
Code:
"Such notice can only be given as from <b>"+ToText({RENTALS.NOTICE_DATE},'MM/dd/yyyy')+"</b> , which is after the first initial (4) (10) months of the Agreement."Sorry 'bout that..
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Thread starter
- #6
Thanx a lot, saw the ". What is the difference between the ToText and the Cstr functions, I am using Cstr like this -
"Such notice can only be given as from <b>"+Cstr({RENTALS.NOTICE_DATE})+"</b> , which is after the first initial (4) (10) months of the Agreement."
"Such notice can only be given as from <b>"+Cstr({RENTALS.NOTICE_DATE})+"</b> , which is after the first initial (4) (10) months of the Agreement."
- Status
Similar threads
- Locked
- Question
- Locked
- Question