Adding Group Computations to a Report Recipe
Users want a report that allows them to perform calculations between different fields in a grouping report. This allows for complex metrics on the grouped items in the report.
Add group computation tags to a grouping report recipe to perform computations between different item fields. Group computations are applied to multiple fields in a group of items.
For example:
<%version 1%>
<%description <b>Description: </b>This is a report that uses
PTC RVS group compute report tags.<br><br>%>
<%param name="reporttitle" type="String" prompt="Report Title"
value="" description="Descriptive title for your report."%>
<%param name="reportheader" type="MultiString" prompt="Report
Header" value="" description="Text appearing at the top of the
report page."%>
<%param name="reportfooter" type="MultiString" prompt="Report
Footer" value="Confidential - Internal Use Only"
description="Text appearing at the bottom of the report page."%>
<%param name="groupcomputeheading" type="String" prompt="Group
Compute Heading" value="Group Metrics" description="This is
displayed at the top of the group compute area."%>
<html>
<head>
<title>Group Compute Report</title>
<%screenStyleSheet%>
<%printerStyleSheet%>
</head>
<%dateformat%>
<%datetimeformat%>
<%sortby &sortby%>
<body>
<span class="logo"><%logoURL%></span>
<p class="title">&reporttitle</p>
<p class="header">&reportheader</p>
<div align="right" class="date"><%currentdate%></div>
<table class="display">
<tr><td colspan="&#fields"><hr class="hr_default"></td></tr>
<!-- Display item field headings -->
<tr>
<%iteratefields%>
<th class="heading1">&fielddisplayname</th>
<%/iteratefields%>
</tr>
<tr><td colspan="&#fields"><hr class="hr_default"></td></tr>
<%groupby &groupby%>
<!-- Display first group heading -->
<tr>
<td colspan="&#fields" class="grouping1">
<%groupname%>: <%groupvalue%>
</td>
</tr>
<!-- Display item field values -->
<%begindetail%>
<tr>
<%iteratefields%>
<td class="border">&fieldname</td>
<%/iteratefields%>
</tr>
<%enddetail%>
<!-- Display group compute -->
<tr class="right">
<td colspan="&#fields">
<table class="list2">
<tr>
<th colspan="2">&groupcomputeheading</th>
</tr>
<%iterategroupcompute%>
<tr>
<td class="bold"><%groupcomputelabel%></td>
<td><%groupcompute%></td>
</tr>
<%/iterategroupcompute%>
</table>
</td>
</tr>
<tr><td colspan="&#fields"><hr class="hr_default"></td></tr>
<%endgroup%>
<tr><td colspan="&#fields"><hr class="hr_default"></td></tr>
</table>
<span class="footer">&reportfooter</span>
<div align="center">
<a href="<%weburl%>im/runreport?selection=¤tReportName">
<img src="<%weburl%>Report_Recipe/re-run_report.gif"
align="middle" border="0">
</a>
</div>
</body>
</html>