Summarising History Tables within a single row
<p>Hello, </p><p>I'm a little new with Crystal and I know how to do the sort of things I want in SQL but cant find how to do it here. I have been trying to create a report for our helpdesk system to show how long calls were in each status.</p><p>To give a cut down example of our system...</p><pre>Call Number | Description</pre><br /><pre>===================</pre><br /><pre>1 | My Problem</pre><br /><br /><pre>Activity Code | Call Number | Date Time</pre><br /><pre>==========================</pre><br /><pre>Helpdesk | 1 | 29/03/07 09:00</pre><br /><pre>Second Line | 1 | 29/03/07 10:00</pre><br /><pre>Helpdesk | 1 | 29/03/07 10:15</pre><br /><pre>Closed | 1 | 29/03/07 10:30</pre><br /><p>I would like to be able to get the information on how long each department had the call for and also if they had the call at all (distinctly). In SQL one could use a sub-query with an in clause, to create a 1 or 0 if the call had progressed to a second level of support. </p><p>Any help with this would be much appreciated --Alex</p>