Grouping and Group Counts in a Report Recipe
Users want a report that has the ability to group items together and give a count of the number of items in each grouping. This would make reports easier to read and provide a quick item overview.
Create a report recipe containing grouping tags that allow users to select a field they want to group the items by, and display the grouping field, value and count for each grouping in the report.
For example:
<%version 1%>
<%description <b>Description: </b>This is a report that uses
Windchill RVS grouping 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>Grouping 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 first group count -->
<tr>
<td colspan="&#fields" class="right">
<p class="bold_color">Group Item Total: <%groupcount%></p>
</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>