Development issueshttps://lab.civicrm.org/groups/dev/-/issues2020-03-05T20:45:12Zhttps://lab.civicrm.org/dev/core/-/issues/925Activity report: include case activities filter ignored2020-03-05T20:45:12ZMonish DebActivity report: include case activities filter ignoredYou can see in the where clause case-activity filter field is always set to NULL.You can see in the where clause case-activity filter field is always set to NULL.5.12.0Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/865Result filter criteria doesn't show IS NULL/IS NOT NULL for operations2019-04-15T05:32:20ZyashodhaResult filter criteria doesn't show IS NULL/IS NOT NULL for operationsWe can not search all contributions that are not associated with a campaign currently in report. We should expose IS NULL/IS NOT NULL for other operators as wellWe can not search all contributions that are not associated with a campaign currently in report. We should expose IS NULL/IS NOT NULL for other operators as well5.13.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1118Case summary report filters incorrectly for case type2019-07-21T23:07:54ZDeepak SrivastavaCase summary report filters incorrectly for case typeCase summary report uses REGEXP filtering for case type:
`WHERE case_civireport.case_type_id REGEXP '[[:cntrl:]]*5[[:cntrl:]]*' `
Which results in records where case type id consists of 5 (for this example).
![image](/uploads/485a42f6d...Case summary report uses REGEXP filtering for case type:
`WHERE case_civireport.case_type_id REGEXP '[[:cntrl:]]*5[[:cntrl:]]*' `
Which results in records where case type id consists of 5 (for this example).
![image](/uploads/485a42f6d595079ce990816695e1b4a6/image.png)
The clause looks old and appears to be based on assumption that case could be based on multiple case types. Case type however is an integer column and could use where() clause of CRM/Report/Form.php.
The problem also been raised on stack exchange - https://civicrm.stackexchange.com/questions/30573/case-type-filter-bug-in-case-summary-report-multiple-case-types-reported.
A PR would follow.5.17.0https://lab.civicrm.org/dev/core/-/issues/987Issue with alterReportVars hook invoke2019-08-01T04:07:14ZsushantpIssue with alterReportVars hook invokeCurrently alterReportVars hook is invoked after grand total and section total calculations.
When alterReportVars used for altering any values in report rows , calculations does not take that into
consideration.
alterReportVars hook ...Currently alterReportVars hook is invoked after grand total and section total calculations.
When alterReportVars used for altering any values in report rows , calculations does not take that into
consideration.
alterReportVars hook should invoked before grand total and section total calculations.5.17.0https://lab.civicrm.org/dev/core/-/issues/4532Add sort for country/state fields in reports2023-08-24T15:17:42ZyashodhaAdd sort for country/state fields in reportsAdd sort for country/state fields in reportsAdd sort for country/state fields in reports5.66.0yashodhayashodhahttps://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/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/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/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.0https://lab.civicrm.org/dev/core/-/issues/3228Can't filter by anything other than contribution status in Contribution Aggre...2022-04-22T15:51:19ZDaveDCan't filter by anything other than contribution status in Contribution Aggregate by Relationship CiviReportThere's a hack(?) in the report to allow filtering by status: https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L432-L434
and then the query uses it at https://g...There's a hack(?) in the report to allow filtering by status: https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L432-L434
and then the query uses it at https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L688-L690
(Yes this report is in a file called History.php - I assume for _historical_ reasons...)
But choosing to filter by anything else doesn't apply the filter.
1. Create two contributions for a person, with different financial types.
1. Run the report and check the Aggregate Amount column and filter by one financial type.
1. It still includes both contributions.
There's an argument that this is "correct" in the sense described at https://lab.civicrm.org/dev/core/-/issues/2707#note_62816, i.e. "Find contacts that match the criteria, THEN run the report on them", so that it's finding _CONTACTS_ that have a contribution with that financial type, and then running the report and aggregating their contributions. But this report isn't a generic advanced search, it's specifically related to contributions, so I'd argue the contribution filters should apply to the contributions being included.
I can see why this might be a little difficult in this report because it needs to build the rows separately to handle the relationships, so it doesn't just use the stock civireport framework to do the filtering. But maybe the "hack" could be made more generic.
The report also gives an error `User deprecated function: Formatting non-numeric values is no longer supported: ... Caller: CRM_Utils_Money::formatLocaleNumericRoundedByPrecision` but that's separate. (Edit: Haha it seems I've noticed this before https://lab.civicrm.org/dev/core/-/issues/2819)5.45.0https://lab.civicrm.org/dev/core/-/issues/3202In membership detail report the join date field has a different output date f...2023-11-10T00:08:12ZDaveDIn membership detail report the join date field has a different output date format than the other date fieldsCan reproduce on dmaster.demo.
On the membership details report in the columns tab select join date as a field. When you run the report the join date column has a different date format than the start/end date. It seems to always be yyyy...Can reproduce on dmaster.demo.
On the membership details report in the columns tab select join date as a field. When you run the report the join date column has a different date format than the start/end date. It seems to always be yyyy-mm-dd.
Doesn't seem to be a recent issue.5.69.0https://lab.civicrm.org/dev/core/-/issues/2684CiviReport grouping broken wrt filters2021-07-16T13:07:53ZeileenCiviReport grouping broken wrt filtersWhen declaring columns for civireport there is a 'grouping' mechanism - to group tables together - but in the UI it doesn't work because the tpl doesn't know how to group them together
![image](/uploads/666557d6e2606a320e59005aa277ed58/...When declaring columns for civireport there is a 'grouping' mechanism - to group tables together - but in the UI it doesn't work because the tpl doesn't know how to group them together
![image](/uploads/666557d6e2606a320e59005aa277ed58/image.png)5.41.0https://lab.civicrm.org/dev/core/-/issues/2574Grant report: Grant details not showing properly state/province and country2021-04-28T05:32:44ZVangelisPGrant report: Grant details not showing properly state/province and country## Issue
This issue is similar to the one reported [here - #220](https://lab.civicrm.org/dev/core/-/issues/220)
On the Detailed Grant report, the state/province shows the numeric values instead of the actual text labels.
## How to rep...## Issue
This issue is similar to the one reported [here - #220](https://lab.civicrm.org/dev/core/-/issues/220)
On the Detailed Grant report, the state/province shows the numeric values instead of the actual text labels.
## How to replicate
On https://dmaster.demo.civicrm.org create 1-2 grants. Then go to Grants - Grant Reports -> Allow state/province in the list of columns and render the report.
![image](/uploads/dea83dd0ab256d3fcea7b7d017b9ac14/image.png)
`Country` and `state/province` show numeric values instead.
## How to fix
Adding the following line:
`$entryFound = $this->alterDisplayAddressFields($row, $rows, $rowNum, NULL, NULL) ? TRUE : $entryFound;`
before [here](https://lab.civicrm.org/dev/core/-/blob/master/CRM/Report/Form/Grant/Detail.php#L248) seems to be solving the issue (code replicated from issue #220)
Edit: PR is [here - 20169](https://github.com/civicrm/civicrm-core/pull/20169)5.38.0https://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/2505CiviReport does not localize custom fields of type Number2023-02-16T13:30:23ZjaapjansmaCiviReport does not localize custom fields of type Number**How to reproduce**
1. Set localization settings: **decimal separator** to `,` and **thousand separator** to `.`
2. Add a custom group for cases
3. Add a custom field of **Type** `Number` and **Field type** `Text`
4. Enter a value such...**How to reproduce**
1. Set localization settings: **decimal separator** to `,` and **thousand separator** to `.`
2. Add a custom group for cases
3. Add a custom field of **Type** `Number` and **Field type** `Text`
4. Enter a value such as `1,234.56` which is localized `1.234,56`
5. Create a new CiviCase detail report. Check the column to display the custom field.
**Expected result**
Value of the custom field displayed as `1.234,56`
**Actual result**
Value of custom field is displayed as `1234.56` (note the decimal separator and the missing thousand separator).
**Comment**
The display value of custom number fields is also broken on the manage case screen.
We have a function `CRM_Utils_Money::formatLocaleNumericRoundedForDefaultCurrency` to format money fields. However we do not have such a function for number fields with a decimal. So basically nowhere in CiviCRM a number field is formatted according to localization settings. Unless the smarty modifier `|crmNumberFormat` is used in the template.
A fix should probably happen in `CRM_Core_BAO_CustomField::formatDisplayValue`, see https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/BAO/CustomField.php#L1187
However I am not exactly sure how to fix this as I could not find a number formatting function such as we have for the money field. Does such a function exists and if so where do I find it?5.38.0https://lab.civicrm.org/dev/core/-/issues/2420Add no results found on empty civireports dashlet2021-03-28T16:35:20ZeileenAdd no results found on empty civireports dashletI've had a customer report that the dashlets are borked post upgrade. We are using shoreditch & I am investigating this issue https://github.com/civicrm/org.civicrm.shoreditch/issues/484
However in the context of grenwich I have noticed...I've had a customer report that the dashlets are borked post upgrade. We are using shoreditch & I am investigating this issue https://github.com/civicrm/org.civicrm.shoreditch/issues/484
However in the context of grenwich I have noticed 2 things - the first of which is this issue - notably that part of the user's confusion was the blank box.
This box is blank in 5.30 and in dmaster (per below) so it is not new but I think we should have some indicator of lack of results rather than empty
![image](https://user-images.githubusercontent.com/336308/109080485-89aab380-7765-11eb-874f-962f49e22ada.png)
![image](https://user-images.githubusercontent.com/336308/109080515-9929fc80-7765-11eb-82b4-26e463e60d0d.png)5.36.0https://lab.civicrm.org/dev/core/-/issues/2391Do Not Trade Privacy option is missing from report template.2021-02-23T09:18:57ZtapashDo Not Trade Privacy option is missing from report template.Do Not Trade Privacy option is missing from core report template.Do Not Trade Privacy option is missing from core report template.5.36.0https://lab.civicrm.org/dev/core/-/issues/2288Custom Field of type Integer that uses Radio Buttons as Input Type in combina...2021-01-19T03:23:54ZkainukCustom Field of type Integer that uses Radio Buttons as Input Type in combination with search range scrambles Case Report SearchOverview
----------------------------------------
https://civicrm.stackexchange.com/questions/38562/why-does-my-delete-case-action-in-the-case-search-report-not-work
Reproduction steps to create the testcase
----------------------------...Overview
----------------------------------------
https://civicrm.stackexchange.com/questions/38562/why-does-my-delete-case-action-in-the-case-search-report-not-work
Reproduction steps to create the testcase
----------------------------------------
1. Create a Custom Field on Cases of the type Integer
1. Start with display type 'Single Input Line'
1. Enable 'Is this Field Searchable?'
1. Now 'Search by Range' becomes visible.
1. Change the display type to Radio Buttons.
1. Add some Option Values and save the field.
Remark, some interface magic is required to create this situation. I think its more done by accident, than by intent.
Current behaviour
----------------------------------------
The behaviour is now as described in https://civicrm.stackexchange.com/questions/38562/why-does-my-delete-case-action-in-the-case-search-report-not-work .
Expected behaviour
----------------------------------------
The Case Search report should just work
Environment information
----------------------------------------
This issue can be reproduced on 5.34.alpha1 or on the https://dmaster.demo.civicrm.org
Comments
----------------------------------------
https://lab.civicrm.org/dev/core/-/issues/337 contains a discussion if the combination 'Radio Buttons' and 'Search by Range' should be allowed.5.35.0https://lab.civicrm.org/dev/core/-/issues/2285The civicrm_alterReportVar hook is not working for contribute detail report2021-04-06T20:01:06Zahed_compucorpThe civicrm_alterReportVar hook is not working for contribute detail reportOverview
----------------------------------------
The `civicrm_alterReportVar` is not working for contribute detail report when the user select the new column or choose the new filter, and it will show an error message `DB Error: no such...Overview
----------------------------------------
The `civicrm_alterReportVar` is not working for contribute detail report when the user select the new column or choose the new filter, and it will show an error message `DB Error: no such field`
Here at [Detail.php#L956](https://github.com/civicrm/civicrm-core/blob/3662d5a75d79d6c259b632df748b1beb66db6faf/CRM/Report/Form/Contribute/Detail.php#L956) our changes to the `_form` attribute are lost and the error will be fired here [Detail.php#L576](https://github.com/civicrm/civicrm-core/blob/3662d5a75d79d6c259b632df748b1beb66db6faf/CRM/Report/Form/Contribute/Detail.php#L576)
Unknown column 'some_table.some_column' in 'where clause'
I believe this is a regression on soft credits.
Reproduction steps
----------------------------------------
Any suffecient use of this hook will face the error message.
[The code](https://gist.github.com/ahed-compucorp/672363f80c076a80c2804b78f61baaa9).
![Peek_2021-01-04_17-19](/uploads/4fef18053a65a947205d6540aa123552/Peek_2021-01-04_17-19.gif)
check the test case in the PR.
PR: https://github.com/civicrm/civicrm-core/pull/193175.37.0