Report Template Format

The report template defines the layout of the report. The template contains tags, which are interpreted by the report engine to display and format data.

A worksheet named Report in the final Excel file displays the generated report. The template is included, for reference, as a worksheet in the final Excel file and is named Template.

Note: If a tag displays on a report, it is an invalid tag.

Worksheet Header and Footer

Define the header and footer on the File > Page Setup > Header/Footer tab of Excel.

The headers and footers on all shipped reports are in a standard format. The left section of the custom header displays a parameter tag to retrieve the report name, description, and filter name for the selected report. The right section of the header displays a parameter tag to retrieve the file name and description. If the file is a project, it also displays the status date of the project.

The left section of the custom footer displays the Deltek name. The middle section displays the page number and a tag to retrieve the scale factor caption. The scale factor caption is printed only if the report contains currency project data. You can define the scale factor caption printed on the report footer on the Style page of the Report wizard. The right section of the footer displays the date the report is printed.

Worksheet

The worksheet defines the layout of the report. It contains tags and fixed text that are copied directly into the report.

Enclose tags in curly brackets, in the format {<tag>}.

The N in the tags represents the order in which a field comes as you selected in the Sub-Totals page of the Report wizard. Instead of entering CriteriaN, you can also enter the actual order in which the field comes. For example, Criteria1 represents the first criteria you selected; Criteria2 the second criteria; and so on.

Section tags display in the first column of the report template.  They define the report sections (for example, Page header, Report header, grouping, and so on). Tags/content that are included in the remaining columns on the same row are included in the section. These tags are necessary for the report to run.

The remaining columns define the actual Cobra data display on the report. The following are examples of tags that retrieve Cobra data:

Sample Tag Description
{CriteriaN.Title}{Right}{Insert} This tag retrieves the criteria Title, selected from the Sub-totals page of the Report wizard, and displays it on each page of the report. Examples are Control Account, WBS, OBS, or Work Package.

Data displays on each page only if the tag in the first column has <Header>{Page}.

N.Title prints the criteria names from the selected Sub-totals page of the wizard for the number of criteria you select.  If you indicate Criteria1.Title, Cobra prints only the title from the first criteria selected on the Sub-totals page of the Report wizard.

{PeriodN.Title}{Right}{Insert} This tag retrieves the periods from the calendar you selected on the Report Wizard and displays them on the report.

The {Right}{Insert} tag indicates the insertion of data before the column to its right.

{CriteriaN.Id}{CriteriaN.Description} This tag retrieves the criteria name and description.  Examples are 1.1.1.1/1400 Frame Design if Control Account is the selected criteria,  or 01 Fuselage if  Work Package is the selected criteria.
{CostSetN.Description} This tag retrieves the description of the cost set.  For each criteria, the cost set descriptions display.
{CostSetN.PeriodN.Value} This tag retrieves the value for each cost set by calendar period.
{SUM(CostSetN.PeriodN.Value)} This tag displays the sum of all periods.
{=Cell[R-2,C]-Cell[R-1,C]} This is an example of a formula tag.  This means that the value in the row preceding the current row of the same column is subtracted from the value two rows before the current row.

Formulas are entered in the same format as any Excel formula.

Attention: For more information on formulas, see the Projects Pane help topic.

Chart

The only way the report can plot against a chart is if the template contains a chart. You must create a chart in the template using Excel and the layout tags. The chart must have a layout tag such as <Header>{CriteriaN} in column A of the template  for many criteria or <Header>{Criteria.1} for only one criteria.

Dummy sample data must be placed in the template so that the chart can plot.  When the report runs, it is plotted against the real data.

The format used in the template is the same format that is used in the actual report. This includes font, color, borders, and chart style.

Formulas are also translated from the template to the report.

Report Header

All reports contain a header section in the report body. Some reports include column headers containing both the text and tags used to label the column. Other reports, such as CPRs, include a header section that follows specific standard formatting. Headers in formatted reports such as the CPR contain both the text and the tags to retrieve Cobra data.

Report Footer

Most reports contain a footer section in the report body.  Use the footer section to indicate the bottom of the report.  
Most reports contain the following footers at the bottom of the report. These footers are used to print selections made through the wizard, such as the calendar set and sub-total criteria. The footer also displays the options for set criteria in the report’s definition. For example. the 533 report does not allow you to select cost sets, but data from cost sets are used to populate the report.  The cost sets used to populate the report display as report options under Cost Sets even though the cost sets are not actually selected through the wizard.
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)}
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)} Report Options
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)} Criteria: {ReportOptions.Criteria}
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)} Calendar Set:{ReportOptions.CalendarSet}
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)} Cost Sets:{ReportOptions.CostSets}
<Footer> {Report} {PRINTIF}(DisplayReportOptions,True)} Filter:{ReportOptions.Filter}

For these options to print at the bottom of the report, you must select the Display Report Options check box on the Save and Run page of the Report wizard.  The parameter <Property Name="DisplayReportOptions" DataType="Boolean" ReadOnly="0">1</Property> in the report definition must also be set to 1.

The types of display report options available depend on the report.  If a report does not support a calendar set, the report footer does not contain a tag to display the calendar set.