Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
1
vote
2answers
44 views

Total Donations By Contact

I am looking to pull a report that has the donation total for each contact. Basically the top donor report but for all donors. What report will give this to me. Thanks, Josh
1
vote
1answer
40 views

REPORTS-Participant List 4.6.10

I edited the report for our needs, which is a primarily a list of attendees. We only require the following for our reporting needs: Name Organization Event Status Start Date End Date I cannot get ...
1
vote
1answer
43 views

Custom fields in CiviGrants

I have just added some custom fields to grants but they dont show in reports - what have I missed? How do I get them to show up and be available in reports? Cheers - Phil
1
vote
2answers
82 views

Report of multiple different memberships per contact in one line

CiviCRM 4.6.8 and WP 4.3.1 Many of our members have two memberships, a main membership (ie. Professional or Student) and a State(or area) Chapter membership (ie. California or New England, etc.). ...
1
vote
3answers
71 views

Civisualize extension doesn't show up as available when uploaded to extension directory

I downloaded the master zip file from this extension to my extension directory of civicrm. https://github.com/TechToThePeople/civisualize I unzipped it in the extension directory. flushed cache. The ...
1
vote
1answer
258 views

Missing fields and reports in database after migrating to a new server

What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this guide. Here are the steps I've been taking to for the migration. 1.) SQLDump ...
1
vote
1answer
33 views

Is 'developer' tab in Reports now a deprecated feature?

In Civicrm 5.4 and in current version in WP Sandbox, it seems that the 'Developer' tab is no longer shown. What is the replacement/suggested method for adding a column to reports now?
1
vote
1answer
18 views

How do you set a fiscal year?

Also - does changing a fiscal year change anything else outside of reporting and searching?
1
vote
1answer
24 views

How to identify and report on donor anniversaries?

We'd like to acknowledge donors who have given continuously for (say) 5 years. Let's say 'continuous' means at least one donation in a year. How could these contacts be identified and reported? I've ...
1
vote
1answer
63 views

PHP warning “Warning: Declaration of CRM_Mailchimp_Permission” logged when open a CiviReport

Drupal 7.67 Civi 5.13.4 I get a PHP warning in my Drupal logs every time I open a report in Civi. The complete warning is Warning: Declaration of CRM_Mailchimp_Permission::check($permissions) should ...
1
vote
2answers
55 views

Civicase report shows empty list

I have set up report to list the number of active cases, however the report doesn't show anything when I refresh results, even though there is a number of opened cases which show in the Case dashboard....
1
vote
1answer
14 views

Is it possible to write a report to send a weekly digest of people who have filled in a webform survey

I would like to send a report once a week to a client with everyone who has filled in a survey in the last week and has a particular tag. IN civireport I can see I can filter by activity subject but ...
1
vote
1answer
18 views

Is there a report to export the transfers from CiviCRM to my bank account?

I can see all of the payments that people make, but I would also like a CSV export that includes the transfers from civiCRM to my bank account. Is there a report for that?
1
vote
2answers
37 views

Case Details Report- Active Case Role filter

Trying to run a case details report for all cases of type "x" opened between a given date range. Noticed that not as many cases as expected show. On further investigation found that there is a ...
1
vote
2answers
16 views

Donors who gave the same amount in X and Y year

Is there a report in the Current version of CiviCRM that can tell us this? https://civicrm.org/extensions/advanced-fundraising-reports seems to have reports that will show if the giving is increased ...
1
vote
1answer
24 views

How do I set the margins on a PDF print out of a CiviReport?

How do I set the margins on a PDF print out of a CiviReport? Things I tried: Setting these in print.css on the body element. had no effect.
1
vote
2answers
42 views

Particular report about contribution on CiviReport

Good morning, I'm writing to ask if it exist a particular report about contributes. I'd like to have a report which contain these columns: Surname/Name, amount and date of the last donation and total ...
1
vote
2answers
66 views

Reporting options

So a few things, when I create a custom report display, by adding additional fields to display. Is there anyway to re-order the fields. so for example if I want lastname, then first name...or other ...
1
vote
1answer
81 views

Contribution Summary throws 500 error

Uncaught Error: [] operator not supported for strings in /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Summary.php:580 Don't know whether this started with Civi 4.7.19, WP 4.8, or ...
1
vote
2answers
38 views

Why is the Actions button missing from Reports on 4.7.x after upgrade

After upgrading, several sites are missing the Actions on the Reports
1
vote
3answers
59 views

CiviCRM upgrade from 4.2.7 to 4.7.13 fails to show any report

CiviCRM was updated from 4.2.7 and right now is even updated to 4.7.16 but when we try to get reports and even try to click on "Refresh Results" it shows nothing, not even an error about it. The ...
1
vote
2answers
88 views

Display all Contributions with event, membership etc details

Excuse me if I'm probably missing something obvious here... Civi 4.6.18, Drupal 7.44 I want to build a simple report that shows: Contribution fields, Contact name, Event name (if it came from an ...
1
vote
1answer
79 views

Show Event Custom Fields in Reports

I have an event with custom fields that I use to collect information relevant to each participant's registration (for example, number of guests accompanying, seat preference, etc.). When I view the ...
1
vote
2answers
102 views

Add county to reports

I'm looking for a way to add sorting and/or grouping by county to reports. Specifically, Membership Details and constituent Details. I've tried a bit of monkeying with the PHP but I don't seem to have ...
1
vote
1answer
54 views

Civicrm Reporting

