CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2022-12-31T05:03:25Zhttps://lab.civicrm.org/dev/core/-/issues/1357Add column for total duration for Activity report2022-12-31T05:03:25ZyashodhaAdd column for total duration for Activity reportAdd column for total duration for Activity report. This will be the sum of duration of all activities in report result and will be displayed in the statistics section.Add column for total duration for Activity report. This will be the sum of duration of all activities in report result and will be displayed in the statistics section.https://lab.civicrm.org/dev/core/-/issues/1252Contribution Summary report only shows first 50 entries2022-12-30T05:03:34ZVangelisPContribution Summary report only shows first 50 entriesHi!
I've noticed that the Contribution Summary report only shows the first 50 entries, without giving you the ability to move to the next set of records.
Bottom-page statistics also calculate those 50 displayed entries and not all ro...Hi!
I've noticed that the Contribution Summary report only shows the first 50 entries, without giving you the ability to move to the next set of records.
Bottom-page statistics also calculate those 50 displayed entries and not all rows.
Narrowing it down, I was able to make it work again by commenting 3 lines on the function `buildRows`. The offending lines:
```php
CRM_Core_DAO::disableFullGroupByMode();
CRM_Core_DAO::reenableFullGroupByMode();
$this->addToDeveloperTab($sql);
```
Source code reference [here](https://lab.civicrm.org/dev/core/blob/master/CRM/Report/Form/Contribute/Summary.php#L743-746)
Only when all these 3 lines are commented/removed, the report displays all records with a proper pager.
Anyone can shed any light why is this happening as I can't seem to be able to find out the reason?
Spotted on CiviCRM 5.16.2https://lab.civicrm.org/dev/core/-/issues/1314“Post Code Suffix” in Reports is the same as “Postal Code”2022-12-28T05:03:26Zdavepage“Post Code Suffix” in Reports is the same as “Postal Code”As per [this bug report](https://civicrm.stackexchange.com/questions/28778/post-code-suffix-in-reports-is-the-same-as-postal-code), which I can still reproduce on CiviCRM 5.16.2 on Drupal 7.67
>>>
My contacts have UK-style postcodes wit...As per [this bug report](https://civicrm.stackexchange.com/questions/28778/post-code-suffix-in-reports-is-the-same-as-postal-code), which I can still reproduce on CiviCRM 5.16.2 on Drupal 7.67
>>>
My contacts have UK-style postcodes with the first half (e.g. "M19") stored in "Postal Code" and the second (e.g. "3JD") in "Post Code Suffix".
I am trying to get a list of my members, with full postcode data, as a CSV. I generate the built-in "Membership Report (Detail)" which is at /civicrm/report/instance/20 for my instance. I then add the "Postal Code" and "Post Code Suffix" columns (among other address ones). The data displayed in "Post Code Suffix" is identical to that in "Postal Code", e.g. they are both "M19". This is also the case in an exported CSV of the report.
The correct data is in the database - clicking on any "Contact Name" from the report takes me to the individual "View Contact" screen, where the Post Code & Suffix are correct (e.g. "M19" "3JD").
Any idea what's going on here or how I can fix this?
>>>https://lab.civicrm.org/dev/core/-/issues/1102If a report is sorted on a custom "Number" field, the sort should use numeric...2022-11-18T05:03:23ZtottenIf a report is sorted on a custom "Number" field, the sort should use numeric orderingI observed this while replicating #1081, so steps to reproduce start out similarly. Of course, it is a different issue, so the steps do become different. The steps are:
(1) Create a custom field on contribution records. Make it "Number=...I observed this while replicating #1081, so steps to reproduce start out similarly. Of course, it is a different issue, so the steps do become different. The steps are:
(1) Create a custom field on contribution records. Make it "Number=>Text" and flag it as searchable. I called the example "Frobnication Score".
![Screen_Shot_2019-07-03_at_8.59.44_PM](/uploads/a54e1537d12bbb9061620ece8d214e07/Screen_Shot_2019-07-03_at_8.59.44_PM.png)
(2) Do a search for some contribution records. Edit a few of them and fill in made-up values for the "Frobnication Score". I happened to use "100", "120", and "90.
(3) Create a "Contribution Detail" report. In "Columns", add the "Frobnication Score". In "Sorting", choose "Frobnication Score" (first) and "Contact Name (in sort format)" (second).
The column is numerical, so you would expect the ordering to be numerical (ascending, "90 => 100 => 120"; or descending, "120 => 100 => 90"). The actual ordering looks like dictionary/alphabetic ("100", "120", "90"). For numeric data, the only useful ordering would be... numerical ordering...
![Screen_Shot_2019-07-03_at_8.58.33_PM](/uploads/d650e5ca589ad2bde2b851faaa76203e/Screen_Shot_2019-07-03_at_8.58.33_PM.png)
I've observed similar behavior in 5.12.4 and 5.16.alpha1.https://lab.civicrm.org/dev/core/-/issues/1095Activity Details report: Sorting by the “Source Email” field: DB Error: no su...2022-11-17T05:03:52ZPradeep Nayakpradpnayak@gmail.comActivity Details report: Sorting by the “Source Email” field: DB Error: no such field.**Steps to replicate:**
1. Click "Reports" > "Contact Reports"
1. Open the "Activity Details" report
1. Open the "Sorting" tab
1. Set following sorting options :
* Column: Source Email
* Order: Ascending
* Section Header / Group By: che...**Steps to replicate:**
1. Click "Reports" > "Contact Reports"
1. Open the "Activity Details" report
1. Open the "Sorting" tab
1. Set following sorting options :
* Column: Source Email
* Order: Ascending
* Section Header / Group By: check box selected
1. Click "Refresh Results"
**Actual result:** DB Error: no such field.
**Expected result:** The user can group the “Activity Details” report by the “Source Email” field
Query:
```
Jul 02 11:00:54 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']
[type] => DB_Error
[user_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']"]
)
```https://lab.civicrm.org/dev/core/-/issues/3992Expose created date column in contact reports2022-11-16T21:33:39ZyashodhaExpose created date column in contact reportsExpose created date column in contact reports and as filter as well.Expose created date column in contact reports and as filter as well.5.57.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/944Report doesn't show value for disabled options in results2022-11-01T05:03:33ZyashodhaReport doesn't show value for disabled options in resultsSteps to replicate:
* Create a contribution with custom data *Donor Information* with field *How long have you been a donor?* with seleted option *Less than 1 year*
* Disable *Less than 1 year* option.
* The option should still be pre...Steps to replicate:
* Create a contribution with custom data *Donor Information* with field *How long have you been a donor?* with seleted option *Less than 1 year*
* Disable *Less than 1 year* option.
* The option should still be present in report results though not on edit/create screens.
I was able to replicate this on dmaster as well. It is confusing to the users who may have disabled some options due to not being valid anymore(legacy options), but still would want to see them in search results.
Thoughts?https://lab.civicrm.org/dev/core/-/issues/1091Sybunt/lybunt sample report instance has year filter saved as 20112022-10-29T17:19:26ZDaveDSybunt/lybunt sample report instance has year filter saved as 20112011 wasn't a bad year, but the instance probably doesn't need any year saved.
The report code itself is fine, and creating a new report from template defaults to current year.
I believe this is coming from xml/templates/civicrm_naviga...2011 wasn't a bad year, but the instance probably doesn't need any year saved.
The report code itself is fine, and creating a new report from template defaults to current year.
I believe this is coming from xml/templates/civicrm_navigation.tpl: `s:6:"yid_op";s:2:"eq";s:9:"yid_value";s:4:"2011";`
https://civicrm.stackexchange.com/questions/31266/sybunt-some-year-but-not-this-year-showing-2011-as-this-year5.56.0https://lab.civicrm.org/dev/core/-/issues/868Contribution summary misleading results when filter cuts through a group2022-10-24T05:03:35ZJKingsnorthContribution summary misleading results when filter cuts through a groupWhen combining a grouping and a filter on the contribution summary report, the results are misleading. Because it cuts of donations that are before the filter, even though they are part of the group being displayed.
For example (on dmas...When combining a grouping and a filter on the contribution summary report, the results are misleading. Because it cuts of donations that are before the filter, even though they are part of the group being displayed.
For example (on dmaster):
Create a contribution on 7 Feb 2017
Create a contribution on 9 Feb 2017
(Two contributions in the same week).
Contribution summary, add a grouping by frequency: Week, view results:
![image](/uploads/9408ab7cdb3d9439ee7558ae5506a126/image.png)
Note - w/c 6 Feb 2017 has 2 donations (correct)
Add a filter for date received 'after' 8 Feb 2017, view results.
![image](/uploads/45d57dbfef1c1b83af0778933817bc09/image.png)
The contribution count is listed as 1 now.
Although this is correct in terms of the filter, it is misleading in the context of the report.
Suggestion solution:
Where a grouping (week, month, fiscalyear, anything) is 'cut' by a filter - extend the filter so that it goes to the start of that grouping. ie: in the example above, all of the values from w/c 6 Feb would still be included in the report.https://lab.civicrm.org/dev/core/-/issues/838Expose participant note in Participant list Count Report2022-10-18T05:03:55ZyashodhaExpose participant note in Participant list Count ReportExpose participant note in Participant list Count ReportExpose participant note in Participant list Count Reportyashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3825Changing report rows per page doesn't change rows per page, but limits what i...2022-09-26T20:22:56ZspalmstromChanging report rows per page doesn't change rows per page, but limits what is displayed.Overview
----------------------------------------
Changing the Rows Per Page value at the bottom of the report gives strange results.
Reproduction steps
----------------------------------------
1. Click on **Reports** and choose say a **...Overview
----------------------------------------
Changing the Rows Per Page value at the bottom of the report gives strange results.
Reproduction steps
----------------------------------------
1. Click on **Reports** and choose say a **Contact** report.
1. Click on **View Results**.
1. You get a report with 50 rows.
1. Change the Rows Per Page to something other than 50
Current behaviour
----------------------------------------
You still get 50 rows per page. The figure for the number of pages available may be different and you might not even be able to see the remaining values.
I put 75 rows per page into Activity Details on the Drupal Sandbox and got:
![image](/uploads/1c115534c79b8b08d18e0c31633f4563/image.png)
Expected behaviour
----------------------------------------
I should have seen 72 rows on the page or at least be able to go to the next 22 rows.
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __Browser:__ _MS Edge_ but probably irrelevant.
* __CiviCRM:__ _5.54.alpha1/5.52.2_ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__ _7.4.30_ but probably irrelevant.
* __CMS:__ _Drupal Whatever the sandbox runs_ but probably irrelevant
* __Database:__ _Whatever the sandbox runs_ but probably irrelevant.
* __Web Server:__ _Whatever the sandbox runs/IIS 10_ but probably irrelevant.
Comments
----------------------------------------
_Anything else you would like the reviewer to note._5.55.0https://lab.civicrm.org/dev/core/-/issues/1129Duplicate records on CRM_Report_Form_Member_Detail2022-09-26T00:11:17ZandyburnsDuplicate records on CRM_Report_Form_Member_DetailOn CRM_Report_Form_Member_Detail, the rows get duplicated. They are not actual duplicates, it is the same contact ID and they do not have duplicate memberships.
![5b7f716e](/uploads/6ae639a21fd22a9b5fc47c1d1edf66be/5b7f716e.png)
On 5.13.4On CRM_Report_Form_Member_Detail, the rows get duplicated. They are not actual duplicates, it is the same contact ID and they do not have duplicate memberships.
![5b7f716e](/uploads/6ae639a21fd22a9b5fc47c1d1edf66be/5b7f716e.png)
On 5.13.4https://lab.civicrm.org/dev/core/-/issues/3204Add recurring contributions to contribution reports2022-09-16T21:11:08ZlarsssandergreenAdd recurring contributions to contribution reportsIt would be very convenient to be able to do filter by recurring contributions for reports, add recurring contributions as a column or even group by.
[Here's a PR that adds this for the Contribution Summary report.](https://github.com/c...It would be very convenient to be able to do filter by recurring contributions for reports, add recurring contributions as a column or even group by.
[Here's a PR that adds this for the Contribution Summary report.](https://github.com/civicrm/civicrm-core/pull/20168) I will also implement in other relevant reports once this has been reviewed.https://lab.civicrm.org/dev/core/-/issues/524Lybunt incorrect / misleading rowCount information2022-09-14T05:03:42ZeileenLybunt incorrect / misleading rowCount informationThe Lybunt report declares a misleading number of rows because it includes the rollup row in the count.
So for example there are 9 matching contacts but we see the confusing message Rows Listed 9, Rows found 10. The 10th Row is a calcu...The Lybunt report declares a misleading number of rows because it includes the rollup row in the count.
So for example there are 9 matching contacts but we see the confusing message Rows Listed 9, Rows found 10. The 10th Row is a calculation of the total rows.
![Screenshot_2018-11-15_14.20.45](/uploads/5933de1016a4fb8b9b1e4447206b07a7/Screenshot_2018-11-15_14.20.45.png)
When there is just one screen we can remove a row that is meant to help - but doesn't & the 'Total Rows' line goes away.
However, when there are multiple pages we have both the pager & the totals to deal with. If we remove the row from the totals count but not the pager it creates a confusing mismatch. If we remove from both the last row may become unreachable.
On the Lybunt report a maximum of one level of group by is in play. However, where reports support multiple levels of group by it's unknowable how many rows are rollup rows.
This might all be an argument against the use of Rollup - but not going there at this stage I think my best proposal is to add text to indicate the possible presence of calc rows in the Total Rows
![Screenshot_2018-11-15_14.11.37](/uploads/cd4c266eb5c49570815b130a809f26ec/Screenshot_2018-11-15_14.11.37.png)https://lab.civicrm.org/dev/core/-/issues/2540Print report permissions2022-06-02T18:01:45ZDevAppPrint report permissionshttps://civicrm.stackexchange.com/questions/22261/how-to-hide-configuration-tabs-of-a-report-with-the-print-to-pdf-action-remain
But when disabling the “access Report Criteria” permission, the "Print report" and "Print to PDF" functions...https://civicrm.stackexchange.com/questions/22261/how-to-hide-configuration-tabs-of-a-report-with-the-print-to-pdf-action-remain
But when disabling the “access Report Criteria” permission, the "Print report" and "Print to PDF" functions on a report appear, but do not function.
The user is just redirected back to the same report.
The functionality appears broken, as the report gives the option to print but it does not work without the additional permission.
Possible solutions:
- Give permissions to print if access report permissions are already granted and the user can view a report
- Add a new print permission and only show the print option if enabled for user
- Hide existing print options if view report criteria not selected, as the user can't print5.51.0Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/3283Contribution Summary Report: The "general total" row does not take the curren...2022-04-22T15:53:43ZdmunioContribution Summary Report: The "general total" row does not take the currency filteredWhen the contribution summary report is used by filtering for a currency other than the site's default currency, the "grand total" row shows the sign of the default currency instead of the filtered currency.
![image](/uploads/e65afcbdde...When the contribution summary report is used by filtering for a currency other than the site's default currency, the "grand total" row shows the sign of the default currency instead of the filtered currency.
![image](/uploads/e65afcbdde35490ab7602d21161c13f0/image.png)
This issue is resolved by changing the code of the following line: https://github.com/civicrm/civicrm-core/blob/2235525e475edd2573a1ad71897cd42d2ea3cdfd/templates/CRM/Report/Form/Layout/Table.tpl#L139
By the following code:
```php
{if $currencyColumn}
{$grandStat.$field|crmMoney:$row.$currencyColumn}
{else}
{$grandStat.$field|crmMoney}
{/if}
```5.29.0https://lab.civicrm.org/dev/core/-/issues/3274Filter contact sub-type by "is not one of" fails2022-04-22T15:53:25Zaydunsaidan.saunders@squiffle.ukFilter contact sub-type by "is not one of" failsWhen filtering by contact sub-type, "is not one of" excludes all those that do not have a sub-type.
Noted previously here: https://lab.civicrm.org/dev/report/issues/15#note_25491
For example, filtering by "is not one of" 'Student' shou...When filtering by contact sub-type, "is not one of" excludes all those that do not have a sub-type.
Noted previously here: https://lab.civicrm.org/dev/report/issues/15#note_25491
For example, filtering by "is not one of" 'Student' should just exclude those who do have a sub-type of Student. Currently, it also excludes all those who have a sub-type of Student, and also all those with no sub-type.5.21.0aydunsaidan.saunders@squiffle.ukaydunsaidan.saunders@squiffle.ukhttps://lab.civicrm.org/dev/core/-/issues/3259Add the possibility to use the hook_civicrm_alterReportVar('sql') in all reports2022-04-22T15:53:00ZrubofvilAdd the possibility to use the hook_civicrm_alterReportVar('sql') in all reportsSome reports have rewrited the method "buildQuery" from class CRM_Report_Form. Not in all reports is included the line to launch the hook `hook_civicrm_alterReportVar` -> `CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Example
h...Some reports have rewrited the method "buildQuery" from class CRM_Report_Form. Not in all reports is included the line to launch the hook `hook_civicrm_alterReportVar` -> `CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Example
https://github.com/civicrm/civicrm-core/blob/abc4afe890add20796585a2a997bc3d832815abe/CRM/Report/Form/Member/ContributionDetail.php#L552https://lab.civicrm.org/dev/core/-/issues/3248Add "created_date" to report filters2022-04-22T15:52:38ZphilipkasoAdd "created_date" to report filters**Use Case**: Report on all contacts created <period>.
**Background/Ask**: "created_date" can only be used via Change Log in Advance Search. We would like to be able to use the "Change Log" created date as a filter in standard reporting...**Use Case**: Report on all contacts created <period>.
**Background/Ask**: "created_date" can only be used via Change Log in Advance Search. We would like to be able to use the "Change Log" created date as a filter in standard reporting to satisfy the stated use case.https://lab.civicrm.org/dev/core/-/issues/3238Graphs on Contribution Summary report replace final row with grand total value2022-04-22T15:51:46ZAndrew WestGraphs on Contribution Summary report replace final row with grand total valueGraphs on the Contribution Summary report will include the grand total in some circumstances. To replicate on demo site:
1. Using demo data, launch the Contribution Summary report
2. Leave all settings as default
3. Refresh results a...Graphs on the Contribution Summary report will include the grand total in some circumstances. To replicate on demo site:
1. Using demo data, launch the Contribution Summary report
2. Leave all settings as default
3. Refresh results and note the grand total. Current data shows this:
![Annotation_2020-05-20_211434](/uploads/17d1b5942dde265bf0076d857396e46b/Annotation_2020-05-20_211434.png)
4. Switch to a bar chart in the top right and click 'View'. Hover over the final column and you'll see it's the grand total number:
![barchart](/uploads/3454788b2eecfc7ea4b8d44538b371d6/barchart.png)
I'm not terribly familiar with reports, but my initial fix was to add this to the top of CRM_Report_Form_Contribute_Summary::buildChart()
if ($this->_rollup) {
array_pop($rows);
}
If this makes sense I can make it a PR.5.28.0