Click here to Skip to main content
15,851,902 members
Please Sign up or sign in to vote.
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
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

 
Share this answer
 
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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900