Skip to main content

Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

94 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
27 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/...
nancy sorkow's user avatar
3 votes
0 answers
435 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 ...
Stephen Palmstrom's user avatar
3 votes
0 answers
111 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 ...
Eli Stone's user avatar
  • 131
3 votes
0 answers
145 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 ...
Eli Lisseck's user avatar
  • 1,499
3 votes
0 answers
58 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?
Richard van Oosterhout's user avatar
3 votes
0 answers
158 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 ...
dudeval's user avatar
  • 83
3 votes
2 answers
127 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.
Joseph J Zefran's user avatar
2 votes
0 answers
29 views

Portrait vs. landscape format of Civireport

I'm a bit baffled by this - all of our civireports are coming out in Landscape format when printed to PDF, even though the Print Page (PDF) Formats setting is Portrait. I tried this with wkhtmltopdf ...
twowheeler's user avatar
2 votes
0 answers
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 ...
Julie-ann Pina's user avatar
2 votes
0 answers
36 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. ...
Scott Pulver's user avatar
2 votes
0 answers
71 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 ...
Paul B's user avatar
  • 827
2 votes
0 answers
65 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 ...
user4464's user avatar
2 votes
0 answers
57 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 ...
Craig Almond's user avatar
  • 2,037
2 votes
1 answer
103 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, ...
Rose Lanigan's user avatar
  • 1,050
2 votes
0 answers
33 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 ...
LMK Web's user avatar
  • 571
2 votes
1 answer
44 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 ...
liblogger's user avatar
  • 1,004
2 votes
0 answers
33 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 ...
Caroline's user avatar
2 votes
0 answers
49 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 ...
David Christie's user avatar
2 votes
0 answers
22 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.
Rachel's user avatar
  • 405
2 votes
0 answers
51 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 ...
de Oldphart's user avatar
2 votes
0 answers
41 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 ...
Paul Beakley's user avatar
2 votes
0 answers
62 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 ...
Dan's user avatar
  • 21
1 vote
1 answer
13 views

Adding Contacts to Group from an Activity Report doesn't work on Joomla! 4?

I see the possibility of adding contacts to a group from an activity report. After posting the list, I select the group from the drop-down menu on the right, I have to confirm by clicking Next and ...
Alain Rihs's user avatar
1 vote
2 answers
30 views

Gift Aid - help needed

I am very behind with GA claims, partly because I find it so difficult to remember how to generate the report I need out of Civi. I don't get on with extensions - I don't have the technical ability - ...
Sally-Ann Delf's user avatar
1 vote
0 answers
14 views

Grid lines on printed reports

Until recently when using the Print Report action from a report template, the generated report would include dark gridlines separating the rows and columns, but now the gridlines no longer appear. Is ...
John Moore's user avatar
1 vote
2 answers
46 views

How to add Contact and Case custom fields to an Activity report?

Awhile back, I have made a copy of the the CRM/Report/Form/Activity.php, placed it under custom_php and added additional custom Contact and Case fields to the report by updating protected $...
Charlotta Beavers's user avatar
1 vote
0 answers
22 views

Volunteer Report DB Error: unknown error

When trying to have a volunteer report there is this error in WP+CiviCRM The error logs are: From logviewer [debug] $backTrace = #0 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm/CRM/Core/Error....
Alberto Olivucci's user avatar
1 vote
0 answers
15 views

Is there a Mailing Report that Groups Link Click Counts

I want to be able to create a report that shows the most clicked links for emails of a certain campaign over a period of time. As simple as URL, Unique Clicks, Clicks I know I can do that on a per ...
themak's user avatar
  • 3,441
1 vote
0 answers
11 views

Contact Report - Constituency Summary

I unintentionally deleted the Constituency Summary. I created a new one but the contacts are all grey out and I can't select them. HELP PLEASE
Howard Shore's user avatar
1 vote
0 answers
33 views

Possible to build contribution report that groups contributions by employer and includes number of employees?

I would love to be able to make a report in Civi using stock reports, extended reports or reports pro that produces or can be modified to generage the following output: Employer # of Employees # of ...
themak's user avatar
  • 3,441
1 vote
0 answers
8 views

how to send a civireport based on condition?

I'm using CiviReport to get a list of specific contacts from a smart group. Is there a way to trigger this Report only when the smart group is not empty?
Guillaume Sorel's user avatar
1 vote
0 answers
30 views

After update CiviCRM Birthday reports stopped working

Before reports came every day with a list of people who have a birthday today, we updated CiviCRM to version 5.35.1 and reports stopped coming, even in CiviCRM it does not give a list with birthdays, ...
Martin Abramov's user avatar
1 vote
0 answers
17 views

Membership data

Recently tried to pull a membership report & the reports keep turning up zero info. Looking at the contacts, and specifically looking up members, it appears that their member box is suddenly ...
Meagan Goold's user avatar
1 vote
0 answers
68 views

Help to analyse Civi Data. Counting activities and contacts when the field has more than one option

I have a query about analysing data from activities and contacts in Civi. I've tried to be very clear about what is being done and what has been tried, it's not a simple question so thankyou to anyone ...
Chloe Parker's user avatar
1 vote
0 answers
25 views

How do I troubleshoot a CiviMail / Mail report?

I have a mail report that we use on our dashboard that is just taking forever to load. Using developer tools, I can't seem to figure it out. [DOM] Found 2 elements with non-unique id #...
themak's user avatar
  • 3,441
1 vote
0 answers
22 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 ...
Alison's user avatar
  • 11
1 vote
0 answers
20 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 ...
LesleyJill's user avatar
1 vote
0 answers
39 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" ...
MarkDQ's user avatar
  • 493
1 vote
1 answer
86 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 ...
Vikas BN's user avatar
  • 113
1 vote
0 answers
17 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....
Hugo C's user avatar
  • 43
1 vote
0 answers
40 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 ...
A. Block's user avatar
  • 555
1 vote
0 answers
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 ...
Julie Velghe's user avatar
1 vote
0 answers
66 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 "...
Vikas BN's user avatar
  • 113
1 vote
1 answer
60 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/...
LesleyJill's user avatar
1 vote
0 answers
38 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 ...
Josh's user avatar
  • 77
1 vote
0 answers
35 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 ...
J. Rolfs's user avatar
  • 381
1 vote
0 answers
25 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 ...
Alan Dixon's user avatar
  • 6,861
1 vote
0 answers
23 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 ...
Mark Carson's user avatar
1 vote
0 answers
35 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 ...
Zglanowany's user avatar
1 vote
0 answers
140 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 ...
Andy Clark's user avatar
  • 4,845