I'm new to SSRS and I'm unable to align the sentence horizontally in a straight line in SSRS using HTML tag.
I've got a very long word and I want it to fit in a line. I tried using can grow in SSRS but it expands the text box in a vertical manner with the word moving to the next line. However, I want the words to fit in a horizontal line and the extra to be visible as long as the text box holds.
Is there any HTML tag/code in SSRS which would help me achieve the same?
SSRS only supports a very limited set of HTML tags, so HTML is often not that helpful to format your text.
From this MSDN article, the list of supported tags are:
<A HREF><FONT><H{n}>, <DIV>, <SPAN>, <P>, <HN><B>, <I>, <U>, <S><OL>, <UL>, <LI>So we can achieve the result you are after (that is, show as much of the text as possible in the horizontal confines of the text box) by combining the <DIV> HTML element with non-breaking spaces.
To do this, follow these steps:
Set the cell's CanGrow property to False so it won't expand vertically
Set the cell's Markup Type to be HTML - Interpret HTML tags as styles
Enclose the field's text in <DIV> tags and replace the spaces in the text with non-breaking spaces by setting the cell's expression to:
="<DIV>" & Replace(Fields!FieldName.Value, " ", " ") & "</DIV>"