Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
1 vote
0 answers
9 views

Can I get ALL contact's emails in CiviCRM reports?

By default, CiviCRM Reports include only contact's Primary email. How can I create a report which includes all contact's emails? Alternatively, is there a way I can export ALL users with ALL emails? (...
user avatar
  • 1,002
1 vote
1 answer
23 views

In Contact reports, why are the contacts' names not linked to their records?

Using CiviCRM 5.48.2 with WordPress (current version). The other day I noticed that in my contact reports (e.g. Current Member List), the names are not linked to the person's record. The links are ...
user avatar
0 votes
0 answers
8 views

Mail Reports scheduled job - Mailing Error

The Mail reports scheduled job was working fine until recently. We've not run any upgrades or installed any extensions for a few months now. Upon running the job manually, we get these errors: The ...
user avatar
  • 695
1 vote
3 answers
31 views

How can I include two types of contribution in a single report

I have Contacts with 2 types of Contributions. A) Contribution with CONTRIBUTION SOURCE = keyword B) Contribution with CONTRIBUTION NOTE = keyword How can I include both types of CONTRIBUTIONS in a ...
user avatar
  • 1,002
1 vote
1 answer
28 views

How do I create a report that displays Contacts created in the last (say) 30 days?

This question was asked in October 2020. The answer was to use Drupal or Data Processor. We're using WordPress and we don't have the expertise to use Data Porcessor. Have there been any work-arounds ...
user avatar
0 votes
1 answer
24 views

Events Summary Report

I am trying to run a report of all Events with a start date in the current week, which would show title, start date, and ideally number of participants registered. The nearest I can get is the Income ...
user avatar
0 votes
0 answers
8 views

Event Report with Separate Columns for Each Fee Level

I have an event with a complex price set which allows users to register for various seminars. Because users make multiple selections, their registration includes a separate fee type for each seminar. ...
user avatar
  • 1
0 votes
0 answers
9 views

Can I add (contribution) last activity date to a membership report

I run an activity report in order to find new memberships/renewals lodged in the last week. It would help to include last activity date in a membership report to remove one step in the process
user avatar
0 votes
0 answers
23 views

Volunteer Reports Totals Wrong

For each volunteer report run, the Total Time sums in table at the bottom are wrong. Row(s) Listed x Total Time Scheduled in Minutes xxx Total Time Completed in Minutes xxx No matter how sorted or ...
user avatar
0 votes
0 answers
12 views

Is there a report like mail summary that shows total clicks?

Mail Summary report shows all the fields I want except for total clicks, is there an extension or another report that can give me that information without having to grab it from the Delivery Summary. ...
user avatar
  • 3,252
0 votes
0 answers
8 views

How can I add the petition type code into the campaign reports? The report checks for (28, 29, 30, 31) but does not include 32 (petition)

I have created a petition and gathered detailed info but there are no reports to support the results. Can I add type 32 to the campaign types without creating a whole custom report ?
user avatar
1 vote
1 answer
14 views

How can I get a report to show when contacts were added to a Group?

I have a profile that assigns contacts to a Group so I can later identify those contacts for reporting purposes. However, I'd really like to get a report includes the date that they were added to the ...
user avatar
  • 455
0 votes
1 answer
23 views

Why is the Sorting tab missing from CiviReport?

What configuration is required in order to display the "Sorting" tab in CiviReports? Is there a plugin for a Wordpress-based install to allow for column-based sorting?
user avatar
  • 355
0 votes
1 answer
24 views

Mailing reports with AWS

