Generating Reports from Project XML Data

You can export project information as XML data and create reports in other applications. You can generate this information as an HTML file for viewing on a Web site. You can send this information to a Microsoft Excel spreadsheet. In short, you can use this project XML data in any application that recognizes XML.

This function can be useful if you want to save a snapshot of report information in another program or if you want to manipulate project data in different ways than are available in Microsoft Project.

FEATURE

In Microsoft Project 2002, the XML Reporting Wizard Component Object Model (COM) add-in was available as a Web download. Now the wizard is built in to Microsoft Project and available on the Analysis toolbar.

With the XML Reporting Wizard, you can save your project as an XML file. You can apply an XSL template to that data. Two sample XSL templates for HTML files are provided with Microsoft Project. You can also create your own XSL template to make the XML data appear exactly the way you need. If you're using your own XSL template for your project report, be sure it's created and ready on your computer or network before running the wizard.

To generate a report using the XML Reporting Wizard, follow these steps:

1 Click View, Toolbars, Analysis to show the Analysis toolbar.

2 On the Analysis toolbar, click XML Reporting Wizard.

3 Read the first page of the XML Reporting Wizard and then click Next.

lJ XML Reporting Wizard

XML Reporting Wizard

4 In the Specify XML File Wizard page, make sure that the New File option is selected and then click Next.

5 In the browser window that appears, navigate to the location on your computer or network where you want to save the new XML file containing your project data. In the File Name box, enter a filename and then click Save.

The Select The Transform To Apply Wizard page appears (see Figure 12-40).

XML Reporting Wizard

XML Reporting Wizard

Figure 12-40. Find the XSL template to apply to your project XML data and create your report.

3"

Figure 12-40. Find the XSL template to apply to your project XML data and create your report.

6 Click the Browse button to find and select the XSL template to apply to your data.

The template you choose will determine the format and content of your project XML

report.

Click Open.

Two XSLs are provided with Microsoft Project: CRITTASK.XSL and RESOURCE.XSL.

7 In the wizard again, with the path to your selected XSL in the Location box, click Next.

8 In the Complete The Report Wizard page, click Preview. Your browser opens with the new XML report.

9 Review your report in your Web browser (see Figure 12-41).

10 Return to Microsoft Project.

If you're happy with the report, click Save. Navigate to the location you want, enter a name for the report, and then click Save.

If you want to change the report before saving it, click the Back button to return to previous wizard pages.

When you're finished previewing and saving your new report, click Finish.

'ä C:\Documents and SettingsXTeresa StoverM-OcaiSettingsYTemp\temp_report.htm - Microsoft Internet Explorer |"^~~]fn"|["x~|

File Edit View Favorites Tools Help

Address C ^Documents and 5ettings\Teresa Stover\Local 5ettings\Terrip\terrip_report,htrri ~

Critical Tasks for Project:New Product

m

Name

26

Assign resources to development stage plan

500

33

Establish product characteristics (performance cntena)

500

34

Develop prototype process

500

35

Produce prototype product

500

36

Conduct internal product review

500

33

Conduct marketing/technical review

500

39

Redesign process (if necessary)

500

40

Modify prototype process

500

42

Produce product for customer evaluation

500

Done

Start

Finish

2004-03-

2004-03-

29T08:00:00

29T17:0C

00

2004-03-

2004-03-

30T0S 00:00

31T17:0C

00

2004-04-

2004-04-

01T08:00:00

14T17:0C

00

2004-04-

2004-05-

15T0S 00:00

19T17:0C

00

2004-05-

2004-05-

20T08:00:00

26T17:0C

00

2004-05-

2004-10-

27T0S 00:00

01T17:0C

00

2004-10-

2004-10-

04T08:00:00

15T17:0C

00

2004-10-

2004-11-

13T0S 00:00

05T17:0[

00

2004-11-

2004-12-

ORTOR'OO-OO

10T17-0000

^ My Computer

Figure 12-41. Use the XML Reporting Wizard and an XSL template to create an XML report from your project data.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment