Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
1
vote
1answer
81 views

CiviReport's and CiviContribute Charts not displaying

We are using civi 5.3 on Wordpress 4.9. Using CiviReports or CiviContribute, I am selecting Charts, and clicking the view button. The chart is not loading. I saw the other answers suggesting that I ...
1
vote
2answers
82 views

Constituent (summary) report: link to contact instead of link to constituent detail?

When opening the Constituent (summary) report and clicking on a name in the results list, the page which refers to the specific Constituent detail doesn't open. Reason for that seems to be the number ...
1
vote
2answers
46 views

Using an External (custom) Table in a Custom Report

I have several custom tables that I have created for use with extensions that I have built. I would like to use those tables in a custom report. What is the best approach for this? I checked the ...
1
vote
1answer
40 views

Is calling the api in a report template 'bad form'?

Just a small question - but I've been asked to add 'Address Location Type' as a column in a report. At least as of our civiCRM version (4.7.13) the address seems to me to only contain the location ...
1
vote
2answers
52 views

Thank You Letter Report

How can I include the "Thank you Sent Date" filed in a report
1
vote
1answer
33 views

CiviReport - Can Report Titles be sorted?

I've created about 20 reports under Event Reports but Civi seems to sort the report titles in order of creation. Is there way to have the report titles sorted alphabetically?
1
vote
1answer
36 views

Advanced Search gives different dataset than same search in Reports

When I use the Advanced Search or Search Builder to select a dataset the returned contacts are correct. If I do the same search using in CiviReport with the same search criteria one contact is ...
1
vote
2answers
72 views

How to get name of Financial Type ID?

I am adding some custom code to the Bookkeeping Report so that each Financial Type's sub total is added to the bottom in the statistics. I have successfully done so, but I can't figure out how to list ...
1
vote
2answers
53 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
42 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
90 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
74 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
265 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
2answers
28 views

how to set permissions on individual CiviReports (permission options not shown!)?

I wanted to create several reports that are limited to specific CiviCRM ACL roles. But I can't, because when I view the "Access" tab for the report settings, there are no permission fields shown. ...
1
vote
1answer
37 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
30 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
28 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
112 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
61 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
15 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
17 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
30 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
30 views

How can I search for or report on contacts based on date, method and/or status of group subscription?

With GDPR coming down the track I'm keen to dig in to my contact lists in more detail. I'm looking the ability, ideally through the UI, of reporting on, and searching for, contacts based on the date ...
1
vote
2answers
55 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
75 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
84 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
39 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
61 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
99 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
81 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
105 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
56 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
57 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
174 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
280 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
94 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
57 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

Membership Report Issues

I have a discrepancy of 15 contacts between reports and need help figuring out where the error is. The Membership Summary is showing 1,108 members and yet the Membership Detail Report is showing only ...
1
vote
2answers
23 views

List activity for all members (whether they have contributed or not)

Our treasurer has asked for a report to show the payment history for each contact, even if that contact has never paid anything. 'Contribution Aggregate by Relationship' report is perfect, we select ...
1
vote
1answer
11 views

How can I show multiple repeating custom field values in a single cell on a report?

We woud like a simple contact report which, rather than showing a single row for each custom field (with repeating contact name on each row), shows a single row for the contact and shows all the ...
1
vote
1answer
9 views

Mailing List Activity Report

I wonder if there's a way to get a report on a mailing list's subscription activity, showing signups and unsubscriptions. I don't see this option on the activity report and none of the Mailing report ...
1
vote
1answer
24 views

CiviCRM Report - Sorting DB error

when I'm preparing a report (Event Participants) through CiviCRM Report module and I want to sort the results by anything (age, name, etc) I am getting a fatal error: DB ERROR: No such field I'm ...
1
vote
1answer
11 views

'A potentially unsafe operation has been detected in your request to this site' error

I want to get a membership list contaitning their name and address through the 'Report' function. But when I do this, a message 'A potentially unsafe operation has been detected in your request to ...
1
vote
1answer
20 views

Add columns to SYBUNT report

We run CiviCRM 5.20.2 on Joomla 3.9.15 We use Reports - Donation Reports - Sybunt We need to be able to select in the Columns area: • Nickname • Do not mail / contact • Deceased • Postal ...
1
vote
1answer
31 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
4
5
6 7 8