Grouping Using Two Stored Procedures

Hi,

I am creating a set of reports in Crystal showing emails sent and delivered from users within our organisation.

Each report uses a different stored procedure.

Report 1 shows emails sent:

Sender: Person in our org
Recipient: Person outside our org
Number: number of emails sent



Report 2 shows emails recived:

Sender: person outside our org
Recipient: Person in our org
Number: Number of emails received

In crystal, the reports are grouped around the sender for report 1, and the recipient for group 2 (therefore the reports are grouped around the person in our organisation).

Now I need to create a report showing the details of the two reports combined into one, but this creates a problem when i try to group. i need to distinguish between who is in our organisation and who is it, and then to group by them.

does anyone have any idea how this may be done?

i want the report to look like this:

Person in our organisation:
-----------------------------
Sent: bob@yahoo.co.uk 26
sally@hotmail.com 4
peter@msn.com 12
Subtotal: 42

Received: fred@company.co.uk 45
vicky@hotmail.com 10
Subtotal 55

Total 97

and so on for each person.



Many thanks if you can help