All Questions
Tagged with reporting or civireport
495 questions
1
vote
1
answer
143
views
'A potentially unsafe operation has been detected in your request to this site' error
I want to get a membership list contaitning their name and address through the 'Report' function. But when I do this, a message 'A potentially unsafe operation has been detected in your request to ...
- 39.5k
1
vote
1
answer
37
views
Add columns to SYBUNT report
We run CiviCRM 5.20.2 on Joomla 3.9.15
We use Reports - Donation Reports - Sybunt
We need to be able to select in the Columns area:
• Nickname
• Do not mail / contact
• Deceased
• Postal ...
- 24.7k
3
votes
2
answers
117
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 ...
- 23
0
votes
1
answer
92
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 ...
CommunityBot
- 1
3
votes
1
answer
336
views
How to get rid of  when exporting report to CSV file
How to get rid of  when exporting report to CSV file. running report
- 24.7k
0
votes
0
answers
48
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, ...
- 2,037
3
votes
3
answers
98
views
How to generate a report excluding recurring contributions?
Is there any way to get a report, ideally something like the Contribution Summary report, which allows you to filter by recurring or non-recurring contribution?
It would be quite useful to be able to ...
- 870
0
votes
1
answer
23
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 ...
- 443
1
vote
2
answers
76
views
how to set permissions on individual CiviReports (permission options not shown!)?
I wanted to create several reports that are limited to specific CiviCRM ACL roles. But I can't, because when I view the "Access" tab for the report settings, there are no permission fields shown.
...
- 24.7k
0
votes
0
answers
23
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 ...
- 551
1
vote
1
answer
64
views
Attachment too large for mailing - should there have been a warning?
Recently had a user attach a .docx file that was 14 MB to a mailing. (Probably a single picture in the document was to blame.) As one would expect, the messages bounced rather than being delivered. ...
- 7,126
2
votes
1
answer
3k
views
nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()
After an upgrade from 5.7.x to 5.13.x, a standard contribution/detail report started failing. In the CiviCRM admin log, we see this sql error:
nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()
...
- 7,126
1
vote
0
answers
39
views
Filter no longer works in report
We created a report to list the contacts without a contactsubtype.
Previously, it worked, since a recent update it no longer works.
The report is based on a filter "contacsubtype is not one of" ...
- 493
1
vote
3
answers
79
views
Combining Event, Membership & Contacts into single report
So I can easily create a Search Builder for what I want, my challenge is creating a report that I can print an take to an event
Criteria:
Either registered for event
OR
A member of a specific group
...
- 2,388
0
votes
0
answers
17
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 ...
- 381
5
votes
1
answer
80
views
Displaying a column total in a report
Is there a way to display a column total when viewing a report?
Specifically, we are wanting to run reports on contribution line items and quickly see the contribution line item total.
When you do ...
- 51
1
vote
2
answers
64
views
Case Details Report- Active Case Role filter
Trying to run a case details report for all cases of type "x" opened between a given date range.
Noticed that not as many cases as expected show.
On further investigation found that there is a ...
- 13.7k
2
votes
0
answers
8
views
Getting more detail about transactions/ invoices/ donatons
I'd like to get more detail on what exactly each transaction contains. The report I have lists the donor, transaction number, date, amount and note. It's possible to get the shipping cost by drilling ...
1
vote
2
answers
90
views
Creating specific Report
How would we go about achieving the following report results? (I have looked at the report page but haven’t worked with this yet)
I have pasted a snippet below.
- 39.5k
0
votes
2
answers
48
views
how to create a report based on date subscription to a group?
I need to have a report that shows members according to their date of being part of a chosen group. I can select by group but not by date of being in this group.
Is this possible?
(I have a special ...
- 3,227
2
votes
1
answer
107
views
Default Value for Custom Field
I have a created a custom group and a custom field within that group.
One of the Custom fields is Date.
Is there any way to autoload 'current date' (today) in the default value field Using a hook or ...
- 521
2
votes
4
answers
303
views
Reorder Report Columns
I'm creating a basic custom report using constituent details. I'm hoping to find a way to reorder the columns in the report. For instance, I have a custom field that I'd like to go first, and then put ...
- 39.5k
0
votes
0
answers
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 ...
- 381
2
votes
0
answers
36
views
CiviCRM Report only showing 50 records
Do anyone else have Donation Reports that only show 50 records on the webpage but when you export it shows all of them? There is no pagination and looking at the demos, it looks like there should be.
...
- 4,965
6
votes
1
answer
66
views
Annual Donor Report
I would like to setup a report where I can see each donor's total donations by year, where each column would be a different year and the corresponding total, and each row would be each donor. Please ...
- 39.5k
1
vote
1
answer
33
views
Check numbers in reports
My client took great pains to record check numbers and payment amounts and wants to produce an event payment report which includes the check numbers associated with each registration. I can get ...
- 24.7k
2
votes
1
answer
22
views
Using CIVICRM to manage a Fundraising Dinner
We run a fundraising dinner once a year, approx 400 people, mainly couples.
what would be the best way to
a: set up an event that we can enter couples as contacts (we have to write to them post ...
- 8,288
3
votes
0
answers
28
views
Need a list of past event participants and several years are gray, can't access them
when i search for events they all show up, but some of them are grayed out and I can't access any information: I get this error--
An error has occurred.
0 @import url(/administrator/components/...
- 31
2
votes
1
answer
22
views
CiviReport Max Participants
I currently generate an Event Report of upcoming events that shows how many participants are registered for each event, but I'd also like for it to show the max participants allowed. When looking ...
- 24.7k
1
vote
0
answers
17
views
CiviReport sort event list by start date
Similar to CiviReport Participant Sort by Event Start Date
I would like my event report (Extended Report - Statistics across events) to display events ordered by event start date.
I am on CiviCRM 5....
- 43
1
vote
1
answer
66
views
Is 'developer' tab in Reports now a deprecated feature?
In Civicrm 5.4 and in current version in WP Sandbox, it seems that the 'Developer' tab is no longer shown. What is the replacement/suggested method for adding a column to reports now?
- 24.7k
0
votes
1
answer
81
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 ...
- 3,641
5
votes
1
answer
76
views
How to creat a report of recurring donors
How do I get a report of all the donors who are set up for automatically give the same amount each month
- 28.7k
2
votes
1
answer
170
views
How do you set a fiscal year?
Also - does changing a fiscal year change anything else outside of reporting and searching?
- 24.7k
0
votes
0
answers
20
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 ...
3
votes
3
answers
37
views
Report based on country
Could anyone tell me how to set up a report based on the country of the member (Northern Ireland, Republic of Ireland, England, Wales, Scotland).
Thanks in advance
Debs
- 4,965
1
vote
1
answer
31
views
SYBUNT (some year but not this year) showing 2011 as this year
When doing this option in civireport or LYBUNT (last year but not this year) Its showing this year as 2011.
everything else is showing the correct years...
why is this not?
- 24.7k
1
vote
0
answers
41
views
Emailed copy of report includes the SQL Query
Running civiCRM 5.14.1 ... and Joomla 3.9.8
When I receive my scheduled emailed Contribution report, the email contains the SQL used to generate the report... How do I avoid this?
The report is the ...
- 590
1
vote
1
answer
36
views
How to identify and report on donor anniversaries?
We'd like to acknowledge donors who have given continuously for (say) 5 years. Let's say 'continuous' means at least one donation in a year. How could these contacts be identified and reported? I've ...
- 1,856
1
vote
1
answer
35
views
How can I generate a CiviMail delivery & Click-thru report
I need to email a report to a person of a particular mass email that was sent from CiviMail. The person doesn’t have access to CiviCRM. How can I generate a CiviMail detailed delivery & Click-thru ...
- 24.7k
1
vote
1
answer
192
views
PHP warning "Warning: Declaration of CRM_Mailchimp_Permission" logged when open a CiviReport
Drupal 7.67
Civi 5.13.4
I get a PHP warning in my Drupal logs every time I open a report in Civi. The complete warning is
Warning: Declaration of CRM_Mailchimp_Permission::check($permissions) should ...
- 24.7k
0
votes
1
answer
49
views
Is there a way to expose a CiviReport on a Wordpress page?
Reports are not one of the component options available when using a shortcode in wordpress. What is the recommended way to expose a civireport on a wordpress page?
- 2,391
3
votes
1
answer
49
views
civiReport with financial type and line item financial types
Is there a report that displays both the overarching financial type and the individual line item financial types for contributions?
civiCRM Contribution and paid event pages require a financial type ...
- 24.7k
1
vote
2
answers
72
views
Civicase report shows empty list
I have set up report to list the number of active cases, however the report doesn't show anything when I refresh results, even though there is a number of opened cases which show in the Case dashboard....
- 427
7
votes
3
answers
141
views
Can we report on contributions by payment processor?
Is there support for filtering contribution reports by payment processor?
We have credit card (Authorize.NET) and PayPal (new). How can I report on just PayPal transactions?
The only difference I ...
- 39.5k
2
votes
1
answer
41
views
How to remove "Report URL" from emailed PDF reports header?
I would like to remove the link from a report email header. Is it easy to achieve? thanks
- 24.7k
0
votes
1
answer
140
views
CiviVolunteer error after upgrade to Civi 5.11.0 on joomla
Running civicrm 5.11.0 with CiviVolunteer on joomla 3.9.5 PHP 7.1 (as well a second site with the same problem on PHP 7.0)
I am running API v4 version 4.3.0
CiviVolunteer 4.7.31-2.3.1
Since upgrading ...
- 1,031
1
vote
3
answers
48
views
How can I generate a report for the financial transaction entered by USERS of certain "drupal Role"?
Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure ...
- 28.7k
0
votes
0
answers
17
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)
...
- 3,014
3
votes
1
answer
32
views
Rounding differences between Contribution and Bookkeeping reports
I am using Drupal 7.66 and CiviCRM 5.10.4. There is a small difference between the total of a Contribution report and a Bookkeeping report using the same filters and therefore intended to produce an ...
- 6,781