Post reply

Less than sign "<" displaying as "& lt;" in textbox?

  • February 2, 2010 at 7:39 am

    #215216

    A report in SSRS 2005, when viewed in report manager, is displaying the contents of a textbox incorrectly.

    The actual string value in the sql data is "<.01", but SSRS is displaying "& lt;.01" (without the space between & lt;)-- how's this happening? What's the fix?

    It appears that SSRS is converting the less than sign into its html expression equivalent... makes no sense to me.

    Thanks in advance,

    Pete

  • February 2, 2010 at 7:55 am

    #1112290

    peterzeke

    Have you looked at:

    http://technet.microsoft.com/en-us/library/ms178710(SQL.90).aspx

    Which contains:

    Use the Choose Format dialog box to specify a text box format. This dialog box opens when you click the ellipsis button (...) in the Format tab of the Textbox Properties dialog box. This is the recommended way of setting the format properties for the contents of a text box containing data of a single data type.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 2, 2010 at 8:14 am

    #1112301

    Thanks for the reference info, but none of the default choices are suitable.

    What would the custom format string be for ensuring the string value that exists in the data actually be displayed as a string value?

  • February 2, 2010 at 8:40 am

    #1112322

    Now never having had you problem but my guess would be a custom format of String.Format .

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 2, 2010 at 12:08 pm

    #1112463

    Turns out that the problem has nothing to do with SSRS.

    The data I pull from is based on a concantenation of values using FOR XML. Whenever FOR XML encounters "<" or ">", it converts these characters to their expression equivalents of "& lt;" and "& gt;", respectively.

    Thus, I merely needed to wrap a couple of replace() functions around the field to reconvert the expressions back to "<" and ">".

    Thanks again for offering assistance.

    --pete

Viewing 5 posts - 1 through 4 (of 4 total)

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