Avatar of loneieagle2
loneieagle2
Flag for United States of America asked on

How do I hide part of a field in a SSRS textbox?

I have a SSRS report where in one text box I want to only display part of the FIELD that populates the textbox.
For example, if the text in the field is "LASTNAME, FI - ID", I want to display only "LASTNAME, FI". So in the query I have Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) + ' - ' + ID.
I can't just change the SELECT statement to leave off ID because I need that for grouping and sorting.
I changed the placeholder properties to recognize HTML tags
Something like:
Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) +<font size= "3">' + ' - ' + ID + '</font>'
works, but I can't find a way to hide the ID
I tried:
Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) +<div style="visibility:hidden">' + ' - ' + ID + '</div>'
References say that only certain inline CSS attributes are supported, so visibility must be one that isn't.
Any ideas, other than using one field for sorting and another for display.
CSSHTMLMicrosoft Server OSMicrosoft SQL ServerSSRS

Avatar of undefined
Last Comment
loneieagle2

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ian Pattison

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
loneieagle2

ASKER
Thanks, that will work. It still takes up space, but I can live with that.
loneieagle2

ASKER
Thanks, that will work. It still takes up space, but I can live with that.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck