Solved

Format Text in Crystal Report

Posted on 2007-11-14
12
236 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:CochiseCounty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 20282133
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
 
LVL 48

Expert Comment

by:jpaulino
ID: 20282144
Opps! This is in VS2005 i don't know if work in VS2003.

If you cannot drag just try to right it.
0
 

Author Comment

by:CochiseCounty
ID: 20282615
Is there anyway to do something like search for the text Project Description and bold it?
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 48

Expert Comment

by:jpaulino
ID: 20282714
>> 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
 

Author Comment

by:CochiseCounty
ID: 20282794
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
 
LVL 48

Accepted Solution

by:
jpaulino earned 250 total points
ID: 20282866
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
 
LVL 48

Expert Comment

by:jpaulino
ID: 20283616
Correction:

Read:
Ok, now I understand

Instead of:
Ok, not I understand
0
 

Author Comment

by:CochiseCounty
ID: 20284014
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
 
LVL 48

Expert Comment

by:jpaulino
ID: 20284190
Because is not valid!

Have you tried the solution that I have post it.
0
 

Author Comment

by:CochiseCounty
ID: 20284263
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
 
LVL 48

Expert Comment

by:jpaulino
ID: 20284307
You have with the report openned a Database Field toolbar. Add a new formula field for each one.
0
 

Author Comment

by:CochiseCounty
ID: 20292345
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

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB.NET 2008 Winforms Signing 13 41
Input parameteres to DragOver 2 34
ASP.NET MVC -Update model when click on <li> element 29 66
VB.net/VSTO Excel Add-in 2 14
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 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