on 06-18-2009 4:04 PM
Hello,
I would like to underline only one field within a string of fields in a report formula.
For example if my formula is:
{Objects.title}", "{Objects.Dated}", "{Objects.Number}
What syntax do I use to underline {Object.title} only, so that the formula returns:
Objects.Title, Object.Date, Objects.Number
Thank you,
CL
If all you are doing in that formula is concatenating fields, then I suggest you place those fields into a text box along with the commas and spaces and then select just the first field and click on underline.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is no specific function or syntax to underline a portion of a formula. I know you said you were aware of many workarounds but I'll throw this one out anyway.
Add the underline HTML tags to the formula;
+ '<u>' + + </u> + Enable the Format option HTML Text Interpretation for that formula. of course the forum interpretted the html tags; & '<u>' & & '</u>' &
Edited by: Graham Cunningham on Jun 18, 2009 9:37 AM
Thanks Graham, I've read about this, and have tried it, but never successfully got it to work. I'm not sure what I'm doing wrong. When I add the tags, Crystal tells me there is an error in my formula, "the remaining text does not appear to be part of the formula" I've changed the text interpretation to HTML. Is there something I'm missing?
Thanks.
{Objects.title} & ", " & "<u>" & {Objects.Dated} & "</u>" & ", " & {Objects.Number};
Place the formula in your report and right click and format field and under the paragraph tab change the text interpretation to HTML Text.
That should change that one field to underlined.
Edited by: Sanjay Kodidine on Jun 18, 2009 11:23 AM
It does work.
Write a formula field naming Underline_Test.
For example: "u within angle brackets" & {DBTABLE.DBCOLUMN} & "/u within angle brackets"
Steps to follow:
1. Place the formula field Underline_Test into the report.
2. Then right click the field and select format field then opens Format Editor.
3. Navigate the paragraph, in the Text Interpretation select HTML Text.
4. Then click 'OK'.
Now you will be able to see the field underlined.
Edited by: ananth2009 on Jun 19, 2009 1:44 PM
Edited by: ananth2009 on Jun 19, 2009 1:44 PM
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.