Click here to Skip to main content
15,923,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am getting following error when i change database drop down in ssrs report. database dd is static not dynamic. Also when i run sp with same exact paramenter, data is coming in sql server properly. please suggest what should be cause of 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, 94570).
'', hexadecimal value 0x1A, is an invalid character. Line 1, position 94570.

Note : It is running properly in rdl file. not in browser.

What I have tried:

As i said i execute stored procedure in sql server with same parameter and it runs fine and gives proper resu;t. It was running properly before 10 days

Note : It is running properly in rdl file. not in browser.

please suggest.
Updated 6-Sep-21 23:06pm
CHill60 5-Apr-16 7:35am    
How are you creating the XML document that it is trying to read?
k@ran 5-Apr-16 7:44am    
i am not creating any xml. I am directly binding to datasource

It is the special character char(26) in my case, replace(COLUMN, char(26), '') worked for me.
Share this answer
1. Verify the column header having with and special character.
2. Remove or verify any hidden parameter
Share this answer
CHill60 7-Sep-21 5:30am    
Reason for my downvote - An unclear response to a very old question. Unlikely to have been the column header containing the special character and there is no such thing as a "hidden" parameter

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900