How to change the color of a derived column?

  • Hi Friends,

    I have two columns First Name and Last Name. I have to create a derived column called "FullName" which is obviously nothing but "LastName,FirstName" . When displaying the full name, I want to show LastName value as one color and FirstName value as another color.

    Any suggestions would be really appreciated.

    Thanks in advance.

    Thanks,
    Charmer

  • The easiest way would be to create two placeholders in the textbox. One for the last name, and perhaps the comma, and one for forename. These can then be formatted and coloured independently.

  • Hi,

    I tried but in the expression, it just shows FIRST(Fields!FirstName.Value,"DST_Dataset"). This would take only the first value, right? Just curious...

    Thanks,
    Charmer

  • Is your textbox within a tablix or a list?

  • inside a tablix

    Thanks,
    Charmer

  • OK, and assuming it's at detail level, it should just work. Really all you are doing is double clicking in the textbox until you get the cursor, right click and create the placeholder. When the properties screen comes up, put the first half of you expression in there and set the text colour in the font properties. Click OK to exit properties. Then do it again in the same textbox for the first name.

    If you are adding the field in the expression editor I'm not sure why you would be getting the First summary appearing.

  • Just curious,

    Since we are using textbox , how do we expect all the rows will be displayed with respect to the expressions written?

    because we have used a text box, it will not be displaying all the rows as like as tablix properties.

    I am able to see only first row with full name but it is not displaying the other rows.

    Thanks,
    Charmer

  • When I say textbox, I'm referring to a cell in the tablix. A tablix is a collection of textboxes and other objects, text box is the default.

    If you right click an empty cell in the tablix, the menu will have the option "Textbox Properties", as this is the selected object type.

Viewing 8 posts - 1 through 7 (of 7 total)

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