Property Tags

Property tags indicate a field on a table. These tags are commonly added to a report template to print extra information, such as dates and code assignments.

Property tags are made up of two sections: the table indicator and the field indicator. These sections are separated by a period. Using the WorkPackage.EVT field as an example, WorkPackage is the table and EVT is the field. The tag is displayed in the report enclosed by curly brackets: { }. In the cell of the spreadsheet, {WorkPackage.EVT} is displayed.

The following are some of the commonly used tags in standard reports.

Tags Sections Report Types Description
{CriteriaN.Id}

HeaderGroup

Aggregated

Use this tag to display the ID for the current criteria data row.

{CriteriaN.Description}

HeaderGroup

Aggregated

Use this tag to display the description for the current criteria data row.

{CriteriaN.HasSubtotal}

HeaderGroup

FooterGroup

Aggregated

Use this tag to display the subtotal for the summary criteria, if available. This will be true if the criteria level is a summary row and the Show Total option on the Sub-Totals page of the Report wizard for the criteria is selected.

{CriteriaN.Title}

HeaderPage

Aggregated

Use this tag to display the title for the current criteria.

{CostSetN.Id}

HeaderPage

Aggregated

Use this tag to display the ID for the current cost set data row.

{CostSetN.Description}

HeaderGroup

Aggregated

Use this tag to display the description for the current cost set data row.

{ResultN.Id}

HeaderGroup

CAP (RollupResult=1), Summary

Use this tag to display the ID for the current result data row.

{<entity>.<property>}

HeaderGroup

Model

Use this tag to display the value for an entity property. Substitute a valid entity for <entity> and property for <property>.

{<entity>.<property>.Title}

HeaderPage

Model

Use this tag to display the title for an entity property. Substitute a valid entity for <entity> and property for <property>.

{<entity>.<property>.Id}

HeaderGroup

Model

Use this tag to display the ID for an entity property. This tag applies to properties with an enumerated type such as WorkPackage.EVT.

Substitute a valid entity for <entity> and an enumerated type for <property>.

{CriteriaN.CodeAsg[N]}

HeaderGroup

Aggregated

Use this tag to display the value for a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.

{CriteriaN.CodeAsg[N].Description}

HeaderGroup

Aggregated

Use this tag to display the description for a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.
  • If the code field is type Text, a blank value will be displayed.
  • If the code field is type User Field, the user’s first and last name will be displayed.
{CriteriaN.CodeAsg[N1].CodeAsg[N2]}

HeaderGroup

Aggregated

Use this tag to display the code on a code assignment. Substitute valid code assignments for <CodeAsg[N1]> and <CodeAsg[N2]>.

{CriteriaN.CodeAsg[N].Prompt}

HeaderPage

Aggregated

Use this tag to display the prompt for a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.

{<entity>.CodeAsg[N]}

HeaderGroup

Model

Use this tag to display the value for a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.

{<entity>.CodeAsg[N].Prompt}

HeaderPage

Model

Use this tag to display the prompt for a code assignment. Substitute a valid entity for <entity> and code assignment for <CodeAsg[N]>.

{<entity>.CodeAsg[N]}

HeaderGroup

Model

All codes attached to the entity (project, code file, resource file, and rate file) are expanded to a separate column for CodeAsg1, CodeAsg2, and others. The CodeAsg values are inserted in the cells. Substitute a valid entity for <entity>.

{<entity>.CodeAsg[N].Prompt} {Right}{Insert}

HeaderPage

Model

All codes attached to the entity (project, code file, resource file, and rate file) are expanded to a separate column for CodeAsg1, CodeAsg2, and others. The CodeAsg prompts are inserted in the cells. Substitute a valid entity for <entity>.

{Term.<Term Name>}

HeaderPage

Aggregated

Application preferences allows you specify your terms. Using the tags {Term.Budget}, {Term.Actual}, {Term.Earned}, {Term.BAC}, or {Term.EAC} will display the term entered.

{Report.Id}

All

All

Use this tag to display the report name.

{Report.Description}

All

All

Use this tag to display the report description.

{Narrative.<Category>}

HeaderGroup

CPR

The default categories are:

  • Corrective Action
  • Explanation
  • Impact
  • Monthly Summary
