Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Set font to bold if an entry has a particular value Expand / Collapse
Author
Message
Posted Friday, July 25, 2014 8:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:39 AM
Points: 3, Visits: 8
Hi

Trying to work out if this is possible, the customer enters a string of text into a text field, they want to be able to change the font to display in bold on the report but only for a word in the string of text is in brackets

For example, they enter into the form

This child is causing (problems) which they want reporting services to display as

This child is causing problems

Was hoping to use an IIF command using the Like expression but not sure if it will work!

Thanks in advance
Post #1596242
Posted Friday, July 25, 2014 10:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 69, Visits: 734
You can try to change the Placeholder Properties to use HTML instead of plain text.

1: Replace your brackets with <B>, </B> - Replace(Replace(Text, "(", "<B>"), ")","</B>")
2: Highlight your expression, right click and select Placeholder properties
3: Select HTML as your markup type
Post #1596315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse