HTML Controls appear on Multiple line text enterprise fields in BI Reports RRS feed

  • Question

  • Hi,

    In Project Server 2010 with SP1 and Dec'11 CU I have some Project Enterprise Text Fields - multiple lines such as "Remarkas", "Activities for next period". When I insert these fields in BI reports using Excel Services or SSRS 2008 R2 (Report Builder 3.0), the content os these fields appears with HTML controls.

    A single paragraph written as:

    "Everything is on time." appears in the report as "<p>Everything is on time.<p>"

    without changing any configuration in the text box. It he or she users paragraph, markers, font formating, the controls become longer.

    How can I clean up these controls from the RTF fields in order to appear only the cleam text with all formatting in the BI reports?

    Any clues?

    Thank you.

    • Edited by R.Segawa Saturday, February 11, 2012 8:28 PM
    Saturday, February 11, 2012 8:27 PM


All replies

  • Hi Segawa,

    Please follow the url below, your problem is mentioned in the thread with the solution.

    PS2010 - BI - Excel Services Reports - HTML Tags are appearing on worksheet

    Hope this answers your question.


    Thanks, Kashif

    • Proposed as answer by Alexander.Burton Sunday, February 12, 2012 3:13 AM
    • Marked as answer by R.Segawa Monday, February 13, 2012 9:06 PM
    Saturday, February 11, 2012 11:30 PM
  • Hi Kashif,

    I think this wil do the job. The workload is to map all controls that can be used by the Project Manager in the RTF field.

    Thank you.

    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    Monday, February 13, 2012 9:06 PM