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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 4, 2014 9:24 AM
Points: 11, Visits: 17
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 This worked for the OP Answer marked as solution
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:21 PM
Points: 70, Visits: 750
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
Posted Thursday, December 4, 2014 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 4, 2014 9:24 AM
Points: 11, Visits: 17
Awesome, worked perfectly - sorry for taking so long to respond
Post #1641529
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse