Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
1
vote
1answer
51 views

Civicrm Reporting

In Civicrm in Contact reports I used the template called Relationships. Our data is as follows: We have Household Members, those members reside in a Residential Community(in our cases Caravan Parks ...
2
votes
1answer
42 views

Is there a report that will group by source of contact?

We have stared to use the contact source field to designate how our contacts get into CiviCRM. (event, membership, donation, helpline call etc. I would like to be able to have a report that lets me ...
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
3answers
65 views

Recording/ tracking time spent on Events

One of the activities of our organization is providing workshops etc. to the public. In order to facilitate all processes involved I have setup a coupe of events in CiviCRM. Each event represents a ...
3
votes
1answer
99 views

How to extend Database Log Report from Contact

I would like to extend standard functionality of Database Log Report generated from contact. For now there is list of standard colums, but there is no information about what changes was made in ...
1
vote
1answer
26 views

Report with filter 'yesterday' produces no result

When I create a report of contributions I can select a filter on 'Receive Date' of yesterday and any transactions with yesterday's Receive Date will be displayed. If I select a filter on 'Transaction ...
2
votes
1answer
30 views

Addresses not showing in walklist

I tried following this guide: https://book.civicrm.org/user/current/civic-engagement/everyday-tasks/ And created my surveys and reserved respondents but for some reason when we generate the report it ...
0
votes
1answer
19 views

Clearing A Report - Contribution Summary

I clicked on 'Contribution Details' report and it had a general list of names from my last time playing with it. I clicked on a specific name I wanted to do a report for and tweaked the settings to me ...
1
vote
1answer
32 views

CiviReport - Can Report Titles be sorted?

I've created about 20 reports under Event Reports but Civi seems to sort the report titles in order of creation. Is there way to have the report titles sorted alphabetically?
1
vote
1answer
35 views

Advanced Search gives different dataset than same search in Reports

When I use the Advanced Search or Search Builder to select a dataset the returned contacts are correct. If I do the same search using in CiviReport with the same search criteria one contact is ...
1
vote
1answer
13 views

CiviReports filtering on email adress

I want to display a report of all my contacts with a certain email adress ending, like "@gmail.com". I find many reports that display email adress as the result, but I fail to find any report that ...
1
vote
2answers
67 views

How to get name of Financial Type ID?

I am adding some custom code to the Bookkeeping Report so that each Financial Type's sub total is added to the bottom in the statistics. I have successfully done so, but I can't figure out how to list ...
0
votes
1answer
24 views

Is there a way to create a new group from report results (instead of adding to an existing group)?

I see that I can "add contacts to a group" from report results, but what if I need a new empty group? Is there a way to create a brand new group right from the report preview?
1
vote
1answer
123 views

Tags in contact reports

Using Civi 4.74 combined with Joomla 3.5 WE're looking to include tags in our contact reports but there's no obvious way to do so. What are we missing?
3
votes
2answers
77 views

Differences in results between 'Find Cases' and a 'Case Report'

Using 4.6.10 currently, although aiming to update shortly, I've created a case summary report from the template that simply lists all cases that are either 'ongoing' or 'urgent'. This lists 10 cases. ...
2
votes
2answers
102 views

does CiviCRM have the capability to handle approx. 70 pieces of data per customer?

I am a contractor working for the Department of Tourism in Vanuatu and we are looking at purchasing CiviCRM. We are also in the process of developing our first ever comprehensive survey for the 1,000 ...
1
vote
2answers
53 views

How to have a Detailed Membership Report filtered/sorted by pertaining Organization

I have several Organizations I need a Report which displays the following columns : Organization, Membership Type, Member (first and last name), email, Phone, Status I would like this Report sorted ...
1
vote
2answers
41 views

Total Donations By Contact

I am looking to pull a report that has the donation total for each contact. Basically the top donor report but for all donors. What report will give this to me. Thanks, Josh
2
votes
1answer
14 views

What setting is this asking me to change?

I created what I thought was a simple custom report and am receiving the the following error message. I can get to the file, and normally I can stumble through deciphering what Civi is trying to tell ...
1
vote
1answer
42 views

Event Reporting

I am trying to create an Event Report using the Event Summary template. What I need is a summary based on the fee level. I see the fee label, but not the fee level. Is there any report out there using ...
2
votes
2answers
117 views

Which SMS Gateway / Service providers are available?

We are an NGO that would like to use SMS to send out reminders for events and feedback tool. Which providers are supported by CiviCRM?
2
votes
2answers
80 views

Extended Reports Bug?

I have recently installed the Extended Reports Extension within civiCRM. However, I am noticing some strange behavior when I attempt to make a template. Within the Bookkeeping with extra fields ...
1
vote
1answer
35 views

how do I exclude blank or null in a report

I'm currently trying to set up a simple report for bookkeeping transactions for the last month. It's was great except for the fact it is also including paypal fees on top of the full transaction ...
1
vote
2answers
165 views

Coding Custom Report

I'm having some trouble coding a custom report. I found the following tutorial which was helpful, but I'm having trouble with the actual coding as I am still new to civiCRM developing, and I haven't ...
2
votes
1answer
39 views

Change Column Name in a report

Where would I go to change a column name in a report? I need an event summary report. There are 2 columns that list out the Registered/Attended/Pending etc. Those column names are very long and I ...
2
votes
1answer
18 views

Need to make a group of members who have been members for 5 consecutive years

People who have paid member dues for 5 consecutive years get a discount. We do not have rolling membership. jan 1 to dec 31 with a grace period of 6 months. I think that due to how the info was ...
0
votes
3answers
70 views

How to create a new report

I need to create a new report, an italian postal bulletin for donation or subscription, as in the below image. Do you have any suggestions on where to start? I mean: I must create an extensions? ...
1
vote
1answer
33 views

How can we add Batch information to the Bookkeeping report?

Batch name/title information does not show up in the columns available to the Bookkeeping report. Is there a way to add this? As an alternative, we would also be open to creating a new bookkeeping "...
2
votes
0answers
45 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
2answers
27 views

Symbunt Report: I need Advanced time period option

I want to track who has donated to our non-profit through a time period (2010-2013) but want to exclude donors who have given since 2014-present.
1
vote
2answers
124 views

Fatal error when including certain custom fields in Activity Report

I noticed that a couple of our reports had broken after the update to 4.7 (on Drupal), and trying to recreate the reports brings up the same error, with a message saying 'DB Error: no such field' ...
2
votes
1answer
85 views

Selecting location type or multiple email/phone fields in Reports

Is it possible to select a location type for default contact reports, or is it just hard-coded to use the Primary address/email/phone? Also, would it be possible to list a report with multiple email ...
1
vote
0answers
24 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
1answer
33 views

Tracking/Reporting Invitees vs Attendees (CiviEvent)

We want to find an easy way to track how many people from our invitee list actually signed up for or donated to our event. I was planning on putting all invitees into a 'group', and then tracking RSVP'...
1
vote
1answer
274 views

DB Error: no such field Fatal error: Uncaught CRM_Core_Exception: When Creating Reports

I get the following error when trying to create new reports or edit existing ones. DB Error: no such field Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to ...
1
vote
1answer
56 views

Error Running Contributions Summary Report

When trying to run the Contributions Summary report I get the following message: DateTime::__construct(): Failed to parse time string (2010401) at position 6 (1): Unexpected character Tried ...
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 ...
2
votes
1answer
91 views

How do I configure printing to format properly?

We have a WordPress install that has never had the report printing formatted properly. A report list does not have columns and rows with lines around cells. Attached is an example from my system and ...
2
votes
3answers
83 views

CiviReport: Cannot remove Contact ID filter

Suddenly a filter on Contact ID is unexpectedly appeared on my "Constituent Detail" report. Since Contact ID is not one of the fields enabled for filtering, I cannot remove it. So, every time I want ...
3
votes
2answers
54 views

Can I report data from a disabled custom field or option?

I'd like to disable some custom field fields, because we no longer want users to enter that data. But then I can no longer see the field in report filters. Is there another way I can get that data out ...
0
votes
1answer
65 views

Advance search result does not match with the member report

There is a problem with the Civi Reports. The report feature is not pulling all of the members in each of the categories, when we generate one member report and also generate the same report with the ...
2
votes
1answer
60 views

How do I restore a default report template?

Using WP and current CiviCRM. We changed a default Report Template. Is there a way to restore a default report template?
2
votes
2answers
55 views

How to print reports with non-English characters like accents?

We have instances of CiviCRM in Spanish and Catalan. When we try to print some reports the Spanish and Catalan specific characters (accents, umlauts, etc.) are printed with a wrong charset. E.g. It ...
1
vote
1answer
155 views

403 - Forbidden Error on Dashboard Modules

We suddenly started receiving a "403 - Forbidden Error" on the dashboard modules. This is not an issue itself, however, at the same time the gridlines on the PDF reports have disappeared. Are these ...
1
vote
1answer
39 views

REPORTS-Participant List 4.6.10

I edited the report for our needs, which is a primarily a list of attendees. We only require the following for our reporting needs: Name Organization Event Status Start Date End Date I cannot get ...
1
vote
1answer
252 views

How to get a participant list of multiple events ordered by event name

I want to get a list of participants of multiple events ordered by event name (primary) and participant name (secondary) but I don't know how to accomplish this with CiviReport. The result should look ...
6
votes
4answers
177 views

How to search active relationships (e.g) during past year?

We record volunteer relationships for our Volunteer contacts. A contact is an active Volunteer of our organization if exists a relationship "volunteer for" and this relationship has no an "end date". ...
5
votes
1answer
51 views

Report or export in xml format

I work for a small nonprofit. Our funding body previously required reports in csv format. they now want them in xml. Of course they are not providing any funds! Can this be done via a custom report or ...
2
votes
1answer
38 views

Customize Bookkeeping Transactions Report: Print custom field option value instead of name/label

I am using custom fields to store additional (cost accounting) data for contributions. Using the bookkeeping transactions report, I am able to export the data. However, when we are trying to import ...