Questions tagged [civireport]

Questions specifically about CiviCRM's reporting system, CiviReport.

Filter by
Sorted by
Tagged with
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
47 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
24 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
37 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
1answer
15 views

How to report all event payments

The CiviReport's Event Income Report (Detailed) does not show each payment. How can I show (and hopefully total) all the payments registered in the system in one report?
0
votes
3answers
100 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
85 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
141 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
34 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
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
17 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
20 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
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
15 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
1answer
22 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
1answer
42 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
113 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
16 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 ...
0
votes
0answers
105 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
42 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
111 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
54 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 ...

1
4 5 6 7
8