Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

0
votes
2answers
13 views

Donors who gave the same amount in X and Y year

Is there a report in the Current version of CiviCRM that can tell us this? https://civicrm.org/extensions/advanced-fundraising-reports seems to have reports that will show if the giving is increased ...
1
vote
0answers
16 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 ...
1
vote
1answer
13 views

Getting an error trying to add contacts to a group from an activity report.

Getting this error when trying to add contacts to a group from a report. Table 'childpsy_civicrm.Array' doesn't exist It's this 'xxx_civicrm.Array' doesn't exist that puzzles me. I'm getting it on ...
0
votes
1answer
20 views

Wrong time in Mailing Report

as said in the title, the mailing report seems to have a wrong time...when I send a mailing to my private email adress at 4 pm and open it right away, the mailing report says I opened it 2 hours ago. ...
0
votes
0answers
24 views

Dashboard report updating not correct

For one of my clients I have added 4 contact reports on the CiviCRM Dashboard. They only show 3 results on the first page, and if you want to see more results, you can go to the next page of that ...
0
votes
1answer
8 views

Can ExtendedReports report on CiviDiscount usage?

Can I get a list of Contacts that have used a specific CiviDiscount code? How do I extend - Extended Reports extension?
0
votes
1answer
34 views

Custom fields of type text not displaying in filter tab of reports (CiviCRM for Drupal 5.5.1)

after upgrading CiviCRM 5.5.1 in the filters of all reports, custom fields (type text) are not visibile. They are only visible only select fields. In column tab are instead visibile. And they are ...
2
votes
1answer
26 views

event income reports

I'm not getting the results that I expect from the event income reports. I've used the "No-show" status for people who have paid but don't turn up to the event. However the report only seems to ...
0
votes
0answers
10 views

unserialize() error in report forms

I've just upgraded a test system running under Joomla to 5.5.0. Looking at certain reports gives this error: Notice: unserialize(): Error at offset 166 of 1907 bytes in ...\administrator\components\...
1
vote
1answer
18 views

Columns available for sorting in CiviReport seem arbitrary/random

I'm trying to run a contact report which sorts by Street Name, but it's not available as a sort option, and the list of options available seem abitrary and vary depending on the base report I use. ...
2
votes
1answer
30 views

BI/ Reporting Tool

Any recommendations on a Business Intelligence/ Reporting Tool? I have used Crystal Reports, IBM Cognos and Oracle Answers in my working life. I am now retired and helping a small community ...
0
votes
1answer
30 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/...
3
votes
1answer
32 views

Replace flash-based charts with something that doesn't use flash

