Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
0
votes
2answers
100 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
1answer
53 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
0answers
6 views

Filter an event report with non-primary state or adress (CiviCRM 5.14.2 with Drupal 7)

I have two addresses one is a home address that's primary and main address with corresponding states. I would like to get events details of particular states coming under the primary address only. ...
0
votes
0answers
14 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
10 views

Is there a way to export a search/export GDPR Comms preferences?

I have a list of about 1000 contacts all of which were put through our GDPR compliance process in May 2018. We can export those actively opted out of email, Bulk Email etc - via the search function, ...
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
12 views

How do you display more than 50 rows in a Contribution Summary Report?

How do you display more than 50 rows in a Contribution Summary Report? I am able to export to CSV or PDF and get the full results - but I am unable to make it display on web more than 50 rows. D7 ...
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
0answers
26 views

403 error when accessing or exporting CiviMail open reports

Running CiviCRM 5.13.5 on Drupal 7.67. I have all admin permissions, and all permissions relating to CiviReport. Trying to run reports on CiviMail to export as CSV everyone who opened a particular ...
0
votes
1answer
18 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
12 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
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\...
0
votes
1answer
41 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/...
0
votes
1answer
101 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
15 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
26 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 ...
0
votes
0answers
98 views

How to add a sorting column in Reports

I have a report that I would like sorted by County but that field doesn't appear as a sortable column, although it does appear on the report. This field is in fact 'State/Province' but is renamed via ...
0
votes
1answer
35 views

Multi statement queries in Civireport

I am building a custom report that, due to its complexity, requires multiple SQL statements including the creation of temporary tables. I have developed the queries in MySQL workbench and they work ...
0
votes
1answer
108 views

CiviContribute Payment Selection

Ok, this is a little difficult to explain, but I'm going to try :) A customer set up a contribution page for payroll deduction, so they would just select the "Pay Later" payment option, but, for some ...
0
votes
1answer
50 views

Custom activity types do not appear in report filter

When creating a report from a template (specifically the Activity Report) custom case types are not available in the filter list.
0
votes
0answers
52 views

Relationship Extended Report produces errors

I have been getting errors when trying to run relationship report extension & from some reports from this template created in 12/14. We depend on these reports for much of our work. Can anyone ...