Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

64 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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/...
3
votes
0answers
338 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 ...
3
votes
0answers
42 views

Fix for column names breaking the 64-character limit

I'm trying to generate a report using custom fields and I am getting nativecode=1166 ** Incorrect column name This happens when the report is trying to generate temp tables using an alias as the ...
3
votes
0answers
115 views

How to create a better report template that includes CiviDiscount codes?

We are working in civiCRM 4.6.4 with Drupal 7.50. Our goal is to have a report template where one can pull up a list of event participants (possibly for multiple events) who used a specific discount ...
3
votes
0answers
51 views

Contribution Report with total paid and balance fields?

Since partial payments were introduced in civicrm 4.5 is there any report available (core of extension) which allows to use "total paid" and "balance" as fields and filters?
3
votes
0answers
146 views

Recurring Membership Price Set payments don't show after first payment

We have three different membership types configured in a price-set along with an option to add additional contributions. When someone subscribes for membership, they subscribe to all three membership ...
3
votes
2answers
90 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.
2
votes
0answers
8 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 ...
2
votes
0answers
27 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. ...
2
votes
0answers
55 views

Some reports not showing in dashboard

As of version 5.6.0, some of our reports are no longer showing up in people's dashboards as a dashlet option. The reports have "Available for Dashboard" set and permissions seem right, I even set ...
2
votes
0answers
54 views

Activity report showing activities twice

All of my activity reports have recently changed to return two entries for the same activity. I have looked under sorting and columns and filters, but cannot seem to disable the double entries. Please ...
2
votes
0answers
22 views

Can activity tags be included in activity reports or exports?

tags have been added to a variety of activities by a user over the last few months. Now they want to include the tag details in a report. As far as I can see activity reports can filter by tag, but ...
2
votes
1answer
69 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, ...
2
votes
0answers
29 views

What Membership Payment Date should appear in membership reports?

I'm wondering if the following is expected behavior or a bug. When running a detailed Membership Report and selecting Date Received as one of the columns, I would expect to see the most recent payment ...
2
votes
1answer
38 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
0answers
28 views

Where does the “Mailing” data come from in the Mail Opened Report?

When we run the Mail Open Report and include the "Mailing" Field it does not return consistent data. We expected it to return the latest mailing opened but it does not and the title of the mailing is ...
2
votes
0answers
47 views

Smart groups and date checks

