Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
2
votes
1answer
26 views

How to delete a membership report

I have copied an existing report template for my own use with the intention to use it for my search options. I don't understand how I can name it as I wish. How to rename a report when copying? How ...
2
votes
1answer
40 views

Click to go to contact record from report [duplicate]

When i am viewing contacts in a civireport if i click on the persons contact name i am taken to the "view contact detail report" which is basically the Constituent Report (Detail). Is there a way to ...
1
vote
1answer
46 views

Can't get a list of people whose birthday in current month

We want to see a list of people who have birthday next month. Advanced search doesn't suit us because it is trying to do search only for a current year. We use SYSTOPIA Birthdays for generating ...
2
votes
1answer
64 views

CiviCRM report for Case activities listing Case data

I would like to generate an Activities report (eg upcoming scheduled activities) which includes case data (eg case ID, case Subject, case Role contacts, case custom fields) of the case to which each ...
2
votes
1answer
45 views

Reports show 4 warnings after upgrading from 5.4 to 5.10

I run Civi on Drupal. After upgrading from 5.4.0 to 5.10.0, any report I open shows 4 warnings at the top: Warning: Illegal string offset 'attr' in HTML_QuickForm_advmultiselect->toHtml() (line 807 ...
2
votes
1answer
30 views

Transaction Date in Extended Report

Using the "Bookkeeping with extra fields" template, I noticed I was occasionally missing some transactions whenever I filtered on Transaction Date. I believe the issue is caused by the filter using ...
2
votes
1answer
25 views

Inconsistencies in the Contribution Detail report

I'm trying to chase down an inconsistency someone reported in the Contribution Detail report. It doesn't happen with all contacts (in fact I've only seen it in the one they reported, so far). There ...
2
votes
2answers
41 views

Custom report: how can I add a filter for a dbAlias field?

In a custom report -> I've created a field 'civicrm_contribution' => array( 'dao' => 'CRM_Contribute_DAO_Contribution', 'fields' => array( ... 'amounts_ytd' => array( ...
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
3answers
39 views

Sort report by event role and/or status

In the sorting tab for event participation reports, I can't sort by role or status. Even those these are built-in fields that it seems obvious people would want sort by, are not in the list of columns-...
2
votes
1answer
16 views

How do I run a report for an event

How do I run a report on an event that includes things such as participant name, email and organisation they are from?
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 ...
3
votes
2answers
52 views

Extracting a report/pulling a search result to CSV but setting an exported flag to indicate this

I am looking for a way to mark data as exported in some way. The scenario is that we are receiving and capturing data for enquirers (people making enquiries) on behalf of a third party. The 3rd ...
2
votes
0answers
49 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 ...
5
votes
1answer
55 views

Why do click and open reports show times in UTC rather than the site's timezone?

The mailing and click tracking reports are showing times in UTC. There is no PHP MySQL timezone mismatch - and mysql -e 'select now()' and date return the right times - as per timezone.
2
votes
0answers
49 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
2answers
50 views

Report with Payment Processor [duplicate]

I'm trying to get a report with the name of the Payment Processor that was used for each online Payment. I'm not able to get this to work. Been though the API trying to track the data but not that ...
1
vote
1answer
33 views

Adding new grouping to a report

I'd like to add a new grouping option to an existing report. Is it possible to group by the payment instrument in the Contribution Summary Report? The option Payment Instrument is not showing up on ...
2
votes
1answer
12 views

CiviReport - Error when registering new Report

I've generated a new report in my extension, but when I try to register it with CiviReport, I'm getting the following DB error: Database Error Code: Field of view 'sporti62_wp4....
1
vote
2answers
16 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 ...
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
1answer
15 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 ...
1
vote
1answer
29 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
1answer
28 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
51 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
33 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
11 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
38 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
47 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
40 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/...
4
votes
1answer
51 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
18 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:...
1
vote
1answer
70 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
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.
1
vote
1answer
24 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
50 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
33 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
24 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
29 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
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 ...
2
votes
1answer
72 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 ...
3
votes
1answer
36 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
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 ...
0
votes
1answer
26 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
16 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
37 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
36 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
28 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
32 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
16 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 ...