Format Text in Crystal Report

I have a crystal report file that goes together with Visual Studio .NET
In the Crystal report, there is only one field and the field is come from the database, the data in the field looks like this

Project Description: aaaaaaaaa
POC: bbbbbbbbbbb
Notes: ccccccccc

What I need is the text 'Project Description', 'POC', 'Notes' to be bold. how do I do that?

Thanks for help
CochiseCountyAsked:
Who is Participating?
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
Ok, not I understand. You can create a new formula field and split the string

split({table.field},",")[0]   'This will retrieve the Project Description
split({table.field},",")[1]   'This will retrieve the value like aaaaaaaaa

Add the two formula fields to your detail section and format the first one as bold.

This work fine, at least in VS2005
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
You can add the labels and set the font as you want. Then drag from the database fiels the field into the label an format the field as you wish.

You will have something like this:

Project Description: {aaaaaaaaa}
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
Opps! This is in VS2005 i don't know if work in VS2003.

If you cannot drag just try to right it.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
CochiseCountyAuthor Commented:
Is there anyway to do something like search for the text Project Description and bold it?
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
>> Is there anyway to do something like search for the text Project Description and bold it?

Did you check if the solution that I have post it works in 2003. If so you can select the Project Description and bolt it without bolting the field.

Another solution is to add one label and one field
0
 
CochiseCountyAuthor Commented:
Hi jpaulino,
I think I didn't explain clearly enough,
In the details section of the Crystal report, there is only 1 fileld, and the field come from the database, so there is no way for me to highlight the text Project Description or POC or Notes to bold them.
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
Correction:

Read:
Ok, now I understand

Instead of:
Ok, not I understand
0
 
CochiseCountyAuthor Commented:
OK, let me ask you something, in my SQL statement, if I have something like
SELECT <b>Project Description</b>: aaaaaaaaa
<i>POC</i>: bbbbbbbbbbb
<b>Notes</b>: ccccccccc as Data

When I display this Data field in Crystal Report, it still show the html code, eventhough I change the text interpreter to html. Why?
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
Because is not valid!

Have you tried the solution that I have post it.
0
 
CochiseCountyAuthor Commented:
OK, where do I put this
split({table.field},",")[0]   'This will retrieve the Project Description
split({table.field},",")[1]   'This will retrieve the value like aaaaaaaaa

I am new with CR, please help in details. Thanks a lot
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
You have with the report openned a Database Field toolbar. Add a new formula field for each one.
0
 
CochiseCountyAuthor Commented:
Hi jpaulino,
Thanks for your help, I found another solution for my problem, anyway, I learned i thing new from you about the formula field. Thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.