Customization of Activity Report: Add Contact Field for Target

[Detlev]

We have a use case, where we need to display the current_employer field for the target contact (and also sort by that field).

I set up a customized report (using the recipe from the CiviCRM Cookbook) and was able to do certain customization tasks. However, adding other contact fields seems to be tricky...

Had anybody out there done something like that and could give me a hint?


Cheers,
Detlev

[Erik Hommel]

I have not found it too tricky to add contact fields, you have to add them to the array of columns and check that they are set up in such a way that the SQL being build by the _select, _from and _where methods can actually pull them together correctly?
You might want to try a debug on your query in the postProcess method, just before the buildRows method is called.

[Eileen]

I don't know how far it takes you - but the extended reports extension has an activity report in it which allows some more control over the 3 sets of contact fields (target, source & assigned).