<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div class="post-text" itemprop="text">
Hello,<BR>I have a report page and I want to create a summary page for my report.<BR><br>There are multiple fields and that fields have multiple states;<BR>Code (unique) | (Status) | Department<BR>1 | Open | Network<BR>2 | Close | Network<BR>3 | Close | Security<BR>4 | Close | Security<BR>5 | Open | Security<BR>6 | Open | SQL<BR>7 | Open | SQL<br><BR>8 | Close | SQL<br><BR><br><BR>By using these table I want to generate a view where each department has one row. For each row you can see how many Close or open cases have.<BR><br><pre style="" class="default prettyprint prettyprinted"><code><span class="typ">Departmant | Open | Close<br>Network | 1 | 1</span></code><code><span class="typ"><br>Security | 1 | 2</span></code><code><span class="typ"><br>SQL | 2 | 1</span></code></pre>
Or if I expand the status like Open, Close, Resolved<br><BR>
<pre style="" class="default prettyprint prettyprinted"><code><span class="typ">Departmant | Open | Close | Resolved<br>Network | 1 | 1 | 1</span></code><code><span class="typ"><br>Security | 1 | 2 | 0</span></code><code><span class="typ"><br>SQL | 2 | 1 | 2</span></code></pre>
And for the sum of the cases;<br><BR>
<pre style="" class="default prettyprint prettyprinted"><code><span class="typ">Departmant | Cases | <br>Network | 2 | </span></code><code><span class="typ"><br>Security | 3 | </span></code><code><span class="typ"><br>SQL | 3 | </span></code></pre>
Could you please help me how to generate a page like this ?<BR><br><BR>Thanks,<BR>No RegreTs<br><BR>
</div> </div></body>
</html>