Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

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.

A property tag is composed of two parts: the table indicator and the field indicator, which are separated by a period. For instance, in the WorkPackage.EVT field, WorkPackage represents the table and EVT represents the field. The tag is enclosed by curly brackets { } in the report. In the spreadsheet cell, {WorkPackage.EVT} is displayed.

The table below provides information on the Property tags that can be used in reports.

Tags Sections Report Types Description
{CriteriaN.Id}

HeaderGroup

Aggregated

Use this tag to display the ID of the current data row that meets the specified criteria.

{CriteriaN.Description}

HeaderGroup

Aggregated

Use this tag to display the description of the current data row that meets the specified criteria.

{CriteriaN.HasSubtotal}

HeaderGroup

FooterGroup

Aggregated

Use this tag to display the subtotal for the specified 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 is selected for the specified criteria.

{CriteriaN.Title}

HeaderPage

Aggregated

Use this tag to display the title of the current data row that meets the specified criteria.

{CostSetN.Id}

HeaderPage

Aggregated

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

{CostSetN.Description}

HeaderGroup

Aggregated

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

{ResultN.Id}

HeaderGroup

CAP (RollupResult=1), Summary

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

{<entity>.<property>}

HeaderGroup

Model

Use this tag to display the value of 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 of 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 of 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 of a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.

{CriteriaN.CodeAsg[N].Description}

HeaderGroup

Aggregated

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

HeaderGroup

Aggregated

Use this tag to display the code of 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 of a code assignment. Substitute a valid code assignment for <CodeAsg[N]>.

{<entity>.CodeAsg[N]}

HeaderGroup

Model

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

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

HeaderPage

Model

Use this tag to display the prompt of 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 of 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", "")}