I am trying to create a smart group that always returns the list of contacts whose membership end date is the end of the previous year or earlier (these are lapsed members and we need to chase them ...
2
votes
0answers
46 views

How to exclude trashed contacts from CiviReports

I am just getting my feet wet with CiviReports using a basic CiviReport template to create a snapshot of our membership by categories. Simple enough, but the counts on almost each category were ...
2
votes
0answers
34 views

Membership Report errors

Running Civi 4.4 on Drupal 7.34. I have an organization with a LOT of membership types (they manage all their statewide chapters via a single install of Civi). There is a configuration in which four ...
2
votes
0answers
59 views

Need help with error in creating a dashboard report

Trying to track down this error: Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in civicrm/Civi/Core/Transaction/Manager.php on line ...
1
vote
1answer
14 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
0answers
19 views

No Drill Down extension not working for summary reports

WP 5.3 civi 5.19.3 php 7 no drill down 1.1.2 (downloaded from github) Love this extension & sad to lose it. It works fine for detail reports - goes to contact record, but in summary report goes ...
1
vote
0answers
30 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

How to embed 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
1answer
51 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 ...
1
vote
0answers
14 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
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
0answers
10 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 ...
1
vote
0answers
60 views

“Contribution Detail Report” issues in CiviCRM 5.8.1

The "Contribution Detail Report" template is not fetching the soft credits related data correctly in CiviCRM version 5.8.1. It is showing "Contribution" for all rows, even for Soft credits and the "...
1
vote
0answers
33 views

403 when I run most reports as super admin

I have a problem with my civiCRM installation where I am now unable to run most reports. As super admin I can browse to the report config page where I can select what I display and set filters etc. I ...
1
vote
0answers
18 views

Soft Credit report redirect to Contribution Detail report doesn't filter contact id

It looks like the names in the Soft Credit report no longer redirect to a Contribution Detail report that filters the results based on the contact's id. This lack of filter is verified on the demo ...
1
vote
0answers
23 views

Donation summary report (Repeat) gives error Incorrect integer value: 'text string' for column 'source' at row 1

Drupal 7, CiviCRM 4.7.27, using the standard report "Donation summary report (Repeat)", I'm getting an unexpected SQL error Incorrect integer value: 'my custom source string' for column 'source' at ...
1
vote
0answers
19 views

CiviReport - how do I return NULL values for Participant Report with Membership Details

I have created several custom reports for CiviReport. To create the SQL for these reports I have used 'Toad for MySQL' to visualise the proposed end-result. In my latest report I am trying to return ...
1
vote
0answers
33 views

Add tag and group names into standard report

I need to extend existing Summary and Details contact report with two columns. Filtering is already there, so I only want to see Tag(s) and Groups(s) to which particular contact is assigned. I've ...
1
vote
1answer
41 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 ...
1
vote
0answers
20 views

Could the email address at the time of a Bounce be frozen into the Mail Bounces report?

Mailing Reports > Mail Bounces (CiviCRM 4.7.9) If the email address of a contact is updated, earlier Mail Bounces show the updated address instead of the address when the bounce occurred. The address ...
1
vote
0answers
60 views

Civicrm profile field values using same record type goes missing/overwritten

I have created a CiviContribute profile with multiple postal code fields of record type contact. All these profile fields have different labels and sub-type. But when a user makes a contribution, only ...
1
vote
0answers
12 views

Testing email set up of reports

Contribution report set up to email weekly, I have added CC email adresses and need to check if this works now and not wait a week
1
vote
0answers
20 views

Images in Reports

Is it possible to get a report with a list of names and their profile image? I have looked at some of the report templates, but I can't find where you can choose an image.
1
vote
0answers
25 views

Bookkeeping report doesn't record check number for financial account/type

Every day we have to print off a report on the checks (their check numbers, name of payee, etc) we have received and their respective financial account credit codes. However, the bookkeeping report ...
1
vote
0answers
105 views

4.7 Upgrade issues: invalid value for State on import, country list reverts to US, contact reports produce warning on htmlspecialchars

Upgraded to 4.7 from 4.6.11 today. Importing contacts containing any value for State field results in an error for that field. Tried abbreviations and full values. Entering that info on a contact ...
1
vote
0answers
12 views

CiviReport - Localize “Constituent Detail” group header

I'm localizing (Italian) the reports. As in the object, the "Constituent Detail" group header (the ones with the blue background: RELATIONSHIP, CONTRIBUTION, PARTICIPANT, ..) are not sensible to ...
1
vote
0answers
42 views

How to see total net amount in membership report

For example, with the built in report "Contribution and Membership Details" it will total the contributions at the bottom. But this is not the net amount. How would we get the report totals at the ...
1
vote
0answers
96 views

Can custom fields be used in Filters for summary level reports?

I established a custom field (Anonymous) on the contribution object, which works well with the Contribution Detail report. I can use it to exclude anonymous contributions from that report, or to ...
1
vote
0answers
44 views

Add membership start and expire date in contact report

Is there a standard way to add membership start and expire date (filterable) in contact report summary page? I was trying to get into each row and run custom query to get corresponding data but doesn'...
1
vote
0answers
98 views

Activity Report does not allow grouping by custom fields

Using CiviCRM 4.6.4, I am trying to update the activity report to include the custom fields from the contact form. By using the following code they show up in the list but does not allow sorting on ...
0
votes
0answers
15 views

Report Plus: Issue with filtering campaigns

We've found an issue with Report Plus. The extension doesn't show the choosed campaign (via filters) in the results. So if we choose to filter for Campaign A, it shows another different campaign. This ...
0
votes
0answers
17 views

How to Add Sum Total to Report

I've got a custom integer field on event participants. I'm using an event participant listing report. I'd like to add a bottom row that gives me a sum total of that field for each event. It looks ...
0
votes
0answers
20 views

Saving a Civi Report- too many redirects error

I'm trying to save a contact summary report after amending filters. After each attempt to save I get a too many redirects error. I can see the new instances in the civicrm_report_instances table, ...
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. ...