Create a new Excel Report from Existing (modifying ODC), excerpt from Business Intelligence Course

Step

Action

Details

1

From PWA navigation to the Business Intelligence Center à Sample Reports à English (United States)

2

Expose the contextual menu for the Simple Projects List à Edit in Microsoft Excel

3

If presented with a security warning, click the Enable Content button

4

Excel launches and the report generates

5

We are going to add a field to this report that is not currently part of its ODC file. Perform the following:

Select the Data Ribbon à Connections

If the Connections button is disabled, be sure to place cursor focus somewhere on the report.

6

Highlight the existing connection and click the Properties button.

<img title="clip_image010" border="0" alt="clip_image010" width="398" height="271" style="background-im

• Training
  • Integent’s Microsoft Project Online Training
  • Microsoft Project Server Training Online
  • Microsoft Project Training
• Consulting
  • Microsoft Project Online
  • Microsoft Dynamics 365 for Sales Consulting
  • Microsoft SharePoint Online
• Support
  • Microsoft Project Server Support
• Blog
• Company
  • Approach
  • Certifications & Awards
• Contact