Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

61 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
1answer
64 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.
3
votes
0answers
112 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
50 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
145 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 ...
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 ...
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. ...
2
votes
0answers
264 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 ...
2
votes
0answers
44 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
50 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
50 views

Cannot Export a Report to a CSV file

Since upgrading from CiviCRM 4.4.3 to CiviCRM 5.8.0 last week, I am unable to export my employee training reports to a CSV. The page simply refreshes and doesn't do anything. I have tried making a new ...
2
votes
0answers
21 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
0answers
38 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 ...
2
votes
1answer
61 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
27 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
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
0answers
27 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
45 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
33 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
58 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
19 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
19 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. ...
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
1answer
39 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
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
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
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 ...
1
vote
0answers
58 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
32 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
15 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
21 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
31 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
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 ...
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
56 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
104 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
41 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
43 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
97 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
11 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
12 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 ...
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, ...
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 ...