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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear Folks,

    HTML tags are appearing one of my excel services reports. Please have a look at the screenshot. How can I fix/prevent them?

     

    Thanks

    Best Regards

    Mohsin Raza
    Monday, January 30, 2012 9:50 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Unfortunately that data is stored within the Project Server Reporting DB, to remove the tags, the easiest way is to implement a custom UDF in the reporting db similar to the one at http://stackoverflow.com/questions/457701/best-way-to-strip-html-tags-from-a-string-in-sql-server. You can then modify the Project Server - Issues and Project Server - Risks ODC's to wrap the discussion field in that UDF.

    Hope this makes sense. 

     

    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Monday, January 30, 2012 10:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Alex,

    Many thanks for your response. This is something totally manual, is there any way to make/configure it through the system? Otherwise this will be the last option for me.

    Many thanks

    Mohsin Raza
    Monday, January 30, 2012 11:09 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you change the odc files, they will be available for all reports that use them. The only other option I can think of would be to stop the div's being inserted at the source, perhaps by changing the field type in the list from Rich Text to Plain Text. Of course you will need to test this works as expected with the synchronisation.
    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Monday, January 30, 2012 11:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Then i think option 1 is fine for me.

    Many thanks

    Best Regards

     

    Mohsin Raza
    Monday, January 30, 2012 12:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Moshin,  Can you explain how you created this file.  Where is the exteranl data coming from that you are showing in the PivotTable?

    Also does the same problem occur when you open the file in the Excel Desktop Client?

    Thursday, February 2, 2012 5:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Tyson, this report is in OOB solution. All data is coming from the ProjectServer_Reporting database and showing by using PivotTable. 

    And these Html tags do not appear when I open the file in Excel Desktop Client.

    Could you please provide any proper and solid solution for this, as right now I'm using UDF in MS SQL Server.


    Many thanks.

    Mohsin Raza
    Thursday, February 2, 2012 7:35 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Any ideas of how to do this in Project Online? I could use a calculated column in Power Pivot, but that would be difficult to parse all of the many HTML tags.
    Thursday, February 5, 2015 3:45 AM