ProjectReporter - Multi-project reporting tool
Do you have multiple Microsoft Project .mpp files? Do you need a low cost, low tech, high added value project reporting tool? Then ProjectReporter will help you, click here for a list of business benefits ProjectReporter provides. ProjectReporter is made up of three components:
- In Project Professional or Standard 2003 or later, a VBA macro that exports the data for the active project to SQL Server, purely for reporting purposes. You continue to use your usual .mpp files.
- A database in SQL Server to hold your project data. You can either use SQL Express or any existing SQL Server instance you already have.
- Excel templates for weekly reports and
administration tools to help manage calendars and
Resource rates etc.
Once the data is published to SQL Server, your own reporting tools can create whatever reports you need, including 4-4-5 financial months and more.
Microsoft Project Component
The Microsoft Project Component comes either as a protected VBA Macro or as a Microsoft Project add-in. A ProjectReporter menu provides access to the various commands such as publish to SQL Server, import Resources, update calendars and more.
SQL Server or Microsoft Access Database
The database stores selected project information in a data format best suited for reporting using whatever reporting tools you have (Excel is a great reporting tool!). By adding extra fields to the various tables (Proejct, task, Resource etc.) ProjectReporter automatically copies any field of the same name. For example if a field named Text10 is added to the Text table, the text10 column in Project is copied for every task in all subsequent publishes.
Views can be created to rename any fields to suit your reporting needs and database security manages who can see what information.
Excel Reports and Admin
An Excel Weekly report is part of ProjectReporter. Not only does it report on data for a nominated project, but it allows the capture of Risks, Issues, Actions, Decisions and Change requests which are also uploaded into the database at the click of a button.
An Admin Workbook captures calendar exceptions for base Calendars (such as the Standard Calendar) and any Resource Calendars. Clicking a button saves the data to the database from where it can update projects by selecting the relevant command in the ProjectReporter menu in Microsoft Project.
Customising ProjectReporter
By building the ProjectReporter solution from basic, standard components (database, Excel, VBA macros) you get a very flexible and customisable soutlion. Talk to us about your needs.
ProjectReporter Pricing
The introductory cost for ProjectReporter is $1,500 plus $150 per project manager connecting to ProjectReporter. Cost includes a year's support but excludes GST and is in NZ$.
More Detail on ProjectReporter
Click here for more information on ProjectReporter.
Multi-Project Solutions
Click here for a multi-project
solution overview.
 |
