Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

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

Event Report filter not working

I am trying to create an event report but I am not able to filter a specific event in the Event filter, it shows as "None found" even when there are active events present and there is no error in the ...
2
votes
1answer
16 views

Using CIVICRM to manage a Fundraising Dinner

We run a fundraising dinner once a year, approx 400 people, mainly couples. what would be the best way to a: set up an event that we can enter couples as contacts (we have to write to them post ...
3
votes
0answers
23 views

Need a list of past event participants and several years are gray, can't access them

when i search for events they all show up, but some of them are grayed out and I can't access any information: I get this error-- An error has occurred. 0 @import url(/administrator/components/...
2
votes
1answer
19 views

CiviReport Max Participants

I currently generate an Event Report of upcoming events that shows how many participants are registered for each event, but I'd also like for it to show the max participants allowed. When looking ...
1
vote
0answers
11 views

CiviReport sort event list by start date

Similar to CiviReport Participant Sort by Event Start Date I would like my event report (Extended Report - Statistics across events) to display events ordered by event start date. I am on CiviCRM 5....
1
vote
1answer
32 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?
2
votes
1answer
35 views

Filter event reports by facilitator

Currently if I want to collate a report on events facilitated by a particular individual (or, say, run by a partner organisation, or any contact with a custom role), I have to go to each event from ...
2
votes
1answer
57 views

Multiple entries showing on a report

For some reason, a particular report shows multiple entries for some users. These users have ACLs applied, so I wonder if that's causing the problem? When I masquerade as a user with limited access, ...
0
votes
1answer
106 views

CiviContribute Payment Selection

Ok, this is a little difficult to explain, but I'm going to try :) A customer set up a contribution page for payroll deduction, so they would just select the "Pay Later" payment option, but, for some ...
0
votes
1answer
47 views

CiviRules Issue with Smart Groups

I am trying to use CiviRules to give a membership to contacts automatically when a contribution is added. I have a Membership smart group to filter members and non-members but getting an error when ...
0
votes
1answer
38 views

Report with access “everyone (includes anonymous)” not displaying correctly

Civicrm 5.2.2 Wordpress 4.9 I have created a report and given access to "everyone (includes anonymous)" and also given view reports permission to anonymous user. This is the URL https://leep.ngo/...
5
votes
1answer
36 views

How to creat a report of recurring donors

How do I get a report of all the donors who are set up for automatically give the same amount each month
3
votes
1answer
62 views

How can I change column width on printed reports

How do I change the width of columns on printed reports. Some columns are too wide and some are too narrow.
1
vote
1answer
17 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
39 views

Settings don't display when tabs are clicked on an existing CiviReport

Based on the doc found here (at the bottom): https://docs.civicrm.org/user/en/4.7/reporting/set-up , it should be possible to edit existing reports (like adding email settings). Currently not even ...
0
votes
0answers
14 views

Membership Report (Detail) filter not applied when first run

The Membership Report (Detail) report returns all members, including delete ones. It seems the filter isn't applied until you click View Results. Is this intentional, or a bug? I see it with 5.15.2 ...
0
votes
1answer
12 views

Contribution Report - Grouped by Custom Field

I am looking to be able to build a report that essentially has aggregate donations grouped by a custom field. For example - every donor is asked: How did you hear about us (Referral Source), which is ...
3
votes
3answers
27 views

Report based on country

Could anyone tell me how to set up a report based on the country of the member (Northern Ireland, Republic of Ireland, England, Wales, Scotland). Thanks in advance Debs
0
votes
1answer
38 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.
0
votes
1answer
71 views

Report on Cases and Activities

I need a dashlet for a user which lists scheduled activity details filtered on the 'case type' the activity sits in. I can find these in search but cant seem to get a report to work - closest I can ...
1
vote
1answer
22 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?
0
votes
0answers
30 views

Emailed copy of report includes the SQL Query

Running civiCRM 5.14.1 ... and Joomla 3.9.8 When I receive my scheduled emailed Contribution report, the email contains the SQL used to generate the report... How do I avoid this? The report is the ...
1
vote
1answer
23 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
20 views

How can I generate a CiviMail delivery & Click-thru report

I need to email a report to a person of a particular mass email that was sent from CiviMail. The person doesn’t have access to CiviCRM. How can I generate a CiviMail detailed delivery & Click-thru ...
1
vote
1answer
42 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 ...
0
votes
1answer
26 views

Is there a way to expose a CiviReport on a Wordpress page?

Reports are not one of the component options available when using a shortcode in wordpress. What is the recommended way to expose a civireport on a wordpress page?
0
votes
0answers
18 views

403 error when accessing or exporting CiviMail open reports

Running CiviCRM 5.13.5 on Drupal 7.67. I have all admin permissions, and all permissions relating to CiviReport. Trying to run reports on CiviMail to export as CSV everyone who opened a particular ...
3
votes
1answer
18 views

civiReport with financial type and line item financial types

Is there a report that displays both the overarching financial type and the individual line item financial types for contributions? civiCRM Contribution and paid event pages require a financial type ...
1
vote
2answers
52 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....
6
votes
3answers
73 views

Can we report on contributions by payment processor?

Is there support for filtering contribution reports by payment processor? We have credit card (Authorize.NET) and PayPal (new). How can I report on just PayPal transactions? The only difference I ...
3
votes
2answers
128 views

Is there a way NOT to email if a report with no result

I need to email a report weekly to a department within organisation. Report usually sent via scheduled job in Pdf format. If there's no result an email still gets sent. Is there way NOT to email an ...
2
votes
1answer
22 views

How to remove “Report URL” from emailed PDF reports header?

I would like to remove the link from a report email header. Is it easy to achieve? thanks
0
votes
1answer
89 views

CiviVolunteer error after upgrade to Civi 5.11.0 on joomla

Running civicrm 5.11.0 with CiviVolunteer on joomla 3.9.5 PHP 7.1 (as well a second site with the same problem on PHP 7.0) I am running API v4 version 4.3.0 CiviVolunteer 4.7.31-2.3.1 Since upgrading ...
1
vote
3answers
41 views

How can I generate a report for the financial transaction entered by USERS of certain “drupal Role”?

Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure ...
0
votes
0answers
11 views

Combine reports of 2 kinds. Possible?

I would like to get a report of "activities" and include some information specifically related to contribution. This is what I am expecting to see in results the report: Source name - (backend user) ...
3
votes
1answer
28 views

Rounding differences between Contribution and Bookkeeping reports

I am using Drupal 7.66 and CiviCRM 5.10.4. There is a small difference between the total of a Contribution report and a Bookkeeping report using the same filters and therefore intended to produce an ...
0
votes
2answers
125 views

Can't save reports

I'm using CiviCRM 4.7.11 on Drupal. For some time now (not sure how many minor versions) it has not been possible to create reports or to save changes to any reports. The button ("Update Report", I ...
1
vote
1answer
13 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
17 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?
3
votes
1answer
25 views

facilitators viewing registration responses

We have co-facilitators for our instructional events who are not staff. We want them to be able to view the complete registration profile responses (i.e. 'registration info') prior to their event in ...
2
votes
2answers
47 views

Report with Payment Processor [duplicate]

I'm trying to get a report with the name of the Payment Processor that was used for each online Payment. I'm not able to get this to work. Been though the API trying to track the data but not that ...
2
votes
1answer
28 views

“Post Code Suffix” in Reports is the same as “Postal Code”

I'm running CiviCRM 5.10.4 on top of Drupal 7.63 on Debian, with localisation. My contacts have UK-style postcodes with the first half (e.g. "M19") stored in "Postal Code" and the second (e.g. "3JD") ...
2
votes
0answers
128 views

Warning: htmlspecialchars() expects parameter 1 to be string, array given in …/civicrm/packages/HTML/Common.php on line 144

Has anyone else seen the above error under Joomla and CiviCRM 5.11.0 when running the Event Report: Attendee List? I've done a bit of troubleshooting and it appears it seems when a custom form value ...
1
vote
2answers
56 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
24 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
59 views

CiviReport widgets show access denied on CiviCRM Dashboard

I've recently migrated a site to another host and pretty much everything is working except that when I go to /civicrm, the dashlets on the dashboard all show Access Denied and a login form. They are ...
1
vote
0answers
9 views

summary shows only new memberships

I have summary report and a membership of active members report. When I look at the active members, for 2019 I get about 7 people. When I look at the summary of memberships (grouped per month) I get ...
2
votes
1answer
25 views

How to delete a membership report

I have copied an existing report template for my own use with the intention to use it for my search options. I don't understand how I can name it as I wish. How to rename a report when copying? How ...
2
votes
1answer
26 views

Click to go to contact record from report [duplicate]

When i am viewing contacts in a civireport if i click on the persons contact name i am taken to the "view contact detail report" which is basically the Constituent Report (Detail). Is there a way to ...
1
vote
1answer
40 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 ...