CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Is there any way to include "details" in an Activity Report?
Pages: [1]

Author Topic: Is there any way to include "details" in an Activity Report?  (Read 1192 times)

jeffmikels

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
Is there any way to include "details" in an Activity Report?
March 03, 2010, 11:09:49 pm
USE CASE:
I'm using CiviCRM to track prayer requests people submit during Sunday services. Currently, I have created an "Activity" called Prayer Request. When a request is submitted, it is recorded with the content of the prayer request in the "details" field of the activity and labeled scheduled. After the team prays for the person, it is labeled "completed."

I have created a report and cron job to automatically email a report of "scheduled" requests to my team, but I can't figure out a way to get the "details" included in the report. I don't really want to write my own database queries and report generator if the feature is already implemented in CiviCRM, but I need the details field in the report.

QUESTIONS:
1. Is this method the best way to track prayer requests?
2. How can I get "details" included in an activity report?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Is there any way to include "details" in an Activity Report?
March 03, 2010, 11:48:49 pm
jeffmikels :

Quote
1. Is this method the best way to track prayer requests?
You might want to create an activity type = "Prayer Request" and while creating a report you could restrict it to
Activity Type Is one of "Prayer Request" in Set Filters section.

Quote
2. How can I get "details" included in an activity report?

You might want to look at the patch below :

Code: [Select]
Index: CRM/Report/Form/Activity.php
===================================================================
--- CRM/Report/Form/Activity.php (revision 26449)
+++ CRM/Report/Form/Activity.php (working copy)
@@ -126,6 +126,8 @@
                                                'subject'           =>
                                                array( 'title'      => ts('Subject'),
                                                       'default'    => true ),
+                                               'details'           =>
+                                               array( 'title'      => ts('Details') ),
                                                'source_contact_id' =>
                                                array( 'no_display' => true ,


HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

jeffmikels

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
Re: Is there any way to include "details" in an Activity Report?
March 04, 2010, 04:39:47 am
Perfect! Thank you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Is there any way to include "details" in an Activity Report?

This forum was archived on 2017-11-26.