none
PWA 2010 Exporting Project Centre Views to Excel RRS feed

  • Question

  •  

    We are trying to build a new Exco report for our PMO, and our vendor recommended that we use the Project Centre views to build the dashboard, I have created the view, but am unable to export this view to Excel, if i copy it over i lose the graphic RAG indicators.

    How do I export from the Project Centre view or how do i access the project centre's setting to investigate why my excel export does not work

    Friday, December 6, 2013 11:05 AM

Answers

  • As you have seen, the graphical RAG indications are not copied over into Excel, only the text values. You could update the Excel file with conditional formatting  after the export? Rather than exporting the project center, create an excel based reporting that pulls the data from the Project Server Reporting database, you could then add conditional formatting etc. and it will refresh. Alternatively, create an SSRS report that pulls data from the Project Server Reporting DB and add your own RAG icons etc.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Friday, December 6, 2013 1:58 PM
    Moderator