Is there any way to include the Activity Stream of a record on Reports?

Question

I want to include the activity stream of an opportunity record on the reports. Is it possible? If not, is there an alternative solution?

Irene Joy Cahilo · Accepted Answer

We found a way but it retrieves the records anyway.

1. Changed the Data Type Field from JSON to Varchar. (Changed it directly from modules/ActivityStream/Activities/vardefs.php.. Still can't change it through custom. Still stuck.)

2. On custom/modules/Reports/metadata/reportmodulesdefs.php, add this..
<?php
$additionalModules[] = 'Activities';

3. Lastly, Repair and Rebuild.

4. Now, Activities can be used in reports but it just retrieves data from the db, so it won't look exactly like the one in the Activity Stream.