Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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