Several core reports (as well as some reports provided via extensions) use the OpenFlashChart library to create nice looking charts via flash. Unfortunately (or fortunately depending on how you look ...
0
votes
1answer
13 views

Change Event Report fee level filter so operator offers 'contains' rather than 'is one of'

In the Participant Report there is a filter for Fee Level. The operator for this is either 'Is one of' or 'Is not one of'. Is it possible to provide users with the option to search with the operator:...
0
votes
1answer
27 views

CiviReport's and CiviContribute Charts not displaying

We are using civi 5.3 on Wordpress 4.9. Using CiviReports or CiviContribute, I am selecting Charts, and clicking the view button. The chart is not loading. I saw the other answers suggesting that I ...
3
votes
1answer
25 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.
1
vote
1answer
16 views

How do I set the margins on a PDF print out of a CiviReport?

How do I set the margins on a PDF print out of a CiviReport? Things I tried: Setting these in print.css on the body element. had no effect.
0
votes
1answer
28 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 ...
0
votes
1answer
24 views

Photos on the members profile

Can you please let me know how can I add photos on the member's profiles? I can not find it in the database.
2
votes
1answer
22 views

can CiviCRM reports be archived?

Is there any way to archive reports in CiviCRM so they are still available but no on the long list of reports?
3
votes
1answer
27 views

CiviReports issue with boolean fields

I recently noticed that boolean fields (Deceased, Do Not Email, Do Not SMS, etc) are all displayed as "Yes" on contact and membership reports, regardless of their actual values. The data itself is ...
1
vote
0answers
22 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 ...
2
votes
1answer
24 views

Parse error just appeared

Our volunteer group uses Civicrm. It runs under Drupal. We host with ..(cough cough) Godaddy. Recently their Cpanel automatically switched us from PHP 5.4 to 7 and our Civicrm 4.7.7 crashed with ...
2
votes
1answer
21 views

How do I pass custom field values in CiviReport urls?

For example, I have a membership report /civicrm/report/instance/103 and I want to filter to only show rows where the value of a custom field with id of 65 is 'abc'
1
vote
0answers
9 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 ...
0
votes
1answer
18 views

Extended Report - Line Item report for price sets final line concatenating all records

The Extended report Line Item report for price sets was working perfectly fine till recently. Now the last line is concatenating all first name and last names. See Screenshot
0
votes
1answer
12 views

How can I search for or report on contacts based on date, method and/or status of group subscription?

With GDPR coming down the track I'm keen to dig in to my contact lists in more detail. I'm looking the ability, ideally through the UI, of reporting on, and searching for, contacts based on the date ...
2
votes
1answer
31 views

OR operator in reports - How to draw a Participants report where A OR B?

How can I use the OR operator in a Participants report? I need a simple A OR B report, and I can only find how to do A AND B.
2
votes
2answers
24 views

Participant's Notes is not available in Reports

I use Civi 4.7.27 on Drupal. In the edit event registration dialog for a participant, there is a field for 'Notes' about this participant. How can one add this 'Notes' field in a participants report?...
1
vote
1answer
16 views

How to report on repeating custom fields

My client wants a report on a set of 10 repeating custom fields, each one of which has a date and one of a set of outcomes. e.g there is an 'Accommodation' custom field which has 2 fields - a date and ...
2
votes
1answer
28 views

Membership Details Report doubt about Grouping

In the Membership Detail Report there is the tab 'Grouping'. Is this tab really necessary? Every membership has an unique id so it doesn't seems logic to group by this field. I did some test in my ...
2
votes
1answer
15 views

How to add “Family Member Information” Columns to Event Attendee List report?

Is it possible to add Family Member Information columns to this screen? I run a youth program and it would be helpful to be able to pull emergency contact information when running the report. Very new ...
3
votes
2answers
55 views

How do you display custom Contact fields in Membership reports?

I have created some custom fields for Contacts and want to display these fields in a membership report that we call member mailing list. However I am unable to see the custom fields for Contacts as ...
1
vote
1answer
46 views

Illegal mix of collations

Using Joomla 3.8.6, CiviCRM 4.7.31, php 7.0.28, mysql 5.6.39 What should the database collation be for the CiviCRM tables? Mine are all utf8_general_ci. None of the tables in the database are ...
2
votes
1answer
21 views

Delete a Missing Case

I ran a Case Detail Report to see a list of cases because my Views table count was not adding up. I realized from this report that there is a case with an "Active" status that does not have a Contact ...
1
vote
0answers
18 views

CiviReport 'insufficient permission' error running financial report after update to 4.7.29

Only since upgrading CiviCRM to 4.7.29 from 4.7.11 (on Drupal), one of my users with 'editor' role is unable to run a financial report. The error she sees is: "API permission check failed for ...
2
votes
0answers
32 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 ...
1
vote
2answers
28 views

Particular report about contribution on CiviReport

Good morning, I'm writing to ask if it exist a particular report about contributes. I'd like to have a report which contain these columns: Surname/Name, amount and date of the last donation and total ...
0
votes
1answer
24 views

Can I make reports export the state/province abbreviation instead of full name?

Similar to this question, I'm interested in having my reports export states/provinces with the abbreviation instead of the full name. The accepted answer in that case was to use an Advanced Search ...
5
votes
1answer
92 views

CiviMail Reports is not tracking email opens

I am using civi 4.7.29 on Wordpress 4.9.4 I noticed that civimail reports is not tracking the email opens after multiple sends. It is just showing "0". In the screen shot, you can see where it is ...
1
vote
1answer
12 views

Contribution Reports and disabled Financial Types

What is the expected behaviour for Contribution Reports in regard to disabled Financial Types (for example, a Financial Type that was used some years ago but is not used for current contributions)? ...
0
votes
0answers
19 views

Membership report not matching find membership search for imported memberships

I am getting different results when doing "Find Membership" search vs. using the CRM_Report_Form_Member_Detail report. Upon searching the same criteria, we get 19 records via the report v. the total ...
3
votes
1answer
26 views

Using an excel membership number list to compile a civi report of linked addresses

I have a list of membership numbers of approx 80 people. I need to use these numbers (saved in an excel spreadsheet) to run a report in Civi which will pull all the addresses and names linked to those ...
0
votes
1answer
28 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 ...
2
votes
1answer
81 views

Connecting Power BI to Civi

Has anyone tried to connect Civi to Power BI? I'm considering using this platform for some more in depth analytics.
0
votes
0answers
10 views

Contribution Summary Report reports wrong total when filtering by aggregate or count

I'm just checking if this is a bug or a general issue with the report (seems like there are odd results for the totals depending on the filter in many cases). If you filter a contribution summary ...
1
vote
2answers
64 views

Can I link memberships to relationships automatically?

I'm using CiviCRM to manage sponsors of children in India for an NGO. I'm configured it and set up some custom fields in order to have the children(contact) connected to the membership. So far so ...
0
votes
0answers
6 views

How to see status of calling & who still needs to be called

We want to call all teenage volunteers to an event/function. We have a group called teenage volunteers. I envision either calling or email blast with follow up calls for those that did not respond or ...
0
votes
1answer
11 views

Create Report Showing The Notes Created for Organisations

I want to create a report that shows the most recent note that has been created for each organisation. When I looked at modifying one of the existing reports, I could not find in any of the reports, ...
1
vote
1answer
36 views

How to hide configuration tabs of a report with the “print to pdf” action remaining active?

I want a category of users can access some reports, view the results on the screen and print them to PDF. And to prevent any modification of the criteria, I want all the report configuration tabs to ...