CiviCRM Community Forums (archive)

My organization needs a specific report for search listings where the result columns will include:

Organization Name
Primary Contact at Org
Most recent activity

The first one, organization name, is obviously built in. For the Primary Contact I just created a custom field for organizations. Then I created my profile for search results that will display columns of both of those. The issue is with most recent activity. Activities are not built in to profiles. Is there any way I can get the latest activity to show up in this profile? If not through the interface, then is there there a way I can add some code to make this happen? Of course, my skills are limited so I would appreciate any insight/suggestions/examples you could give!

Thanks,
Emily

If you are using drupal a module would not be that hard to make?
I could be used for this type of report?

If you make the module and just query those tables and display that data using drupal table you would get a quick view of that data.
This takes a bit of learning.
1. what civi tables
2. making a drupal module
3. and the right queries with drupal

I really could not pull it off this week.  But  I can put it down for early next week.
If you want to have a go at it the Pro Drupal Development book would be key.
And in the long run you will be more able to do alot of other neat integrations.
Al
ps..send me an email alfred@nationalpriorities.org if you do not hear from me next week, but  I will put it in my calendar since this is a report I would like for our office as well.