Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
0
votes
1answer
104 views

Can a Scheduled Job using mail_report send Reports as HTML in the e-mail body, rather than as a PDF attached to the e-mail?

We're on CiviCRM 4.6.19 and Drupal 7.50 . I'm having problems with six daily Scheduled Jobs to send reports using Job and mail_report and instanceId=x. Three of the reports get sent successfully, ...
0
votes
2answers
41 views

Custom mailing report

I am using civicrm 4.7.7 on Drupal 7. How can I create a report of all mailings sent with CiviMail reporting the data of contacts that opened/clicked/replied the mailing? Thanks in advance
0
votes
2answers
19 views

Renamed Contact type does not show on reports

I have changed the built in contact type from Individual to Member. This shows on the contact screen as Member but in the contact reports it still shows Individual. tried to create a new type but it ...
0
votes
1answer
60 views

Create new report from template is not working (CiviCRM 4.6.5)

When you go to /civicrm/report/template/list?reset=1 and for example choose this contact report template /civicrm/report/contact/summary?reset=1 ..and click on the button 'Create report' Then a popup ...
0
votes
1answer
9 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?
0
votes
1answer
40 views

My custom reports work fine, but mail_report fails

All of my custom report mail_report jobs give this error, both through cron and when triggered manually: "Did not find valid instance to execute" The report is defined as class com_foo_bar ...
0
votes
1answer
62 views

Searchable Custom Field doesn't appear in Quicksearch options list and is not a sort option in reports

I have 2 membership custom fields that are set as searchable. One field is integer the other is alphanumeric. Neither field appears in the Quicksearch options in Search Preferences. The custom fields ...
0
votes
1answer
22 views

CiviCRM Recurring Contributions Report with Campaign

I'm trying to find a way to get a report on all the Recurring Contributions and what campaign they are attached too. Has anyone else done this? The Recurring Contributions report can give me the ...
0
votes
1answer
48 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
19 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
57 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
46 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 ...
0
votes
1answer
38 views

Getting Error in running contact Report

I am using Hostgator shared hosting for CIVI CRM and Drupal.From few days, I am getting an error that Error writing file '/var/mysqltmp/MYCckA2E' (Errcode: 28)". I tried to change the queries and ...
0
votes
2answers
33 views

How can I export an Event Income Detail report to CSV/Excel?

We find the Event Income Detail report to be useful. But the Actions menu won't let me export this report into a CSV file for some reason. How can that be enabled?
0
votes
1answer
19 views

Report with calling form

A user handed me a printed sheet from a previous database and asked me to recreate it. It contains contact information, a list of contributions, the most recent memo, and several blanks to be filled ...
0
votes
1answer
48 views

how to automatically creates a relationship

Is there a way to automatically create a relationship if 2 or more address in the DB is exactly the same? I want to create the relationship if two or more people are living in same house.
0
votes
1answer
55 views

Civi Reporting - where's the preview tab?

I am building activity reports and the preview tab is missing from the top , likewise I am unable to access the report title tab. is this something that can be added in , if so, how ? thanks in ...
0
votes
1answer
27 views

Ordering Contact Reports

Is it possible to set a specific order for all contact reports? Can they be grouped underneath certain headings making them easier to find? If so, how can I do this?
0
votes
4answers
39 views

Getting counts of donors grouped into categories by giving amount

Let's say I have these groups of donors: Small donor, gave < $100 in the past year. Medium donor, gave $100-500 in the past year. Major donor, gave > $500 in the past year. What's the best way to ...
0
votes
1answer
187 views

CiviCRM 4.7.15 reports keep giving DB Error: syntax error

The site was moved to a different server and updated from a 4.2.7 version to 4.7.15 and everything seemed to be working but every report we try to open just keeps giving this error: https://www....
0
votes
3answers
102 views

How to remove 'view' link in reports?

Can't seem to find an answer. Exporting PDF and Print reports for event check-in sheet at the front door. Want to either remove the link or the default Last/First name column to stop the 'view' link ...
0
votes
1answer
45 views

Update Reports not available after Upgrade to 4.7.10

After Upgrading to 4.7.10 from 4.7.8, it looks like the Reports have lost some of their features. The buttons for Preview Report, Update Report Save as Copy at are not displayed anymore. Here is the ...
0
votes
1answer
49 views

Report Preview PDF not working in 4.7.6

