[Last Call] Learn how to a build a cloud-first strategyRegister Now


How to make first field in crystal report 8.5 formula bold containing concatenation more than two fields

Posted on 2004-11-23
Medium Priority
Last Modified: 2012-08-13
   i am using crystal report 8.5 and have formula which
 contains two fields like @emp_data (formula)
 which contains two fields
 ({emp.emp_name}) + ' ' + ({emp.emp_add})

 i want ({emp.emp_name})  should appear in bold
 while rest in i.e. ({emp.emp_add})
in normal character.

 i have tried with paragraph formatting to html text
 but its giving error in formula as well as truncating rest part i.e. address.
Also , doing bold the whole formula is not i want.

hope to get answer soon...


Question by:sensitive
  • 3
  • 2
LVL 13

Accepted Solution

vidru earned 750 total points
ID: 12662591
This works with CR 8 and 9, so I assume it will work in 8.5:

"<b>" + {emp.emp_name} + "</b> - " + {emp.emp_add}

As long as both fields are strings, and the length of the strings combined is <= 254 characters, that should work.


Author Comment

ID: 12663039
hi dave
  thanx 4 takin interest . i have tried it
but its not working infact it is concatting with
like output:
<b> John</b>- A 77 .....
i have tried this with paragraph formatting
option with text to html as well as none option
out put is same.
Any other way
LVL 13

Expert Comment

ID: 12665075
Place a text object onto the report, and make it as wide as {emp.emp_name} + ' ' + {emp.emp_add} can be.  Put the {emp.emp_name} field on the report, make it bold, then drag it into the text object.  Put your cursor in the text object after {emp.emp_name}, and put a space.  Then, just drag the {emp.emp_add} field into the text object.



Author Comment

ID: 12671999
hi dave

   wat u have told me this time was doing earlier
 there was problem with formatting as name
 was taking sometimes 2 lines while address
 sometimes was taking more than allocated
 space thats why i have to combine them in
 formula with address starting from new line
 Here in formula only problem i faced was
 bolding of first field i.e. name here.

 as with html syntax am i missing something
 thats why it taking as string combining with name
 wat do u say.....


Author Comment

ID: 12713154
hi dave
           i have accepted ur paragraph formatting
 ans but its not working with same version of
 crystal report 8.5 on required  machine
 any reason!!!!!!!!!!1


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question