Activity Report in Views
No aggregation necessary.

Under relationships add two relationships for activity contacts.  Select one to be the source and the other to be the target.

Once you've got those relationships, you can add two display name fields.  One tied to the source relationship and one tied to the target relationship. 

Under filters add activity is deleted false, activity is current revision true.

In the fields section, in the activity ID settings select filter repeats.