We are finding that a membership report and Preview PDF often goes to a page not found error. It seems to depend on the fields selected -- the fewer fields then better chance of getting a PDF to ...
0
votes
1answer
20 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 ...
0
votes
1answer
25 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?
0
votes
3answers
89 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? ...
0
votes
1answer
68 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 ...
0
votes
1answer
142 views

Event Report Template - Adding Sorting By/Group

How does one add "Organization" as a field to the sort list in the event report template? I have found how to add custom fields but not system default fields. Version 4.6.8 Joomla
0
votes
1answer
35 views

Joomla Report Result - Blank Screen

I've created multiple custom reports. On several of them, the results are a blank, white screen; no results and no errors. Any idea what might be causing this? I checked my site logs, but there are no ...
0
votes
2answers
105 views

How do I Add Contacts to Group from an Activity Report?

There is a choice in Activity Reports to Add Contacts to Group, on the top right - so I created a new Group and chose that Group, but there is not a button to click to complete the add. It's not ...
0
votes
0answers
11 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 ...
0
votes
0answers
6 views

How to get a combined report of household and individuals?

CiviCRM 5.32.2 Drupal 7 What I need is a combined report that shows aggregated amount for every contact of the database. Criteria: Show individual contributor. But If some contacts are part of ...
0
votes
1answer
20 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 ...
0
votes
0answers
5 views

How can I generate a report that shows list of recurring payment of different types?

I need to generate a report that shows a list of donors who gave above £10 as recurring basis in September 2020. They may have been giving previously or just started in September. The payment comes ...
0
votes
0answers
10 views

Can't see Soft Credit fields on a Contribution Detail Report?

When I add Soft Credit columns to a Contribution Detail Report, the data doesn't show - they're just empty cells:
0
votes
0answers
10 views

How to make a report that show all the enterprise that have at least 2 employees?

Hi how did you do a report that show all the enterprise that have at least 2 employees ?
0
votes
0answers
9 views

Data Pull- Information appears in Preview, but not when exported as csv

I am trying to pull csv (excel) data from the Case Reports » CNLP Data When I look at it in preview, I see 680 records. However, when I export it to the csv, it generates a blank document (outside of ...
0
votes
0answers
15 views

Report Plus: Issue with filtering campaigns

We've found an issue with Report Plus. The extension doesn't show the choosed campaign (via filters) in the results. So if we choose to filter for Campaign A, it shows another different campaign. This ...
0
votes
0answers
22 views

How to Add Sum Total to Report

I've got a custom integer field on event participants. I'm using an event participant listing report. I'd like to add a bottom row that gives me a sum total of that field for each event. It looks ...
0
votes
0answers
21 views

Saving a Civi Report- too many redirects error

I'm trying to save a contact summary report after amending filters. After each attempt to save I get a too many redirects error. I can see the new instances in the civicrm_report_instances table, ...
0
votes
0answers
16 views

Joomla has no CiviReport permissioning, so how can I limit reports to individual users?

Welp, after the disappointing realization from this question -- that unlike the Drupal and Wordpress implementations, CiviCRM in Joomla does NOT include permissioning for individual CiviReports -- I'm ...
0
votes
0answers
15 views

Lookup Field in Extended Reports

I've created a relationship report through the Extended Reports extension but have run into a challenging situation. I want the report to show detailed information (in this case, the name of the ...
0
votes
0answers
17 views

Report Columns not in the right order [duplicate]

I would like to reorder report columns. Is there a way to do this? It looks like someone else has asked a similar question (Reorder Report Column) but it looks like the answer is to use some other ...
0
votes
0answers
14 views

Membership Report (Detail) filter not applied when first run

The Membership Report (Detail) report returns all members, including delete ones. It seems the filter isn't applied until you click View Results. Is this intentional, or a bug? I see it with 5.15.2 ...
0
votes
1answer
26 views

Contribution Report - Grouped by Custom Field

I am looking to be able to build a report that essentially has aggregate donations grouped by a custom field. For example - every donor is asked: How did you hear about us (Referral Source), which is ...
0
votes
0answers
14 views

Combine reports of 2 kinds. Possible?

I would like to get a report of "activities" and include some information specifically related to contribution. This is what I am expecting to see in results the report: Source name - (backend user) ...
0
votes
0answers
12 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\...
0
votes
2answers
134 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 ...
0
votes
1answer
17 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, ...
0
votes
0answers
28 views

CiviReport: Field not found when sorting by Case Type as a section header

I've replicated this on a second Drupal/Civi 4.7.27 site so I don't believe it's limited to me, but could do with a bit of assistance before putting it on JIRA. Attempting to create a Case Detail ...

1
5 6 7
8
9