Report is working fine in MS Visual studio during development,but when i had deployed the same report on report manager i was getting below Error message:
Error :The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
There is an error in XML document (1, 12827).
' ', hexadecimal value 0x1A, is an invalid character. Line 1, position 12827.
Issue Root cause:
"This problem occurs because a non printable character is populated into a report parameter that you define in the report".
Solution:
Step1: Check the ASCII number for non printable character using below statement.
select ASCII(' ')
Step2: Just use REPLACE() function in your query to eliminate non printable character.
select distinct REPLACE(title, CHAR(26),',') as title from analytics..<<Table_Name>>
order by title desc
Tag:(SSRS, xml, non printable character, Ascii, Char, Replace)
It helps.Thanks for the information dude.
ReplyDeletenice.Thank you for sharing MSBI Online Training
ReplyDelete