Multi-Project Reporting Solutions

Every organisation has multiple projects these days. The challenge is to report across all projects in a meaningful way. ACE Project Systems has three solutions for you based on your team or organisation's project management maturity, size, and needs. These solutions are:

  1. Customisation of Microsoft Project using built in custom fields and Project's own ability to consolidate multiple schedules. We can also add further customisation using Project VBA (Rod Gill has written the only book on VBA for Microsoft Project).
    This solution works best for small teams or organisations still evolving their scheduling skills and reporting needs.
  2. ProjectReporter - ProjectReporter is a new tool developed by Rod Gill that adds a macro (or Add-in) to Microsoft Project. The button copies relevant data from your .mpp file to SQL Server for reporting purposes.
    The second part of ProjectReporter consists of some Excel templates that create automated reports for your projects, stores Risks, Actions, Issues, Decisions and Change requests in the same ProjectReporter database and facilitates central control of Calendars and Resources. All of your weekly reporting needs in one Excel report!
    This solution works best for teams and organisations looking to move to Project Server in the future (ProjectReporter is a great stepping stone to Project Server). Any custom data can be exported to the database and more reports created in Excel (or whatever reporting tool your organisation uses)from the database. All projects continue to be saved in the original .mpp files.
  3. Project Server - We can help you implement Project Server and get you up to speed as quickly as possible.

Call us for ideas on how to maximise your reporting needs and effectiveness by using Excel, Project and Access/SQL Server.

Finally, ask us how 80% of your weekly and monthly project reporting can be automated directly from project files to save your PMs time and improve your project governance processes.

For more information on ProjectReporter, click on the red ProjectReporter box below.

Contact Rod Gill and ACE Project Systems here.


Scheduling Made Easy - an effective new course from Rod Gill Scheduling Made Easy - an effective new course from Rod Gill