Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Concatenate Values from a Data Set with a Twist

Respondido Concatenate Values from a Data Set with a Twist

  • Wednesday, January 23, 2013 10:28 PM
     
     
    Sign In to Vote
    0

    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.

    Example

    Query Results

    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.

    Results needed:

    Sith Construction, Jedi Forever,Trooper Ammo, Ewok Emporium, Smuggler Deals

    May the force be with you!

    Bradley


    • Edited by Bradley_19 Wednesday, January 23, 2013 11:09 PM
    •  
     

All Replies

  • Thursday, January 24, 2013 4:23 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Step1: Add Fields in matrix, then goto => CustomerName TextBox  Properties in Font Write Expression like below,\

    Bold expr:

     =iif(Fields!FavoriteCustomer.Value="Yes","Bold","Default")

    Effects expr:

    =iif(Fields!FavoriteCustomer.Value="Yes","Underline","None")

    Mark this as answer if this post helps you.


     
  • Friday, January 25, 2013 2:45 PM
     
     
    Sign In to Vote
    0

    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!

    Regards,

    Bradley