Cobra Help System

Using the Help Search

Other Tags

Use the Other tags to create or modify a report template.

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

Tag	Sections	Report Types	Description
{ApplyCellFormat(<tag>)}	HeaderGroup	All	This tag accepts a single parameter that specifies which tag or cell reference will determine the cell’s format. If a tag is specified, then that tag must also be present in the cell. If a cell reference is specified, then it can be any cell, provided that it meets the following conditions: The referenced cell must be in the same report section as the referring cell. The referenced cell must not also contain Cell[] references. Only relative cell references are supported, for example. Cell[R, C-1]. Cell references to a Row Label cannot be used to set the cell’s format. For example: {=IF(CostSet1.PeriodN.Date <= CostProject.StatusDate,CostSet1.PeriodN.Value,0)}{ApplyCellFormat(CostSet1.PeriodN.Value)} This tag does not have any effect unless the following report parameter is enabled: ApplyCellFormat=1.
{AutoFit}	HeaderPage, HeaderReport	All	This tag sets the column contents to auto fit when you place it on a page or report level header or footer. This tag should be placed in the first column.
{Cumulative}	HeaderGroup	Graph, CAP	This tag makes a CAP report cumulative-based without adding an extra cumulative line.
{CumulativeLine}	HeaderGroup	CAP	This tag makes a CAP report cumulative-based by adding an extra cumulative line.
{Down}	HeaderReport	CPR	N tag expansion direction. Your options are Right or Down.
{Group}	HeaderGroup	Aggregated, Model Except: Model (Log), Model (Report)	This tag adds Excel grouping (expand/collapse). When using grouping in hierarchical reports such as CAP, an extra blank footer row must be present for each grouped entity section. This allows the reporting engine to correctly place the + signs for grouping. This tag should be placed in the first column.
{HIGHLIGHT(Cell[R,C-3],C,P,J43,V,ValuePercentBoth)}	HeaderGroup	CPR	Use this tag to indicate the threshold highlighting. The parameters in the sample highlight tag are described as follows: <Cell[R,C-3]> parameter indicates the cell reference of: If the current cell contains the percent variance, the reference cell contains the value variance. If the current cell contains the value variance, the reference cell contains: The Budget value if data type is Schedule. The Earned value if data type is Cost for Period or Cumulative. The BAC value if data type is Cost for At Complete. The <C> parameter indicates if the cell contains cost (C) or schedule (S) data. The <P> parameter indicates period. Possible values are: A (At complete), P (Period), and C (Cumulative). The <J43> parameter is the cell reference where formatting is specified. The <V> parameter indicates if the cell contains value or percent data. Possible values are: V (Value cell) and P (Percent cell). V is both the default and optional value. The <ValuePercentBoth> parameter indicates the highlighting value to apply. Possible values are: ValueBoth: Shows highlight if value or both value and percent exceed threshold. PercentBoth: Shows highlight if percent or both value and percent exceed threshold. ValuePercentBoth: Shows highlight if value, percent, or both value and percent exceed threshold. This value is both default and optional.
{Insert}	HeaderPage	CAP, Summary	N tag expansion function. Options are Replace or Insert. The Insert function expands the N tag by inserting new rows or columns.
{MinimizeFormulaCalculation}	Cell A1	CAP	Use this tag so that Cobra only calculates the formulas it needs to generate the report instead of automatically calculating all the formulas. This tag can help reduce Cobra's memory requirements on exceptionally large reports. Using this tag with the automatic calculation option disabled on the report template (Formulas > Calculation options > Manual) will cause the generated report to display blanks or incorrect values for cells containing formulas that Cobra did not calculate. You need to manually calculate formulas on the generated report by pressing F9 or by using the Calculate Now command Formulas > Calculate Now). This tag should have no impact on the generated report if automatic calculation is enabled in Excel ( > Excel Options > Formulas > Calculation Options > Automatic), which is enabled by default.
{NewPage}		All	Use this tag to add a new page. This tag should be placed in the first column.
{NoCellFormat}	HeaderGroup	All	Use this tag to ignore the ApplyCellFormat parameter for this cell. This cell’s format will be copied from the template.
PRINTIFOTHERWISE	HeaderGroup	All	Use this tag to display the row only if one or more PRINTIF tags are defined within the same section and none of them is displayed for the current data element.
{PRINTIF(<Expression>, <Value>)}	FooterReport, HeaderGroup	All	Use this tag to display only the row if the <Expression> expression has the value <Value>. The expression for <Expression> must evaluate to an entity property. This tag should be placed in the first column.
{=REMAININGPERIODS(expression)}	HeaderGroup	Aggregated	Use this tag to expand the expression into a sum expression based on the number of periods in the calendar. For example, if the calendar has 13 periods and the expression is CostSet1.Period1.Value, the tag will be expanded to =CostSet1.Period1.Value+ CostSet1.Period2.Value+.+ CostSet1.Period13.Value.
{Replace}	HeaderReport	CPR	N tag expansion function. Options are Replace or Insert. The Replace function expands the N tag by overwriting any cells without inserting new rows or columns.
{Right}	HeaderPage	CAP, Summary	N tag expansion direction. Options are Right or Down.
{RowLabel:<RowLabel>}	HeaderGroup	All	This tag provides a reference to a row based on its label. The label can be referenced in a Cell formula. Attention: For more information, see the Formula Tags help topic.
{SortCode<Code>}	FooterReport	CPR	Total for Sort Code <Code>.
{SubTotal}	FooterReport	CPR	This tag indicates where the subtotal value displays on the footer of a CPR report.
{UseLowMemoryOutput}	Cell A1	CAP	Use this tag to generate the report using features that significantly reduce Cobra’s memory requirements. This tag must be specified in cell A1 of the report template and is only supported for some reports. Attention: For more information, see Reduce Memory Consumption for Very Large Reports.
{VARCOLOR(VAC, Cell[R,C-2])}	HeaderGroup	CPR, Model (Project)	This tag indicates the variance coloring function. {VARCOLOR(CPI)}, {VARCOLOR(SPI)}, {VARCOLOR(CV, Cell[R,C-3])}, {VARCOLOR(SV, Cell[R,C-3])}.
{XSeries}	HeaderGroup	Graph	Use this tag to specify an alternative row for the chart reports to use as the X-axis data series. If this tag is missing, the default period labels are used as the X-axis data series.
{XSeriesEnd(StatusDate)}	HeaderGroup	Graph	Use this tag to specify how far the X-axis data series needs to be mapped to the chart. The parameter StatusDate specifies here that the X-axis data series must be mapped up to the Status Date.
{YSeries1}	HeaderGroup	Graph	Use this tag to specify an alternative row to be used for the first Y-axis data series. By changing the number at the end of the tag, other data series can also be specified.

