Details
Description
Steps to replicate:
1. MySql 5.7 + sql mode = ONLY_FULL_GROUP_BY
2. Select any address field e.g. city, State, Country to display
3. Create a Activity of any type and select 3 contacts as target, assignee and source. Make sure that each contact has different address field(s).
4. Run Activity Details report
Result: 3 duplicate rows due to three different address field values
Expected: 1 row with merged address field values