Hexadecimal value, is an invalid character: SSRS 2012

Hi,Today i have encounter below issue while deploying my report on SSRS 2012 Report manager.
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(' ')

Note:Might be it will not display on  SSMS,but when you execute select statement you will get  number. in my case it is 26.
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)
  

MSSQL Table BackUp

MSSQL Server:

1-Table back up With table schema and Data:

Method 1:

select  * into [dbo].[USER_backup] 

from [dbo].[USER]

Method 2: 

2-Table back up only Schema:

SELECT TOP 0 *

INTO [dbo].[USER_Schema_backup]

FROM [dbo].[USER]

3-Data base Back Up:


4-Data base Differential Back Up: 

Export Package from "Integration Services Catalog" MS SQL Server 2012

Steps to Export Package From Integration Services Catalog(SQL Server 2012):
1.Connect to server
2.Drill down "Integration Services Catalog" folder.
3.Drill down till projects folder.
4.Right Click on Package-->Export
5.Save file on your local folder with extension ".ispac"
6.Now,change your saved file extension to ".zip"
7.Extract the Zip file you will get ".dtsx" package file.