none
Saving SSRS reports in MS Project 2013 Pro RRS feed

  • Question

  • Hello,

    I am running SSRS reports extracting data from Project Server.  Is there a way to save to directly to MS Project 2013? 

    Thank you for your time.

    Sandy Strong

    MPC

    Tuesday, January 26, 2016 5:46 PM

Answers

  • Hello,

    It is not possible to create an MPP file from an SSRS report if this is what you are asking? You could export the report into one of those file types and save it locally then insert it as an attachment in the project plan using the Notes functionality on the Task Information window. Here you will see a button for Insert Object. You could also save it to SharePoint or a fileshare then just have a link to the report from the project file using the hyper link column.

    Paul


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

    Wednesday, January 27, 2016 9:07 PM
    Moderator

All replies

  • Hello,

    Where do you want these reports saved? In Project Pro 2013? Or do you mean somewhere in PWA?

    Paul


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

    Tuesday, January 26, 2016 7:05 PM
    Moderator
  • Sorry I was not clear.  Data in Project Server can be viewed in an SSRS report which can be saved in the formats listed below.

    I want to take the data in the SSRS report and save it to a stand-alone MS Project Pro 2013 schedule.  I can currently copys and paste the data, as well as save it to Excel and then import from Excel to MSP.  I was wondering if there is a way to save the SSRS directly to MSP?

    Thank you for your time.

    Wednesday, January 27, 2016 6:22 PM
  • Hello,

    It is not possible to create an MPP file from an SSRS report if this is what you are asking? You could export the report into one of those file types and save it locally then insert it as an attachment in the project plan using the Notes functionality on the Task Information window. Here you will see a button for Insert Object. You could also save it to SharePoint or a fileshare then just have a link to the report from the project file using the hyper link column.

    Paul


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

    Wednesday, January 27, 2016 9:07 PM
    Moderator
  • Thanks and yes that is what I was asking.  I can do a simple copy and paste from Excel into MSP as I have a template in MSP set up to accept the data.  I'm comfortable with this method, but were concerns from others with human error in a copy and paste.  To me it is a non-issue, but trying to appease the masses.

    As always, thank you for your response.

    Wednesday, January 27, 2016 10:45 PM