Donor Report Detail does not label every row

[jobewan]

Hello!

Hope everyone is on their way to a banner New Year!

I am exporting to CSV the Donor Report Detail.  Turns out the report seems to use a "primary" row to identify the donor in question, and any/every subsequent donation under that same donor is simply - blank, beyond (of course) the amount and date.

I don't want to so negative as to say how silly this is when attempting to perform any meaningful sorts in Excel (for instance).  The amount of hand work it takes to populate these blank  rows with donor ID is profoundly wasteful.

Is there any way to produce a properly populated set of donation/transaction rows from this report without revamping it entirely?

Many thanks,

-Joe

[Kurund Jalmi]

I don't want to so negative as to say how silly this is when attempting to perform any meaningful sorts in Excel (for instance).  The amount of hand work it takes to populate these blank  rows with donor ID is profoundly wasteful.

This is done intentionally and IMO it's much friendly than showing multiple row with repeated data. I do understand sorting this exported sheet in spreadsheet will be a problem.

Is there any way to produce a properly populated set of donation/transaction rows from this report without revamping it entirely?

You will have to modify code for this report.

Kurund

[petednz]

I would agree that having the full data in an export would be useful, so would an option for 'later on' be to have both exports always available and just a checkbox to specify if you want the current version or the 'all data in all rows' version.

[Deepak Srivastava]

I think it makes sense to "always have full data for csv" and could be supported as default behaviour.

Sample fix for contribution detail would be sth like:

Code: [Select]

Index: CRM/Report/Form/Contribute/Detail.php
===================================================================
--- CRM/Report/Form/Contribute/Detail.php (revision 26048)
+++ CRM/Report/Form/Contribute/Detail.php (working copy)
@@ -342,7 +342,7 @@
         foreach ( $rows as $rowNum => $row ) {
-            if ( !empty($this->_noRepeats) ) {
+            if ( !empty($this->_noRepeats) && $this->_outputMode != 'csv') {
                 // don't repeat contact details if its same as the previous row


Filed an issue here - http://issues.civicrm.org/jira/browse/CRM-5732