Substitute a valid Variance Narrative category for <Category>.
{CriteriaN.SortCode}

HeaderGroup

CAP, Summary

Use this tag to display the Sort Code for the current Criteria data row.

Sort codes are only applicable to the Results criteria.

{Result[N].SortCode}

HeaderGroup

CAP (RollupResult=1), Summary

Use this tag to display the sort code for the current Result data row.

{CriteriaN.ManagerId.Description}

HeaderGroup

Aggregated

Use this tag to display the CAM Description when the CAM uses a code or a user field, or the WP Manager Description when the WP manager uses a user field. This tag supports the Control Account and Work Package criteria on the Sub-Totals page of the Report wizard.

Note: You can reference codes by using the property CodeAsg<n> where <n> is the code file number.

Examples

The following are examples of using the special tags:

Tag Sample Result Description
{CriteriaN.Id}

1.1.1.1 / 1400

ID for the selected criteria such as control account.

{CriteriaN.Description}

Frame Design

Description for the selected criteria such as control account.

{CriteriaN.Title}

Control Account

Title for the selected criteria such as control account.

{CostSetN.Id}

BCWS

ID for a cost set.

CostSetN.Description

Scheduled

Description for a cost set.

{ControlAccount.FullId}

1.1 / 2.2

Control account ID.

{ControlAccount.FullId.Title}

Control Account

Control account title. This is the same as Term.ControlAccount.

{Result[N].Id}

HOURS

The result name.

{WorkPackage.FullId}

1.1 / 2.2 / 01

Work package ID.

{WorkPackage.FullId.Title}

Work Package

Work package title. This is the same as Term.WorkPackage.

{WorkPackage.WpId}

01

Work package ID.

{WorkPackage.WpId.Title}

WP

Work package field name.

{WorkPackage.Evt}

Percent Complete

The long description for the work package EVT.

{WorkPackage.Evt.Id}

C

The code for the EVT.

{WorkPackage.Status}

Planned

Work package status.

{WorkingDays[CostProject.StatusDate, Month]}

20

The number of working days in the monthly calendar period that contains the project's Status Date.

If the project has a rolling wave calendar, it will be used to determine the monthly calendar periods. Otherwise, the monthly calendar periods will be defined by calendar set 00 in the project's calendar file.

{Code.CodeAsg1.Prompt}

Code on Code Prompt

Prompt for Code 1 on Code.

{ControlAccount.CodeAsg5}

HOUSTON

The value in the control account assignment code 5.

{ControlAccount.CodeAsg5.Title}

Control Account Code Field 5

The generic title for Control Account Code 5.

{ControlAccount.CodeAsg5.Prompt}

Location

User prompt for the control account code.

{ControlAccount.CodeAsg[N]}

The code assignment (or value in the code) for the control account code N. The N indicates repetition until all code assignments are used.

{ControlAccount.CodeAsg[N].Prompt} {Right}{Insert}

Charge Number

The prompt for control account code N. The N indicates repetition until all code assignments are used. The tag to insert right signifies to insert a column to the right for the new code assignments.

{RateSet.Description}

Astronomer

The rate set description.

{Rate.RateSet.RateFile.Id}

Demo Rate

Tag that references a parent entity property, or the rate file name.

{Resource.CodeAsg1.Prompt}

Code on Resource Prompt

User prompt for Code 1 on the resource.

{Term.ControlAccount}

Control Account

{Term.Cam}

CAM

{CriteriaN.ManagerId.Description}

Samuel Jones

Shows the description of the Code used as CAM or the First Name and Last Name of the user if the CAM or WP Manager uses a user field.

IPMRFormat2Summary Tags

The following are examples of IPMRFormat2Summary tags:

Tag Description
IPMRFormat2Summary.Id

The ID of the IPMRFormat2Summary code.

IPMRFormat2Summary.Description

The description of the IPMRFormat2Summary code.

IPMRFormat2Summary.IsNonAdd

A Boolean value that indicates whether this summary code is Add (for example, is added to the subtotal of the report) or non-Add. The value will be False if the code has been excluded from the body of the report by specifying it in the ExcludeIPMRFormat2SummaryFromBody parameter.

This tag would typically be used in a formula such as:

{=IF(IPMRFormat2Summary.IsNonAdd, "N", "")}