Hi,

I want to change my text box text colour for following ;

MY data was:

column name:  NAme

Unitedstatesofamerica

america state

Northamerica

southamerica

America should be bold and red colour.

I want to write expression to BOLD and change colour in ssrs for America

Thanks

AVS

You might have to use 3 different expressions for this:

1st expression will show any value that does not have "america" as is.  If "america" is in it, it'll show only the left side:

=IIf(InStr(Fields!NAme.Value, "america") = 0, Fields!NAme.Value, Left(Fields!NAme.Value, InStr(Fields!NAme.Value, "america")-1))

2nd expression (which you will have to specify set the font as Bold and Red):

=IIf(InStr(Fields!NAme.Value, "america") = 0, NOTHING, "america")

3rd expression will show the right side of the string after "america":

=IIf(InStr(Fields!NAme.Value, "america") = 0, NOTHING, Right(Fields!NAme.Value, Len(Fields!NAme.Value) - (Len(Left(Fields!NAme.Value, InStr(Fields!NAme.Value, "america")-1)) + 7)))

Both the 2nd and 3rd expressions will not have any string shown if the text does not have the word "america" in it.

Hopefully this helps!

• Edited by yosedesh 39 minutes ago Grammar errors.

my requirement is I have a string America

I need to change er : Bold and need to change clour using HTMLPlace holders

Result:

i/p :America

o/p:America

i/p: India

o/p: India

Thanks

AVS