Post reply

SSRS Hexadecimal 0X0B error

  • October 6, 2021 at 6:12 pm

    #3938193

    Hi Everyone,

    I am new to SSRS, I have a question I am creating report template in SSRS  using “Microsoft Report Builder” for  archive projects where I am connected to SharePoint Archive Site.

    SharePoint "Project" list has Justification Text column (multiline text), when I am trying to retrieve Justification data I am getting “Hexadecimal 0xOB” error.

    If possible can anyone  help me with below mentioned solutions for the same:-

    Can we strip out unprintable characters or

    Can we visible those characters in my report or

    Can we ignore those characters in SSRS report

    Thanks

    Attachments:
    You must be logged in to view attached files.

  • October 7, 2021 at 7:10 pm

    #3938596

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 8, 2021 at 1:48 pm

    #3938838

    Without knowing your data, it might be as simple as that the VT control character is used in your column to indicate a line break, instead of the more "normal" CRLF or LF.

    So you might try to do a simple replace from VT to CRLF or to LF and see where that leads you.

    https://www.eso.org/~ndelmott/ascii.html

    SELECT REPLACE(Justification, CHAR(11),CONCAT(CHAR(13),CHAR(10))) AS Justification -- VT -> CRLF

    SELECT REPLACE(Justification, CHAR(11),CHAR(10)) AS Justification -- VT -> LF

  • October 8, 2021 at 3:01 pm

    #3938886

    Hi Kaj,

    Thanks for your reply.

    Data is just text- multiline text. I found out that symbols are not creating issue it's a space which is creating a issue.

    I tried replacing space with  =Replace((Fields!Justification_Text.Value," ",""),Fields!Justification_Text.Value) this expression but no luck. My database is SharePoint not SQL

    Do you think I am using correct expression to replace space with no space?

    Thanks

     

  • October 8, 2021 at 3:44 pm

    #3938900

    I'm not fluent in the SSRS VBA syntax, but that replace looks strange. I think you need only the "inner" parameters, i.e.

    =Replace(Fields!Justification_Text.Value," ","")

    But since the error message mentions the VT control character (0x0B), I think you should also be aware that it might only look like a blank. Non-printable control character will often look like a blank in Notepad for example. You'd need something like Notepad++ in order to actually see such control characters.

    If so then this should replace the 0x0B character:

    =Replace(Fields!Justification_Text.Value,chr(11),"")

     

     

    • This reply was modified 2 years, 6 months ago by  kaj. Reason: Changed 0X0B into 0x0B

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

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