Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

67 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
364 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
43 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
118 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
54 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
97 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
28 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
58 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
27 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
31 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
0answers
18 views

Problem with civiReport/Activity Summary

When I run an Activity Summary Report I get a 'Count' for each 'Activity Type' by Status. My issue is that when I click on that count I get a syntax error report. Should I not be able to see the ...
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
31 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
58 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
1answer
44 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
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
0answers
108 views

How to add a sorting column in Reports

I have a report that I would like sorted by County but that field doesn't appear as a sortable column, although it does appear on the report. This field is in fact 'State/Province' but is renamed via ...
1
vote
1answer
42 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
26 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
106 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
46 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
97 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
1answer
7 views

Membership Expiration Date Report Filter is Ignored

In CiviCRM membership reports, the Membership Expiration Date filter is ignored, and all records are returned no matter what parameters you try. We started experiencing this around CiviCRM 5.11. We ...
0
votes
0answers
5 views

How can I generate a report that shows list of recurring payment of different types?

I need to generate a report that shows a list of donors who gave above £10 as recurring basis in September 2020. They may have been giving previously or just started in September. The payment comes ...
0
votes
0answers
9 views

Can't see Soft Credit fields on a Contribution Detail Report?

When I add Soft Credit columns to a Contribution Detail Report, the data doesn't show - they're just empty cells: