Wednesday, January 23, 2013 10:28 PM
It is simple to concatenate fields from a query in SQL server then return the concatenated item to SSRS. My dilemma is I would also like to apply formatting to each value in the list separately based different values.
I am using SSRS for SQL Server 2008 r2.
ID CustomerName FavoriteCustomer
1 Sith Construction No
2 Jedi Forever Yes
3 Trooper Ammo No
4 Ewok Emporium Yes
5 Smuggler Deals No
If the customer is a favorite customer, I would like to underline and bold the customer name.
Sith Construction, Jedi Forever,Trooper Ammo, Ewok Emporium, Smuggler Deals
May the force be with you!
- Edited by Bradley_19 Wednesday, January 23, 2013 11:09 PM
Thursday, January 24, 2013 4:23 AM
Step1: Add Fields in matrix, then goto => CustomerName TextBox Properties in Font Write Expression like below,\
Mark this as answer if this post helps you.
Friday, January 25, 2013 2:45 PM
Thank you, that gets me very close to the solution I was looking for. The only difference would be I was looking to have the results in more of a "sentence" structure. Possibly using a text box and placeholders for each value from the data set.
Again, great solution, one I had not come up with!
The force is definitely with you RamyaElango!