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

The ID for the current criteria data row.

{CriteriaN.Description}

HeaderGroup

Aggregated

The description for the current criteria data row.

{CriteriaN.HasSubtotal}

HeaderGroup

FooterGroup

Aggregated

This tag indicates if there is a subtotal for the summary criteria. 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

The title for the current criteria.

{CostSetN.Id}

HeaderPage

Aggregated

The ID for the current cost set data row.

{CostSetN.Description}

HeaderGroup

Aggregated

The description for the current cost set data row.

{ResultN.Id}

HeaderGroup

CAP (RollupResult=1), Summary

The ID for the current result data row.

{<entity>.<property>}

HeaderGroup

Model

Substitute a valid entity for <entity> and property for <property>. This is the value for an entity property.

{<entity>.<property>.Title}

HeaderPage

Model

Substitute a valid entity for <entity> and property for <property>. This is the title for an entity property.

{<entity>.<property>.Id}

HeaderGroup

Model

Applies to properties with an enumerated type such as WorkPackage.EVT.

Substitute a valid entity for <entity> and an enumerated type for <property>. This is the ID for an entity property.

{CriteriaN.CodeAsg[N]}

HeaderGroup

Aggregated

Substitute a valid code assignment for <CodeAsg[N]>. This is the value for a code assignment.

{CriteriaN.Code.Asg[N].Description}

HeaderGroup

Aggregated

Substitute a valid code assignment for <CodeAsg[N]>. This is the description for a code assignment.
  • 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

Substitute valid code assignments for <CodeAsg[N1]> and <CodeAsg[N2]>. This is a code on a code assignment.

{CriteriaN.CodeAsg[N].Prompt}

HeaderPage

Aggregated

Substitute a valid code assignment for <CodeAsg[N]>. This is the prompt for a code assignment.

{<entity>.CodeAsg[N]}

HeaderGroup

Model

Substitute a valid code assignment for <CodeAsg[N]>. This is the value for a code assignment.

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

HeaderPage

Model

Substitute a valid entity for <entity> and code assignment for <CodeAsg[N]>. This is the prompt for a code assignment.

{<entity>.CodeAsg[N]}

HeaderGroup

Model

Substitute a valid entity for <entity>. 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.

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

HeaderPage

Model

Substitute a valid entity for <entity>. 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.

{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

This the Report name.

{Report.Description} All

All

This is the Report description.

{Narrative.<Category>}

HeaderGroup

CPR

Substitute a valid Variance Narrative category for <Category>. The default categories are:

  • Corrective Action
  • Explanation
  • Impact
  • Monthly Summary
{CriteriaN.SortCode}

HeaderGroup

CAP, Summary

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

The Sort code for the current Result data row.

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

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", "")}

Related Topics:

Parent Topic: Report Template Tags