Step

Action

Details

1

Launch Excel 2010

clip_image002

2

On the Data tab, in the Get External Data group, click From Other Sources, and then click From Data Connection Wizard.

clip_image004

3

Select Microsoft SQL Server, and then click Next.

clip_image006

4

Enter the name of the server (by default, it is the network name of the computer) and a user account that has a valid login and database permissions.

Server Name: MPNTPRJ10G

Select Use Windows Authentication radio button

Click Next.

clip_image008

5

Select a database ProjectServer_PS_Reporting, and then highlight the table you want to connect to (MPN_DepartmentKPIValues in our example)

You could also choose to write a sql statement that draws data from multiple tables or views and use that instead. 

Click Next.

clip_image010

6

Enter a name for the file, and then click Finish.

Use the given name

<img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image012" border="0" alt="clip_image012" src="https://integent.com/Portals/0/SunBlogNuke/1/Windows-Live-Writer/041c6de91daa_948B/clip_image012_thumb.jpg" width="244" hei

2018-03-15T14:25:23-04:00May 8th, 2012|2 Comments

2 Comments

  1. Avatar
    Forrest May 8, 2012 at 4:37 pm - Reply

    Dan, <br />In your demo when you saved the DansReportWebinar Excel Workbook Template you got a Data Connection File error that you said you could have avoided and just went on with your demo. <br />Can you explain how to not get this error. Even though I have defined the Excel Services and Trusted sites correctly I get this error even though the files are saved to the Trusted sites. <br />Any help would be appreciated. <br /> <br />Forrest

  2. Avatar
    Daniel Bell May 8, 2012 at 5:00 pm - Reply

    Forrest, <br />I just posted the solution that fixed the error in the webinar environment. hopefully this helps. <br /> <br />-Dan

Leave A Comment