Modify Custom Project Activity Summary dialog box

Use this dialog box to edit a project activity summary tab for the My Project Center activity center.

Name

Enter the name that you want to appear on the custom tab.

Connection String

Enter the connection string value to connect to the server and the database. This example is for Deltek Vision on a server called Hebron, to the database VisionDemo50: Data Source=Hebron;Initial Catalog=VisionDemo50;Integrated Security=SSPI;

SQL Statement

Enter the SQL query that will retrieve activity summary data.

FOR xml auto, ELEMENTS statement is required to generate the XML for a SQL Server database.

WHERE PR.WBS1 = ‘[ProjectNumber]‘ – project number substitutes from Project Center.

Here is a list of other fields that can be substituted from Project Center:

[ProjectNumber]

[ProjectName]

[ProjectFolder]

[ProjectId]

[ProjectIssueCode]

[Description]

[Client]

[Phase]

[Manager]

[Location]

[Address]

[Longitude]

[Latitude]

[CurrentUserName]

[CurrentUserEmail]

[MapLocation] – This is for Google Earth

[EarthLocation] – This is for Google Earth

[ServerName]

XSL File

Enter the full path to the XSL style sheet file. The style sheet formats how the data is displayed in the tab.

Status

Select the status, which determines whether the custom project activity summary tab is displayed in the My Project Center activity center for Project Center users.

• Select Inactive to inactivate the custom project activity summary tab and remove it from Project Center. The tab will not be available to any user.

• Select Active to make the tab available to all users and add the custom project activity summary to the Project Activity Summary Tabs list of the Edit Project Activity Summary dialog box.

• • Select Show in Used to add the project activity summary tab to the Project Activity Summary section of the My Project Center activity center for all users. Users can then remove it if they want to using the Edit Project Activity Summary dialog box.

  • Select Show in Unused to make the project activity summary tab available to users. It will not appear in the My Project Center activity center for any users by default. Users can add it using the Edit Project Activity Summary dialog box.

Once a project activity summary has been set to Active and either Show in Used or Show in Unused, the only option is to change the status to Inactive. This prevents a user from inadvertently changing the preference to Show in Used or Show in Unused for a user. To make changes to it, change it’s status to Inactive. Once the project activity summary changes have been made, it can be set back to Active again.

SQL Server Database

Mark this checkbox if you are connecting to a SQL server database. Clear it if you are connecting to another database.

Test Connection

Click to test the connection to the database.

 

To access this dialog box

Select a custom project activity summary, then click Modify from the Custom Project Activity Summaries section of the Global Settings tab of the Project Center Administration activity center.