how to change a color of particular word in the row in ssrs reports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » how to change a color of particular word in...

22 posts, Page 1 of 3

1 2 3 »»»

how to change a color of particular word in the row in ssrs reports

Rate Topic

Display Mode

Topic Options

Author

Message

vinayak.v

Posted Saturday, February 19, 2011 4:51 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:35 PM
Points: 226, Visits: 156

hi..

i've created an report in which i want to change the color of
the particular word i've four words which i want to change the
color
john,steve,mike,and danial..
for these name where ever they appear in the row the color should change
is it possible..

??

Post #1066767

bulbanos

Posted Sunday, February 20, 2011 12:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 1:27 AM
Points: 45, Visits: 200

I'm not sure, but you could wrap those in words in html tags and render reports in html mode.

My LinkedIn profile

Post #1066881

bhaskar varada

Posted Monday, February 21, 2011 4:52 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, February 21, 2013 8:03 AM
Points: 617, Visits: 228

Hi Vinyak,

you can achieve this by writing a custome code vb.net which checks names in john,steve,mike,and danial ... if present then returns certain value say 1 . based on the value u can change the color of the text

Post #1067028

SQLSmasher

Posted Monday, February 21, 2011 5:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 26, 2011 8:38 AM
Points: 215, Visits: 104

1. do you want to change color of row or word
2. will this word come in any particular column or any of the existing columns

Post #1067032

Marius Jacobs

Posted Monday, February 21, 2011 8:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 6:33 AM
Points: 1, Visits: 168

1. Are these names, field values that are being returned from your db?
2. Are you using SSRS 2008?

Post #1067146

Daniel Bowlin

Posted Monday, February 21, 2011 2:49 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

You can't really control the format of individual words in a text box before SSRS 2008. In 2008 you can use the Create Placeholder option in a text box to create different formating.

If you Google ssrs create placeholder or something like that you should find what you want.

Post #1067333

nandu_2k2003

Posted Monday, February 21, 2011 11:42 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 25, 2013 6:06 AM
Points: 1, Visits: 30

Hi,
you can change their colors.

right click on that particular text box go to properties and click on fill color

in that write following code

iff( field!name.value='Steve',"colorname") if u want for more names then go for switch.

hope this helps you

Post #1067411

vinayak.v

Posted Tuesday, February 22, 2011 12:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:35 PM
Points: 226, Visits: 156

thanku .. nandu it has worked for me..

but can i do in this way.

in single row

[color=#ff0000]steave :[/color] hi good morning [color=#ff0000]jhon[/color] :fine [color=#ff0000]steave[/color]:what are u doing

Post #1067415