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]>.
|
{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:
|
{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. |
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", "")} |
- Related Topics:
- Apportionment Mapping Tags
The table below lists the Apportionment Mapping tags for Cobra. - Baseline Tags
The table below lists the Baseline tags for Cobra. - Calendar File Information Tags
The table below lists the Calendar File Information tags for Cobra. - Calendar Holiday Tags
The table below lists the Calendar Holiday tags for Cobra. - Calendar Period Tags
The table below lists the Calendar Period tags for Cobra. - Change Management Tags
The table below lists the Change Management tags for Cobra. - Class Information Tags
The table below lists the Class Information tags for Cobra. - Code File Information Tags
The table below lists the Code File Information tags for Cobra. - Code Tags
The table below lists the Code tags for Cobra. - Control Account and Work Package Note Tags
The table below lists the Control Account and Work Package Note tags for Cobra. - Control Account Tags
The table below lists the Control Account tags for Cobra. - Cost Set Information Tags
The table below lists the Cost Set Information tags for Cobra. - Explanation of Variance Narrative Tags
The table below lists the Explanation of Variance Narrative tags for Cobra. - Milestone Tags
The table below lists the Milestone tags for Cobra. - Note Information Tags
The table below lists the Note Information tags for Cobra. - Project Information Tags
The table below lists the Project Information tags for Cobra. - Rate File Information Tags
The table below lists the Rate File Information tags for Cobra. - Rate Set Tags
The table below lists the Rate Set tags for Cobra. - Rate Tags
The table below lists the Rate tags for Cobra. - Report Filter Information Tags
The table below lists the Report Filter Information tags for Cobra. - Report Information Tags
The table below lists the Report Information tags for Cobra. - Resource Assignment Tags
The table below lists the Resource Assignment tags for Cobra. - Resource Calculation Tags
The table below lists the Resource Calculation tags for Cobra. - Resource File Information Tags
The table below lists the Resource File Information tags for Cobra. - Resource Tags
The table below lists the Resource tags for Cobra. - Work Package Tags
The table below lists the Work Package tags for Cobra.