In Civicrm in Contact reports I used the template called Relationships. Our data is as follows: We have Household Members, those members reside in a Residential Community(in our cases Caravan Parks ...
1
vote
2answers
56 views

How to have a Detailed Membership Report filtered/sorted by pertaining Organization

I have several Organizations I need a Report which displays the following columns : Organization, Membership Type, Member (first and last name), email, Phone, Status I would like this Report sorted ...
1
vote
2answers
165 views

Coding Custom Report

I'm having some trouble coding a custom report. I found the following tutorial which was helpful, but I'm having trouble with the actual coding as I am still new to civiCRM developing, and I haven't ...
1
vote
1answer
33 views

How can we add Batch information to the Bookkeeping report?

Batch name/title information does not show up in the columns available to the Bookkeeping report. Is there a way to add this? As an alternative, we would also be open to creating a new bookkeeping "...
1
vote
1answer
264 views

How to get a participant list of multiple events ordered by event name

I want to get a list of participants of multiple events ordered by event name (primary) and participant name (secondary) but I don't know how to accomplish this with CiviReport. The result should look ...
1
vote
1answer
91 views

Dashlets on Dashboard displaying Not Found error

Following an earlier question about a missing field in Views 3 I opted to go down the route of creating a completely custom report. With this done and working correctly, I attempted to place it on ...
1
vote
2answers
54 views

How can we have recurring related fields on custom report?

I want recurring related fields on the custom report, but there is only one field available as per the civicrm i.e. Recurring contribution ID. The fields that I was looking for are Recurring Units, ...
1
vote
1answer
28 views

Submit Button Hidden on Reports for adding contact to group

On CiviCRM 4.6.7 on Drupal 7, under the report settings, there is an option to add the report results to a group. There is no button present for submitting it. Upon reviewing the code I see this line ...
1
vote
1answer
61 views

Creating a report listing contacts grouped by an employer-group

How can I create a report that lists contacts & their employer, but groups them by a employer group? I.e. Sports John - Adidas Jane - Nike Food Jim - Kraft Jack - Nestle And so on.
1
vote
1answer
28 views

Check numbers in reports

My client took great pains to record check numbers and payment amounts and wants to produce an event payment report which includes the check numbers associated with each registration. I can get ...
1
vote
1answer
23 views

SYBUNT (some year but not this year) showing 2011 as this year

When doing this option in civireport or LYBUNT (last year but not this year) Its showing this year as 2011. everything else is showing the correct years... why is this not?
1
vote
2answers
45 views

Creating specific Report

How would we go about achieving the following report results? (I have looked at the report page but haven’t worked with this yet) I have pasted a snippet below.
1
vote
2answers
60 views

How to send email report FROM other than default email address?

I have a report that is sending successfully every week. Only issue is I was not able to set FROM email address for the report. It’s always sent from default email address, but I need to send from ...
1
vote
1answer
46 views

Can't get a list of people whose birthday in current month

We want to see a list of people who have birthday next month. Advanced search doesn't suit us because it is trying to do search only for a current year. We use SYSTOPIA Birthdays for generating ...
1
vote
1answer
33 views

Adding new grouping to a report

I'd like to add a new grouping option to an existing report. Is it possible to group by the payment instrument in the Contribution Summary Report? The option Payment Instrument is not showing up on ...
1
vote
1answer
29 views

Wrong time in Mailing Report

as said in the title, the mailing report seems to have a wrong time...when I send a mailing to my private email adress at 4 pm and open it right away, the mailing report says I opened it 2 hours ago. ...
1
vote
1answer
28 views

How to report on repeating custom fields

My client wants a report on a set of 10 repeating custom fields, each one of which has a date and one of a set of outcomes. e.g there is an 'Accommodation' custom field which has 2 fields - a date and ...
1
vote
1answer
14 views

Contribution Reports and disabled Financial Types

What is the expected behaviour for Contribution Reports in regard to disabled Financial Types (for example, a Financial Type that was used some years ago but is not used for current contributions)? ...
1
vote
2answers
107 views

Can I link memberships to relationships automatically?

I'm using CiviCRM to manage sponsors of children in India for an NGO. I'm configured it and set up some custom fields in order to have the children(contact) connected to the membership. So far so ...
1
vote
1answer
40 views

How to hide configuration tabs of a report with the “print to pdf” action remaining active?

I want a category of users can access some reports, view the results on the screen and print them to PDF. And to prevent any modification of the criteria, I want all the report configuration tabs to ...
1
vote
2answers
20 views

How to get a list contacts that have not donated within a certain amount of time?

Hello CiviCRM community, I've been trying to wrap my head around this and can't seem to figure it out. I'm looking to get list of contacts that have not donated within a certain amount of time to ...
1
vote
1answer
104 views

SQL Error in Contribution Details Report

Can someone help me resolve this error? I have recently started using CiviCRM but the website has been up for years. Thanks for helping. Arthur Running CiviCRM 4.7.27 with Wordpress 4.8.4 On the ...
1
vote
1answer
16 views

Drupal Views using over ride feature with civicrm fields - token

I am wonder whether someone can help explain how to use the Override feature for CiviCRM fields in views. For example, I have a field in Civi which is a file field... when i add it to a view it shows ...
1
vote
1answer
160 views

Why am I getting 'DB Error: no such field' when editing a report?

I just upgraded to 4.7.27 under Drupal 7. Now, when I try to edit a report, I get 'DB Error: no such field' when trying to save the report. Changes are not saved. Here is the backtrace: #0 /home/...
1
vote
1answer
17 views

How can we run a report that doesn't split records into multiple entries?

We want to run a report on the enquiries/feedback and the outcomes and signposting that result from each one. However, when we run a report it splits each record entered into individual records for '...
1
vote
1answer
26 views

How to add a column in a membership report for a secondary email?

I need to run a report which has a column for a secondary email.