February 8, 2016 at 3:16 am
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
February 8, 2016 at 3:25 am
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.
February 8, 2016 at 4:38 am
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
February 8, 2016 at 4:45 am
Is your textbox within a tablix or a list?
February 8, 2016 at 5:30 am
inside a tablix
Thanks,
Charmer
February 8, 2016 at 5:44 am
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.
February 8, 2016 at 6:06 am
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
February 8, 2016 at 7:37 am
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