Crystal Reports Bold part of field

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Bold part of field

Author	Message
Hammerklavier Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 24	Topic: Bold part of field Posted: 27 Oct 2011 at 2:29am
	In my report, I have a customer number. Usually it has six digits, but if there's a seventh digit, I want it to be bold. Is there a way, without creating two separate fields, and without using the <b> tag, to be able to create a formula that will only bold the seventh digit of my customer number? Thank you.
	IP Logged

SamD Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 15	Posted: 27 Oct 2011 at 2:55am
	Right click on the Customer Number field, select 'Format Editor', 'Font' tab click on x2 button for Style. Input this formula: if Length ({Your customer# field name here}) > 6 then CrBold
	IP Logged

Hammerklavier Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 24	Posted: 27 Oct 2011 at 3:03am
	Sam, This formula bolds the entire customer number field. Is there a way to only bold the seventh digit of the field? Thanks.
	IP Logged

SamD Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 15	Posted: 27 Oct 2011 at 3:53am
	Hammerklavier, Sorry, I read what you wrote wrong. Think you would have to break it apart.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 27 Oct 2011 at 4:00am
	DBlank posted a response for an issue like this, and the solution was along these lines: create 2 formulas, 1 for the left 6 digits like: left(totext({table.field},0,""), 6) and another for the rest of the string like: mid(totext({table.field},0,""), 7) place both formulas into 1 text field and mark the second formula as BOLD. when the report runs, only the extra digits will appear bolded. HTH I haven't done this myself, but it seemed a fairly elegant solution to this type of issue.
	IP Logged

Hammerklavier Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 24	Posted: 27 Oct 2011 at 6:51am
	Lockwelle, I appreciate the response, and the solution does work, but I've been asked to do this using only one field and only one formula (without a <b> tag). An odd requirement, I realize, but my boss is convinced this can be accomplished.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 27 Oct 2011 at 7:46am
	well to the best of my knowledge, you can't. CR only works on whole fields....when you are doing things programatically. If you were to type a word into a text field, you can bold any part of the word that you want, but when you want to do things using formulas, it is the whole field, which is why the response was to break the string into 2 fields. HTH
	IP Logged

CircleD Senior Member Joined: 11 Mar 2011 Location: United States Online Status: Offline Posts: 251	Posted: 27 Oct 2011 at 4:26pm
	The only way I can think it might work is to create another section with the 1 field you want and underlay it.You may have to play with the exact placement so it matches the other section.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.