How to Remove <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> on Report


  • Hi there,

                 I am using SSRS 2008 for reports, In my report I am showing text that is coming from Word document along with some formatting like bold italic etc, but along with the Text one extra line is also coming. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

    Is there any way that i can avoid this line in my report. this line should not come with contents of report.


    2010년 6월 29일 화요일 오전 4:11

모든 응답

  • Hi Shaikh,

    I would suggest you copying the text from Word to Notepad before pastering in a report.
    Or, if you have reports that has the extra line, please follow these steps to remove them:
     1. In Business Intelligence Development Studio(BIDS), right-click each report from "Solution Explore" panel.
     2. Then click "View code"
     3. Now, press "CTRL" + "H"(combinated key), replace the extra line with null.

    If you have more questions regarding SQL Server Reporting Services, please feel free to ask.

    Jin Chen

    Jin Chen - MSFT
    2010년 6월 30일 수요일 오전 11:10
  • Hi Jin Chen,

         Thanks for ur reply, but I am First Copying the word document data(Rich text) in Rich Text box on page and saving it.then i am retrieving the data from DB on my Report. hence its not possible to copy it to Notepad.

    Let me know, if there is any possible solution other than making the last line NUll, since I can not predict whether user will enter data in RTB using word or he/she will type in.





    2010년 7월 4일 일요일 오전 11:15
  • Hi Shaikh

    I added a replace to the sql request:

    replace(<fieldname>,'<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />','') as <fieldname>

    It worked great

    2011년 10월 4일 화요일 오후 2:14