How To Font Bold in Crystal Report

Question

0.00/5 (No votes)

See more:

Hi All

Here my problem is in crystal report, i have Bind two location in in one Coloumn using new line("\n"), here i'm using formula for bold font in crystal report like

SQL

if {DataTable1.DataColumn1} ="YES"
then
if {DataTable1.col1} = {DataTable1.DataColumn2} /// DataTable1.col1= J4+"\n\n"+J3
then     /// here i stored location which i want to bold in DataTable1.DataColumn2
crRegular
else
crBold
else
crRegular

when i use this formula it show all bold

How can i do this....
Thanks !

Posted 9-Mar-15 21:47pm

prasanna.raj

Add a Solution

Comments

Sinisa Hajnal 10-Mar-15 7:06am

Try putting command separators (;) and/or end ifs so you don't get two elses in the same block. I admit I didn't work with formulas for a year now, but I remember nested ifs behaving strangely if you're not careful.

prasanna.raj 10-Mar-15 9:01am

http://stackoverflow.com/questions/11184169/nested-if-else-in-crystal-reports

Maciej Los 10-Mar-15 15:38pm

Sounds like an answer... ;)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-03-10T09:40:00

Solution 1

Have a look here:
http://stackoverflow.com/questions/9588396/how-to-change-font-color-based-off-database-result[^]
http://stackoverflow.com/questions/9125041/change-color-of-text-object-using-formula-in-crystal-reports[^]

Posted 10-Mar-15 9:40am

Maciej Los

Comments

prasanna.raj 11-Mar-15 0:44am

nice but i have refer this site previously, i think u didn't understand my prob, actually from dynamic datatable it stored like (J1\n\nJ3), it bind in crystal report like this na

J1
J3

i want change color or font style for J3 location.

how to do that...

thanks !

Maciej Los 11-Mar-15 2:35am

Your "prob" (as you write it) is still not clear. Try to describe it better. Use "Improve question" widget.

prasanna.raj 11-Mar-15 3:06am

simply i l explain, i have data like (str1 \n\n str2), how to bold str2 or str1

prasanna.raj 11-Mar-15 3:22am

please find this link i ask again

http://www.codeproject.com/Questions/885109/How-to-Split-Text-in-Crystal-Report-Formula