CiviCRM Community Forums (archive)

I haven't done a lot of work with the grants part. If grants linking to campaigns is not supported in the core then the easiest way to link them would be to add a custom field on the grant - Called Campaign that displays the Campaign Name and stores the campaign id. If you only have a few campaigns it would be easy enough to maintain the list of campaigns as allowable values of the custom field. If you have a lot of campaigns or they change frequently then you can write a hook to provide the drop down options for that field.
I checked that this would work on the demo:, you can take a look if you get there before it gets erased:
http://drupal.demo.civicrm.org/civicrm/contact/view/grant?reset=1&id=1&cid=11&action=view&context=grant&selectedChild=grant&key=8383ef99d0d6f9c54284c0288d7c5b1f_4394
The custom field group:
http://drupal.demo.civicrm.org/civicrm/admin/custom/group?reset=1

Finally you will need to write a custom report that uses that link.

Might be worth doing it as a patch to core and adding campaign_id to the grant table and extend the grant code to deal with it natively

we'd be happy to merge the changes into the next civi release (4.4)

lobo