Home › Forums › Discussion Forum › A custom report för the controller?
Tagged: Reports Excel Export
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
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…