If you use AWS and try mailing a report to multiple emails it fails with: Mailing Error Failed to send data [SMTP: Invalid response code received from SMTP server while sending email. This is often ...
user avatar
  • 2,864
2 votes
1 answer
14 views

How to include Partner Information in CiviReports

We have created a new (Pickleball) Tournament Event in Civi with On-Line Registration. As part of the registration, Partner Information (partner's name) can be entered for Men's Doubles Partner, ...
user avatar
2 votes
1 answer
38 views

How to get "Last contribution amount" and "Last contribution date" into report?

I'm needing a way to add 2 columns to contribution summary report, 1 for displaying "last contribution date" and 1 for "last contribution amount" in a CiviReport. Is there an easy ...
user avatar
  • 355
1 vote
2 answers
35 views

Scheduled Job -- Mail report - cannot find InstanceID

Set up schedule job for mail reports. the following error is in the log: Finished execution of Mail Reports with result: Failure, Error message: Report Mail Triggered... Required parameter missing: ...
user avatar
  • 1,139
1 vote
3 answers
73 views

How can I report on how many new contacts have been entered into Civi within a specific period?

I tried: menu Search -> Find Contacts / is - any contact type / - -> replace by the contact type you want to count (member is our subtype, but we do not have the membership module enabled, it's ...
user avatar
  • 15
0 votes
0 answers
19 views

Contribution report not accurate for 2 or more patrons with same last name

Our contact name listing is first name last name, so to get an alphabetical report we created a custom field “Patron Last Name”. We have patrons with the same last name (e.g., Jim Smith, Jane Smith). ...
user avatar
1 vote
1 answer
41 views

Can you Make a Report, that provides the Number of Employees (relationships) for every Employer?

The report would simply be a listing of employers and the number of employees or current relationships that employer has. Employer # of Employees Apple 2456 Google 3845 CiviCRM 4 Taco Bell 5500 ...
user avatar
  • 3,252
0 votes
1 answer
7 views

Receiving errors when running reports. "Sorry but we are not able to provide this at the moment."

Drupal 7.41 CiviCRM 4.6.6 We are using an older version of CiviCRM and are randomly starting to get "Sorry but we are not able to provide this at the moment." when running certain reports. I ...
user avatar
  • 123
0 votes
0 answers
14 views

How do I hide specific reports?

How do I hide reports that we aren't using or under development? I've taken a look at editing menus and permissions.
user avatar
0 votes
1 answer
34 views

Generating letters in Docx generates empty letters

Generating letters in Docx generates empty letters and with office 365 images are oversized even if image size is locked
user avatar
1 vote
0 answers
26 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 ...
user avatar
  • 3,252
1 vote
3 answers
60 views

Does CiviReport have a concept of "Group By"?

My org wants to know which countries were represented at an event. A simple way to do this is to "group by" country. Does CiviReport have a concept of grouping by a column?
user avatar
  • 355
0 votes
0 answers
24 views

Date Range Filters in Membership Reports

Under Membership Reports, if you go to the filters tab and try to select a date from the Date Range feature, the calendar is greyed out and there is no year field next to the month. I am attaching a ...
user avatar
  • 93
4 votes
1 answer
57 views

SearchKit vs CiviReport vs Jasper: Best reporting tool to integrate into Civi?

it's been a while since I've reviewed all the BI reporting options available to us, and I'd love to get feedback on what people are using these days. For years now, I've combined any Civi install with ...
user avatar
  • 753
0 votes
0 answers
11 views

Is there a way to tag contacts when report is sent?

When a report is sent, can I automatically add a tag to the contacts that are in the report? This report concerns a group of contacts that are in a smart group and after the e-mail is sent, I'll love ...
user avatar
0 votes
1 answer
20 views

Exporting CiviCampaign Walk Lists without Reserving Respondents

I'm using CiviCRM for political campaigns and the process of reserving respondents is a major pain point for my clients. Most of the time you never know who or how many people will show up to knock ...
user avatar
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?
user avatar
2 votes
0 answers
18 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 ...
user avatar
3 votes
1 answer
33 views

Give anonymous users access to a report's contents?

I want to make a CiviReport accessible to anonymous users. I can set the report's "Access" to allow anonymous users, but I want them to see the results of the page without giving them the ...
user avatar
0 votes
1 answer
13 views

Member reports javascript broken after update

Somewhere between 5.15 and 5.36, javascript starts breaking on all member reports. In the html body, javascript is searching for $originalElement = $dateElement.siblings('#membership_join_date_from')....
user avatar
  • 1,147
2 votes
2 answers
45 views

Using 'Date Deceased' in CiviReport

I'm attempting to create a basic Contact Summary CiviReport: A list of deceased contacts sorted by Date Deceased. The field 'Date Deceased' from the Contact Summary doesn't appear to be an available ...
user avatar
1 vote
0 answers
29 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, ...
user avatar
1 vote
1 answer
31 views

Case reports only work properly for originating user - bug or as designed (or both)?

A user has reported that doing an 'Export to CSV' from a case report works OK when she does it, but doesn't work for a user 'B' - even though user 'B' has the correct access (we're using ACLs). ...
user avatar
  • 4,254
0 votes
1 answer
13 views

Can I move a report from Contact Reports to My Reports?

I have 5 reports in Contact Reports which I meant to have in My Reports. Is there a way to move these to My Reports?
user avatar
  • 111
1 vote
1 answer
32 views

How to make a daily bithday report at morning?

Every day a person receives a list of who has a birthday on that day. But this happend at evening, when it useless, How to make it at morning?
user avatar
0 votes
0 answers
23 views

Database error "Unknown field" when trying to add contacts to a group from a report

Created a report with some custom fields in it. The report show up correctly with the custom field used When I click on "Add Contacts to Group" and choose a group I see a blank page stating ...
user avatar
1 vote
0 answers
16 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 ...
user avatar
2 votes
1 answer
13 views

Where is the privacy filters located in report templates?

By default all privacy filters i.e. do not email, do not mail, etc is loaded in the report, except for do not trade. Where in the report (contribution details )template this filters are located? How ...
user avatar
  • 2,836
1 vote
1 answer
22 views

How do I add a column to a Contribution Summary report which will show the date and amount of the most recent payment/donation?

When running a payment report using the Contribution summary, along with the columns showing number of payments, payment aggregate and payment average, I would like to be able to see the date and ...
user avatar
2 votes
1 answer
72 views

My mail_report: Finished execution of Mail Reports with result: Failure, Error message: is not of type String

I'm running civiCRM 5.30.0 on Drupal 7. I've designed a report to be sent weekly. To test it, I manually ran mail_report and got the detail below. Where is type STRING required? Parameters raw (from ...
user avatar
  • 111
0 votes
1 answer
23 views

Display nth payment of a recurring series?

Is there any way to display "nth Payment" of a recurring series? I am looking for a way to display with a contribution and/or line item result that this is the 3rd, 4th, 5th payment in the ...
user avatar
  • 2,252
0 votes
1 answer
12 views

How can I adjust the date widget on Reports

The birth date widget on Reports such as the Constituent Detail seems hard coded to allow only dates within the last 20 years. How do I adjust this?
user avatar
1 vote
1 answer
22 views

How can I run a report with Pending (Incomplete Transaction)?

Essentially I want the contribution detail report but to filter Contribution Status: Pending, Is Pay Later: No (I know I can do this with search) I can do this with some extensions, but they do not ...
user avatar
  • 3,252
1 vote
0 answers
36 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 ...
user avatar
1 vote
1 answer
11 views

report to show all my outstanding activity

I want to be able to pull a report that shows all the activity that i have recorded, for scheduled, completed and ongoing. How do i do this please?
user avatar
1 vote
0 answers
24 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 #...
user avatar
  • 3,252
0 votes
1 answer
36 views

Membership Expiration Date Report Filter is Ignored

In CiviCRM membership reports, the Membership Expiration Date filter is ignored, and all records are returned no matter what parameters you try. We started experiencing this around CiviCRM 5.11. We ...
user avatar
  • 177

1
2 3 4 5
9