Example

Here is an example that uses one of the tags listed in the table.

Tag	Description
<Footer>{Report}{PRINTIF(DisplayReportOptions, True)}	Use this tag to display the row only if the parameter DisplayReportOptions= 1.
<Header>{Criteria2}{PrintIf(Criteria2.Index,First)}	Use this tag to display the row if iterating a Criteria2 collection and it is the first element of the collection. Acceptable values for the second parameter are First, Last, and non-zero numerical values.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Other Tags

Use the Other tags to create or modify a report template.

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

Tag	Sections	Report Types	Description
{ApplyCellFormat(<tag>)}	HeaderGroup	All	This tag accepts a single parameter that specifies which tag or cell reference will determine the cell’s format. If a tag is specified, then that tag must also be present in the cell. If a cell reference is specified, then it can be any cell, provided that it meets the following conditions: The referenced cell must be in the same report section as the referring cell. The referenced cell must not also contain Cell[] references. Only relative cell references are supported, for example. Cell[R, C-1]. Cell references to a Row Label cannot be used to set the cell’s format. For example: {=IF(CostSet1.PeriodN.Date <= CostProject.StatusDate,CostSet1.PeriodN.Value,0)}{ApplyCellFormat(CostSet1.PeriodN.Value)} This tag does not have any effect unless the following report parameter is enabled: ApplyCellFormat=1.
{AutoFit}	HeaderPage, HeaderReport	All	This tag sets the column contents to auto fit when you place it on a page or report level header or footer. This tag should be placed in the first column.
{Cumulative}	HeaderGroup	Graph, CAP	This tag makes a CAP report cumulative-based without adding an extra cumulative line.
{CumulativeLine}	HeaderGroup	CAP	This tag makes a CAP report cumulative-based by adding an extra cumulative line.
{Down}	HeaderReport	CPR	N tag expansion direction. Your options are Right or Down.
{Group}	HeaderGroup	Aggregated, Model Except: Model (Log), Model (Report)	This tag adds Excel grouping (expand/collapse). When using grouping in hierarchical reports such as CAP, an extra blank footer row must be present for each grouped entity section. This allows the reporting engine to correctly place the + signs for grouping. This tag should be placed in the first column.
{HIGHLIGHT(Cell[R,C-3],C,P,J43,V,ValuePercentBoth)}	HeaderGroup	CPR	Use this tag to indicate the threshold highlighting. The parameters in the sample highlight tag are described as follows: <Cell[R,C-3]> parameter indicates the cell reference of: If the current cell contains the percent variance, the reference cell contains the value variance. If the current cell contains the value variance, the reference cell contains: The Budget value if data type is Schedule. The Earned value if data type is Cost for Period or Cumulative. The BAC value if data type is Cost for At Complete. The <C> parameter indicates if the cell contains cost (C) or schedule (S) data. The <P> parameter indicates period. Possible values are: A (At complete), P (Period), and C (Cumulative). The <J43> parameter is the cell reference where formatting is specified. The <V> parameter indicates if the cell contains value or percent data. Possible values are: V (Value cell) and P (Percent cell). V is both the default and optional value. The <ValuePercentBoth> parameter indicates the highlighting value to apply. Possible values are: ValueBoth: Shows highlight if value or both value and percent exceed threshold. PercentBoth: Shows highlight if percent or both value and percent exceed threshold. ValuePercentBoth: Shows highlight if value, percent, or both value and percent exceed threshold. This value is both default and optional.
{Insert}	HeaderPage	CAP, Summary	N tag expansion function. Options are Replace or Insert. The Insert function expands the N tag by inserting new rows or columns.
{MinimizeFormulaCalculation}	Cell A1	CAP	Use this tag so that Cobra only calculates the formulas it needs to generate the report instead of automatically calculating all the formulas. This tag can help reduce Cobra's memory requirements on exceptionally large reports. Using this tag with the automatic calculation option disabled on the report template (Formulas > Calculation options > Manual) will cause the generated report to display blanks or incorrect values for cells containing formulas that Cobra did not calculate. You need to manually calculate formulas on the generated report by pressing F9 or by using the Calculate Now command Formulas > Calculate Now). This tag should have no impact on the generated report if automatic calculation is enabled in Excel ( > Excel Options > Formulas > Calculation Options > Automatic), which is enabled by default.
{NewPage}		All	Use this tag to add a new page. This tag should be placed in the first column.
{NoCellFormat}	HeaderGroup	All	Use this tag to ignore the ApplyCellFormat parameter for this cell. This cell’s format will be copied from the template.
PRINTIFOTHERWISE	HeaderGroup	All	Use this tag to display the row only if one or more PRINTIF tags are defined within the same section and none of them is displayed for the current data element.
{PRINTIF(<Expression>, <Value>)}	FooterReport, HeaderGroup	All	Use this tag to display only the row if the <Expression> expression has the value <Value>. The expression for <Expression> must evaluate to an entity property. This tag should be placed in the first column.
{=REMAININGPERIODS(expression)}	HeaderGroup	Aggregated	Use this tag to expand the expression into a sum expression based on the number of periods in the calendar. For example, if the calendar has 13 periods and the expression is CostSet1.Period1.Value, the tag will be expanded to =CostSet1.Period1.Value+ CostSet1.Period2.Value+.+ CostSet1.Period13.Value.
{Replace}	HeaderReport	CPR	N tag expansion function. Options are Replace or Insert. The Replace function expands the N tag by overwriting any cells without inserting new rows or columns.
{Right}	HeaderPage	CAP, Summary	N tag expansion direction. Options are Right or Down.
{RowLabel:<RowLabel>}	HeaderGroup	All	This tag provides a reference to a row based on its label. The label can be referenced in a Cell formula. Attention: For more information, see the Formula Tags help topic.
{SortCode<Code>}	FooterReport	CPR	Total for Sort Code <Code>.
{SubTotal}	FooterReport	CPR	This tag indicates where the subtotal value displays on the footer of a CPR report.
{UseLowMemoryOutput}	Cell A1	CAP	Use this tag to generate the report using features that significantly reduce Cobra’s memory requirements. This tag must be specified in cell A1 of the report template and is only supported for some reports. Attention: For more information, see Reduce Memory Consumption for Very Large Reports.
{VARCOLOR(VAC, Cell[R,C-2])}	HeaderGroup	CPR, Model (Project)	This tag indicates the variance coloring function. {VARCOLOR(CPI)}, {VARCOLOR(SPI)}, {VARCOLOR(CV, Cell[R,C-3])}, {VARCOLOR(SV, Cell[R,C-3])}.
{XSeries}	HeaderGroup	Graph	Use this tag to specify an alternative row for the chart reports to use as the X-axis data series. If this tag is missing, the default period labels are used as the X-axis data series.
{XSeriesEnd(StatusDate)}	HeaderGroup	Graph	Use this tag to specify how far the X-axis data series needs to be mapped to the chart. The parameter StatusDate specifies here that the X-axis data series must be mapped up to the Status Date.
{YSeries1}	HeaderGroup	Graph	Use this tag to specify an alternative row to be used for the first Y-axis data series. By changing the number at the end of the tag, other data series can also be specified.

Example

Here is an example that uses one of the tags listed in the table.

Tag	Description
<Footer>{Report}{PRINTIF(DisplayReportOptions, True)}	Use this tag to display the row only if the parameter DisplayReportOptions= 1.
<Header>{Criteria2}{PrintIf(Criteria2.Index,First)}	Use this tag to display the row if iterating a Criteria2 collection and it is the first element of the collection. Acceptable values for the second parameter are First, Last, and non-zero numerical values.