Adding Group Field Computations to a Report Recipe
Users want a report that allows them to perform calculations on each field in a grouping report. This provides simple metrics for each item field.
Users can add group field computation tags to a grouping report recipe to perform computations on item fields. Group field computations are applied to a single field in a group of items, and a different computation can be created by the user for each field.
For example:
<%version 1%>
<%description <b>Description: </b>This is a report that uses
Windchill RVS group field 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."%>
<html>
<head>
<title>Group Field 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 field compute -->
<tr>
<%iteratefields%>
<td class="nowrap">
<span class="bold">&fieldgroupcomputedisplayname</span>
&fieldgroupcompute
</td>
<%/iteratefields%>
</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>