The SugarCRM Community is now "read-only" to prepare for the SugarClub launch on August 3. Please visit
Announcing SugarClub - Are you in? for more information.
I want to include the activity stream of an opportunity record on the reports.
Is it possible? If not, is there an alternative solution?
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.
Retrieving data ...