Dynamic color of font for single wordin large texts

Question

Dynamic color of font for single wordin large texts

orenk

Old Hand

Points: 388
More actions
December 6, 2016 at 8:41 am

#316605

Hey,
how can I set the color of the font of a singe word in large texts? like IIF(....,"MY_TEXT","Red","Black"). see attachment
I want to highlight word I am tearching for.
Thanks for help
Olaf

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

doug.brown SSCertifiable Points: 5608 More actions · Answer 1

Here are a couple of articles to peruse:

http://social.technet.microsoft.com/wiki/contents/articles/18748.ssrs-multi-font-color-multi-font-size-within-a-single-field-textbox.aspx

http://www.sqlchick.com/entries/2010/10/31/using-different-formats-within-a-single-textbox-in-ssrs.html

orenk Old Hand Points: 388 More actions · Answer 2

Hey SSC Veteran,

thanks for the inspiration. HTML tags and some SQL like

select left(convert(varchar(max),anweisungen),CHARINDEX(@Schlagwort,Anweisungen)-1) +'<B><U>' +@Schlagwort+ '</B></U>' +substring(anweisungen,CHARINDEX(@Schlagwort,Anweisungen) + LEN(@Schlagwort),9000) as...

and I am happy 😀

Regards

Olaf