CiviCRM Community Forums (archive)

I'm new in the use of the tool CiviCRM. I would the help of someone with urgency. I would like a report that shows the total amount of the contributions spent in a year by membership, this needs to bring a text to explain it.
Thanks in advance.

Seal

Thanks Rajan.
I already knew the Donor Report (Summary) and Donor Report (Detail).
But what I wanted was a donor/page and insert a fixed personalized text.

More or less this:

Name                                 Total
-------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXX  $250

Comments:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Date: 99-99-9999

Thank you, I think that really helps.
But my knowledge in PHP are a beginner. I have difficulties, but I'll try, for example the jump page for donor I do not see how.

Hey,
It would be easy to help, if you can specify your requirements in details and where your getting stuck while customizing the report.

Rajan

Basically u need to manipulate report result, you have $rows in .tpl file to display report result. Bydefault civireport uses table layout to display the result but u can change this accordingly by overriding .tpl file of that report.
Bellow is the example, to manipulate report result ( it will just display contact name ), same way u need to do this.
You can put
{debug}
at top of the .tpl file to debug all smarty variables, here you can find $rows values too.
Hope this will help you u to getting started.

Example Diff is as bellow OR u can take whole tpl code ( templates/CRM/Report/Form/Contribute/Repeat.tpl ) from http://pastebin.com/raTsAwk9
===================================================================
--- templates/CRM/Report/Form/Contribute/Repeat.tpl (revision 35001)
+++ templates/CRM/Report/Form/Contribute/Repeat.tpl (working copy)
@@ -23,4 +23,48 @@
  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  +--------------------------------------------------------------------+
 *}
-{include file="CRM/Report/Form.tpl"}
\ No newline at end of file
+    {if $section eq 1}
+    <div class="crm-block crm-content-block crm-report-layoutGraph-form-block">
+        {*include the graph*}
+        {include file="CRM/Report/Form/Layout/Graph.tpl"}
+    </div>
+    {elseif $section eq 2}
+    <div class="crm-block crm-content-block crm-report-layoutTable-form-block">
+        {*include the table layout*}
+        {include file="CRM/Report/Form/Layout/Table.tpl"}
+ </div>
+    {else}
+    <div class="crm-block crm-form-block crm-report-field-form-block">
+        {include file="CRM/Report/Form/Fields.tpl"}
+    </div>
+   
+    <div class="crm-block crm-content-block crm-report-form-block">
+        {*include actions*}
+        {include file="CRM/Report/Form/Actions.tpl"}
+
+        {*Statistics at the Top of the page*}
+        {include file="CRM/Report/Form/Statistics.tpl" top=true}
+   
+        {*include the graph*}
+        {include file="CRM/Report/Form/Layout/Graph.tpl"}
+   
+        {* include the table layout*}
+        {* Here u have $rows to maniputate result accordingly*}
+ <table>   
+ {foreach from=$rows item=row key=rowid}
+   {* eg: display contact name *}
+   <tr>
+            <td>
+            {ts}Contact Name:{/ts}{$row.contact_civireport_sort_name}
+            </td>
+          </tr>
+        {/foreach}
+        </table>
+    <br />
+
+        {*Statistics at the bottom of the page*}
+        {include file="CRM/Report/Form/Statistics.tpl" bottom=true}   
+   
+        {include file="CRM/Report/Form/ErrorMessage.tpl"}
+    </div>


Rajan