Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
0
votes
1answer
53 views

Searchable Custom Field doesn't appear in Quicksearch options list and is not a sort option in reports

I have 2 membership custom fields that are set as searchable. One field is integer the other is alphanumeric. Neither field appears in the Quicksearch options in Search Preferences. The custom fields ...
3
votes
2answers
81 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.
0
votes
1answer
20 views

CiviCRM Recurring Contributions Report with Campaign

I'm trying to find a way to get a report on all the Recurring Contributions and what campaign they are attached too. Has anyone else done this? The Recurring Contributions report can give me the ...
2
votes
1answer
36 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
63 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
0answers
6 views

Filter an event report with non-primary state or adress (CiviCRM 5.14.2 with Drupal 7)

I have two addresses one is a home address that's primary and main address with corresponding states. I would like to get events details of particular states coming under the primary address only. ...
0
votes
1answer
108 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 ...
1
vote
2answers
26 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. ...
0
votes
0answers
14 views

Joomla has no CiviReport permissioning, so how can I limit reports to individual users?

Welp, after the disappointing realization from this question -- that unlike the Drupal and Wordpress implementations, CiviCRM in Joomla does NOT include permissioning for individual CiviReports -- I'm ...
0
votes
1answer
41 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/...
1
vote
1answer
39 views

Attachment too large for mailing - should there have been a warning?

Recently had a user attach a .docx file that was 14 MB to a mailing. (Probably a single picture in the document was to blame.) As one would expect, the messages bounced rather than being delivered. ...
2
votes
1answer
16 views

nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()

After an upgrade from 5.7.x to 5.13.x, a standard contribution/detail report started failing. In the CiviCRM admin log, we see this sql error: nativecode=1260 ** Row 60 was cut by GROUP_CONCAT() ...
1
vote
0answers
29 views

Filter no longer works in report

We created a report to list the contacts without a contactsubtype. Previously, it worked, since a recent update it no longer works. The report is based on a filter "contacsubtype is not one of" ...
1
vote
1answer
40 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
3answers
33 views

Combining Event, Membership & Contacts into single report

So I can easily create a Search Builder for what I want, my challenge is creating a report that I can print an take to an event Criteria: Either registered for event OR A member of a specific group ...
0
votes
0answers
15 views

Lookup Field in Extended Reports

I've created a relationship report through the Extended Reports extension but have run into a challenging situation. I want the report to show detailed information (in this case, the name of the ...
5
votes
1answer
40 views

Displaying a column total in a report

Is there a way to display a column total when viewing a report? Specifically, we are wanting to run reports on contribution line items and quickly see the contribution line item total. When you do ...
1
vote
2answers
43 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 ...
0
votes
0answers
10 views

Is there a way to export a search/export GDPR Comms preferences?

I have a list of about 1000 contacts all of which were put through our GDPR compliance process in May 2018. We can export those actively opted out of email, Bulk Email etc - via the search function, ...
2
votes
0answers
6 views

Getting more detail about transactions/ invoices/ donatons

I'd like to get more detail on what exactly each transaction contains. The report I have lists the donor, transaction number, date, amount and note. It's possible to get the shipping cost by drilling ...
0
votes
1answer
18 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 ...
1
vote
1answer
30 views

How to imbed or attach a list of contacts in an email?

My users want to send an email from Civi that will have a particular group of contacts embedded in it or as an attachment. The group is featured in a report, so emailing the report seems like the ...
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.
0
votes
2answers
23 views

how to create a report based on date subscription to a group?

I need to have a report that shows members according to their date of being part of a chosen group. I can select by group but not by date of being in this group. Is this possible? (I have a special ...
0
votes
1answer
101 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
23 views

Default Value for Custom Field

I have a created a custom group and a custom field within that group. One of the Custom fields is Date. Is there any way to autoload 'current date' (today) in the default value field Using a hook or ...
2
votes
4answers
122 views

Reorder Report Columns

I'm creating a basic custom report using constituent details. I'm hoping to find a way to reorder the columns in the report. For instance, I have a custom field that I'd like to go first, and then put ...
0
votes
0answers
17 views

Report Columns not in the right order [duplicate]

I would like to reorder report columns. Is there a way to do this? It looks like someone else has asked a similar question (Reorder Report Column) but it looks like the answer is to use some other ...
1
vote
1answer
40 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 ...
0
votes
0answers
12 views

How do you display more than 50 rows in a Contribution Summary Report?

How do you display more than 50 rows in a Contribution Summary Report? I am able to export to CSV or PDF and get the full results - but I am unable to make it display on web more than 50 rows. D7 ...
2
votes
0answers
25 views

CiviCRM Report only showing 50 records

Do anyone else have Donation Reports that only show 50 records on the webpage but when you export it shows all of them? There is no pagination and looking at the demos, it looks like there should be. ...
6
votes
1answer
29 views

Annual Donor Report

I would like to setup a report where I can see each donor's total donations by year, where each column would be a different year and the corresponding total, and each row would be each donor. Please ...
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 ...
2
votes
1answer
19 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
24 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
12 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
35 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?
0
votes
1answer
51 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 ...
5
votes
1answer
62 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
1
vote
1answer
20 views

How do you set a fiscal year?

Also - does changing a fiscal year change anything else outside of reporting and searching?
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 ...
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
1
vote
1answer
24 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
0answers
34 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
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
22 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
73 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
30 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
26 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 ...