Reporting Microsoft Project Information

1. Reporting Microsoft Project InformationDC Chapter of the Microsoft Project Users Group (MPUG)January 10, 2002

2. Reporting Microsoft Project Information • Introduction • Current Approach • Using Industry Standard Tools • Reporting and Analysis System (RAS) • Demonstration • Questions

3. Introduction • A Microsoft Project Solution Provider • eLabor Enterprise Project Implementation Partner • Project management systems assessment • Project management systems implementation • Process, policy, and procedure development • Program/Project Office Support • Customized and Off-the-Shelf reporting solutions (RAS)

4. Reporting MSP Info – The usual way • Requires Microsoft Project experience • Available only within Microsoft Project • Limited web accessibility • Primarily Tabular in nature • Not presentation quality • Multi-project information requires extensive setup

5. Reporting MSP Info – Another way • Use industry standard tools • Crystal Reports • Microsoft Office XP Web Components • Access Project information without the need for Project expertise • Extends the accessibility to Information • Easily see multi-project information

6. Crystal Reports • Version 8.0 introduced web report delivery • Tabular Reports • Static Graphs • Static Pivot Tables • Browser Accessible Output • Presentation Quality

7. Office Web Components (OWC) • Microsoft Office 2000 introduces OWC • Pivot Tables • Charts • Spreadsheet • XML features expanded with Office XP • Office XP introduces a favorable license model • Interactive Charts and Tables • Full Drag and Drop Capability • Browser Accessible Output

8. The Microsoft Project Repository • MPP using Microsoft Project 2000 OLE DB Provider - (stand alone and small groups) • Excel – (stand alone and small groups) • Access- (stand alone and small groups) • SQLServer, Oracle, etc. – (department and enterprise) • Analysis Services (OLAP) - (department and enterprise)

9. Helpful Microsoft Project Tools • Microsoft Project 2000 Resource Kit (MSDN Library) • Microsoft Project 2000 OLE DB Provider Information (MSDN Library) • Microsoft Project 2000 Software Development Kit (MSDN Library)

10. Our Solution • Visibility • Insight • Control • Preference • Order • Presentation (RAS) Reporting and Analysis System

11. Reporting and Analysis System (RAS) • Uses Crystal Reports and Office XP Web Components • Parameter driven reports • RAS Versions for Project only users, Project Central users, and Enterprise users • Designed for both Project 2000 and 2002 • Up to 80 standard and customized reports

12. DEMONSTRATION

13. QUESTIONS ?