Home Forums Discussion A custom report för the controller?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #417250 Reply
    Lars Hallin
    Participant

    Hi All,

    I in the process of implementing the use of MSP in a fairly large construction company, and I need to satisfy both the PM’s need for planning and monitoring, and the controller/management needs for reporting. As far as the PM’s needs Im good since I have been using MSP for +20 years, but the controller is a bit trickier because it’s on a new level for me.

    His expressed need is to be able to generate a custom report consisting of the content of about 15 custom fields from a Gantt chart table to Excel. I have created the table, but can’t get my head around how to export them into a spreadsheet. So, to my question. Should I:

    a) Use an existing report and modify it? If so, suggestions?
    b) Create a macro that exports to Excel?

    Greatfull for all feedback!
    Cheers
    Lars

    #417251 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    Hi Lars, try exporting the data to Excel and see if that does the trick. From the project, Save As, Save As Type-Excel Workbook. That will take you to the Export wizard. Next, Selected Data, New Map, Tasks, select columns, Next, Save the map and Finish. Hope that helps…

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: A custom report för the controller?
Your information:




20 − = 19