Development issueshttps://lab.civicrm.org/groups/dev/-/issues2023-08-15T05:03:14Zhttps://lab.civicrm.org/dev/core/-/issues/2628Contribution Detail Report Select County2023-08-15T05:03:14ZandyburnsContribution Detail Report Select CountyThis report `CRM_Report_Form_Contribute_Detail`, and any reports based on it, have the order of Country, State, County wrong. It allows you to select the County first, then State, then Country. e.g. There are 12 entries for Douglas Count...This report `CRM_Report_Form_Contribute_Detail`, and any reports based on it, have the order of Country, State, County wrong. It allows you to select the County first, then State, then Country. e.g. There are 12 entries for Douglas County in Colorado, USA, and choosing the wrong one returns no donations. The order of these fields needs to be reversed, so that only the counties in the selected state are shown and this would match how Advanced Search works.
![image](/uploads/c3a5ae49d598a698df9d6423298decba/image.png)
Revised order:
1. Country
1. State/Province
1. Countyhttps://lab.civicrm.org/dev/core/-/issues/2557Add hook support for Report tabs.2023-08-06T05:03:24ZyashodhaAdd hook support for Report tabs.Add hook support for Report tabs.Add hook support for Report tabs.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2526Misleading error message about permissions when CiviReport disabled2023-07-27T05:03:20ZphilmckMisleading error message about permissions when CiviReport disabledOverview
----------------------------------------
If the CiviReport component is disabled (System Settings > Components) and you try to view the result of a completed mailing (Mailings > Scheduled and Sent Mailings > [Choose mailing] > R...Overview
----------------------------------------
If the CiviReport component is disabled (System Settings > Components) and you try to view the result of a completed mailing (Mailings > Scheduled and Sent Mailings > [Choose mailing] > Report > [Various "Report" links]) a misleading error message "You do not have permission to access this page" is displayed. The error log in /wp-content/uploads/civicrm/ConfigAndLog/ shows a fatal error with a CRM_Core_Error::handleUnhandledException but no clue as to the origin.
Reproduction steps
----------------------------------------
1. Disable the CiviReport component at System Settings > Components
2. Choose a completed mailing in Mailings > Scheduled and Sent Mailings and click "Report"
3. Select any of the "Report" links (e.g. for Click-throughs)
4. Error "You do not have permission to access this page" is displayed.
Current behaviour
----------------------------------------
Error "You do not have permission to access this page" is displayed. Log shows CRM_Core_Error::handleUnhandledException.
Expected behaviour
----------------------------------------
This exception is nothing to do with permissions - I wasted an hour or so checking all the permissions settings and googling for previous reports and I'm sure I'm not the only one. I was logged in as an Administrator and so permissions shouldn't have been an issue and I wouldn't expect an Administrator or Super User to ever see that message.
I would expect a more informative error message about the disabled ~~CviRules~~ CiviReport component. Even better, the "Report" links could be disabled and replaced with help information if the required component is not enabled. In addition, it should be impossible to disable the component if core functionality depends on it.
Environment information
----------------------------------------
* __Browser:__ Chrome 89
* __CiviCRM:__ 5.36.0
* __PHP:__ 7.4
* __CMS:__ WordPress 5.7
* __Database:__ MariaDB 10.4.18
* __Web Server:__ Apache 2.4.46https://lab.civicrm.org/dev/core/-/issues/2472DB error on Contribution Details2023-07-11T05:03:29ZyashodhaDB error on Contribution DetailsSteps to replicate :
- Go to _Contribution Details_
- In sorting tab, set _Contribution Status_ asc/dsc and in filter _Contribution OR Soft Credit?_ to _Both_
![Screenshot_from_2021-03-23_10_26_02](/uploads/2f0ba79c0657555c06f73db79acf8...Steps to replicate :
- Go to _Contribution Details_
- In sorting tab, set _Contribution Status_ asc/dsc and in filter _Contribution OR Soft Credit?_ to _Both_
![Screenshot_from_2021-03-23_10_26_02](/uploads/2f0ba79c0657555c06f73db79acf8397/Screenshot_from_2021-03-23_10_26_02.png)
![Screenshot_from_2021-03-23_10_26_17](/uploads/09810cb980275a522883f17fe43297f2/Screenshot_from_2021-03-23_10_26_17.png)
- Run the report, and DB error appears!
![error](/uploads/3ab78a1a830f1076bd8aca48c21f76e4/error.png)https://lab.civicrm.org/dev/core/-/issues/2441Print Report from Manage Case for closed cases doesn't show roles properly2023-07-06T05:03:18ZDaveDPrint Report from Manage Case for closed cases doesn't show roles properlyIt's not identical to https://lab.civicrm.org/dev/core/-/issues/1948 but might be the same underlying reason.
1. Create a case.
2. Add some roles.
3. Close the Case.
4. Choose Print Report on Manage Case.
5. Look at the roles near the t...It's not identical to https://lab.civicrm.org/dev/core/-/issues/1948 but might be the same underlying reason.
1. Create a case.
2. Add some roles.
3. Close the Case.
4. Choose Print Report on Manage Case.
5. Look at the roles near the top - they should be there.
Ditto for the Activity Audit which is the same codebase as Print Report.https://lab.civicrm.org/dev/core/-/issues/2445Soft Credit Type does not display in Contribution Detail report2023-07-05T05:03:18ZyashodhaSoft Credit Type does not display in Contribution Detail reportThe value for _Soft Credit Type_ is missing in _Contribution Detail_ report.
![missing_soft_credit_type](/uploads/3b85264817fa79fe1c993ec4a0de80eb/missing_soft_credit_type.png)The value for _Soft Credit Type_ is missing in _Contribution Detail_ report.
![missing_soft_credit_type](/uploads/3b85264817fa79fe1c993ec4a0de80eb/missing_soft_credit_type.png)yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2376Related Contributions for recurring contributions not sorted on date2023-06-26T05:03:16ZyashodhaRelated Contributions for recurring contributions not sorted on dateSteps to replicate :
- Go to Recurring Contributions tab for a contact with recurring contributions in place.
- Click _View_ for Recurring Contribution
- Go to _Related Contributions_ section and click the _Received_ column header.
- I...Steps to replicate :
- Go to Recurring Contributions tab for a contact with recurring contributions in place.
- Click _View_ for Recurring Contribution
- Go to _Related Contributions_ section and click the _Received_ column header.
- It is sorted on alphabetic order not date
![related_recurring](/uploads/6e6e03467a8aa3417f9d3c372d6adf63/related_recurring.png)https://lab.civicrm.org/dev/core/-/issues/2373Membership Details report, Net Amount returns null value instead of the most ...2023-06-22T05:03:29Zjustinfreeman (Agileware)Membership Details report, Net Amount returns null value instead of the most recent Contribution for the Membership renewalMembership Details report, Net Amount returns null value instead of the most recent Contribution for the Membership renewal
Steps to reproduce
1. Locate an existing Contact with a membership, eg. "Dr. Jacob Terrell-Terry Sr." https://dm...Membership Details report, Net Amount returns null value instead of the most recent Contribution for the Membership renewal
Steps to reproduce
1. Locate an existing Contact with a membership, eg. "Dr. Jacob Terrell-Terry Sr." https://dmaster.demo.civicrm.org/civicrm/contact/view?reset=1&cid=33
2. Renew the membership and enter in a contribution amount, $150
3. Save the contribution
4. Open the Membership Details report, https://dmaster.demo.civicrm.org/civicrm/report/instance/23
5. Display column: Net Amount
6. Set Contact filter to locate the contact, eg. Terrell
7. Report displays null value for Net Amount column
8. Expected result is Net Value shows $150
As verified on CiviCRM 5.36.alpha1 - https://dmaster.demo.civicrm.org
Agileware Ref: CIVICRM-1663
![Screenshot_20210209_150213](/uploads/862ae11ddee4eb3319584e94295c1eba/Screenshot_20210209_150213.png)
![screencapture-dmaster-demo-civicrm-org-civicrm-report-instance-23-2021-02-09-15_05_16](/uploads/04b31b801b212d1777de30036d0cec3e/screencapture-dmaster-demo-civicrm-org-civicrm-report-instance-23-2021-02-09-15_05_16.png)https://lab.civicrm.org/dev/core/-/issues/2374Membership Details report, "Payment Amount (most recent)" returns total amoun...2023-06-22T05:03:29Zjustinfreeman (Agileware)Membership Details report, "Payment Amount (most recent)" returns total amount for all membership contributions instead of the most recent Contribution for the Membership renewalMembership Details report, "Payment Amount (most recent)" returns total amount for all membership contributions instead of the most recent Contribution for the Membership renewal.
Steps to reproduce
1. Locate an existing Contact with a ...Membership Details report, "Payment Amount (most recent)" returns total amount for all membership contributions instead of the most recent Contribution for the Membership renewal.
Steps to reproduce
1. Locate an existing Contact with a membership, eg. "Dr. Jacob Terrell-Terry Sr." https://dmaster.demo.civicrm.org/civicrm/contact/view?reset=1&cid=33
2. Renew the membership and enter in a contribution amount, $150
3. Save the contribution
4. Open the Membership Details report, https://dmaster.demo.civicrm.org/civicrm/report/instance/23
5. Display column: "Payment Amount (most recent)"
6. Set Contact filter to locate the contact, eg. Terrell
7. Report displays $250 value for "Payment Amount (most recent)" column
8. Expected result is "Payment Amount (most recent)" shows $150 (not the combined total)
It is also confusing to label the column "Payment Amount (most recent)" and then in the results show the column as "Amount".
As verified on CiviCRM 5.36.alpha1 - https://dmaster.demo.civicrm.org
Agileware Ref: CIVICRM-1664
![Screenshot_20210209_150213](/uploads/e07371ce892ad94af4a09ab08feacd11/Screenshot_20210209_150213.png)
![screencapture-dmaster-demo-civicrm-org-civicrm-report-instance-23-2021-02-09-15_05_16](/uploads/e6ddeaa2622029cf9cb272acac074a34/screencapture-dmaster-demo-civicrm-org-civicrm-report-instance-23-2021-02-09-15_05_16.png)https://lab.civicrm.org/dev/core/-/issues/2338Wrong result in Next Payment Due column from Pledged But not Paid report2023-06-18T05:03:22ZyashodhaWrong result in Next Payment Due column from Pledged But not Paid report_Next Payment Due_ column from _Pledged But not Paid_ report doesn't show consistent results._Next Payment Due_ column from _Pledged But not Paid_ report doesn't show consistent results.https://lab.civicrm.org/dev/core/-/issues/2283Use nicer report layout on install2023-06-10T05:03:21ZeileenUse nicer report layout on installwhen civicrm is installed there is a very flat menu layout for reports like this
![defaultmenu](/uploads/05d41b8b50a4bca6f06a68477f0cde39/defaultmenu.png)
There is an api call (Navigation.reset) exposed on civicrm/admin/menu?reset=1 th...when civicrm is installed there is a very flat menu layout for reports like this
![defaultmenu](/uploads/05d41b8b50a4bca6f06a68477f0cde39/defaultmenu.png)
There is an api call (Navigation.reset) exposed on civicrm/admin/menu?reset=1 that fixes it to live in submenus like
![organisedmenu](/uploads/cc3baf0280b46dc945d8046ef6200e63/organisedmenu.png)
At the time the function was added it was hoped it would be run on install - but we never figured out how. Due to the interaction between the ids of the reports and the navigation menu it did not seem feasible to hard code the menu structure into the sql. @totten - I wonder if adding an api call on install would be more do-able now?https://lab.civicrm.org/dev/core/-/issues/2274Feature request: Include a "Aggregate Amount Filter" for "Top donor" report2023-06-08T05:03:23ZtapashFeature request: Include a "Aggregate Amount Filter" for "Top donor" reportI think the report does what it should but I was think would be a great addition to include a "Aggregate Amount Filter" for "Top donor" report.I think the report does what it should but I was think would be a great addition to include a "Aggregate Amount Filter" for "Top donor" report.https://lab.civicrm.org/dev/core/-/issues/2104Add more columns for Activity Report2023-05-03T05:47:11ZyashodhaAdd more columns for Activity ReportAdd more columns for Activity Report e,g target related fields currently it is showing target name and email only.Add more columns for Activity Report e,g target related fields currently it is showing target name and email only.5.62.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1839Notice error Contribution Aggregate by Relationship report2023-03-29T05:03:21ZJoeMurrayNotice error Contribution Aggregate by Relationship reportOn dmaster just now (5.28.alpha1):
Notice: Undefined variable: entryFound in CRM_Report_Form_Contribute_History->alterDisplay() (line 842 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Report/Form/Contribute/History.php).On dmaster just now (5.28.alpha1):
Notice: Undefined variable: entryFound in CRM_Report_Form_Contribute_History->alterDisplay() (line 842 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Report/Form/Contribute/History.php).https://lab.civicrm.org/dev/core/-/issues/4106Add filter on pledge payment in contribution report templates2023-02-28T06:44:39ZyashodhaAdd filter on pledge payment in contribution report templates Add a filter on "contribution is a pledge payment Yes/No" in contribution report templates Add a filter on "contribution is a pledge payment Yes/No" in contribution report templatesyashodhayashodhahttps://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/1575Error DB: No such field - Contribution Summary Report2023-02-08T05:03:15ZCésarError DB: No such field - Contribution Summary ReportOverview
----------------------------------------
Hello,
When try to use report contribution summary with col "Soft Credit Amount Stats" and add any filter of contribution stats ex: Cotribution Count "total_count_value" the report show e...Overview
----------------------------------------
Hello,
When try to use report contribution summary with col "Soft Credit Amount Stats" and add any filter of contribution stats ex: Cotribution Count "total_count_value" the report show error: "DB Error: no such field".
Maybe we dont use this filters when use this col, but I think is a error.
Reproduction steps
----------------------------------------
1. Create a report "Contribution Summary Report "
2. Select col: "Soft Credit Amount Stats"
3. Add filter: "Contribution Count" > 1 for example
Comments
----------------------------------------
Tested on dmaster: https://dmaster.demo.civicrm.org/
* Report breaks in this point of code: https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/Summary.php#L664
* I think because the query only have a cols for stats of soft credits: https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/Summary.php#L635https://lab.civicrm.org/dev/core/-/issues/1110Contribution Summary Report does not update the Total Amount and Total Contri...2023-02-08T05:03:14ZCésarContribution Summary Report does not update the Total Amount and Total Contributions with some filtersHello,
In contribution summary report doesn't update the total amount and total contributions in statistics with this filters:
- total_amount_value
- non_deductible_amount_value
- total_sum_value
- total_avg_value
- total_count_value
...Hello,
In contribution summary report doesn't update the total amount and total contributions in statistics with this filters:
- total_amount_value
- non_deductible_amount_value
- total_sum_value
- total_avg_value
- total_count_value
Other filters are working good and show correct statistics based in final expected result.
Im testing this report on 5.15.1https://lab.civicrm.org/dev/core/-/issues/1439No way to identify 'deceased' contacts when viewing or reporting on relations...2023-01-15T05:03:21Zellen_compucorpNo way to identify 'deceased' contacts when viewing or reporting on relationshipsOverview
----------------------------------------
Marking a contact record as 'is_deceased' doesn't currently appear to have any impact on the contact's relationships, which makes sense overall (for example, if a contact was marked as de...Overview
----------------------------------------
Marking a contact record as 'is_deceased' doesn't currently appear to have any impact on the contact's relationships, which makes sense overall (for example, if a contact was marked as deceased and then a scheduled job were to automatically expire all it's relationships, it would be very manual and annoying to reverse that if 'is_deceased' had been added by accident. However, it would be extremely useful (a) when viewing relationships on contact records and (b) when reporting on relationships, to know whether one of the contacts involved in the relationship is deceased.
Example use-case
----------------------------------------
On a contact record:
1. Create a contact (contact A)
1. Add a relationship to another contact (contact B)
1. Mark contact A as deceased
1. View relationships tab on contact record for contact B
Within reports:
1. Go to create new relationships report (/civicrm/report/instance/5?reset=1&output=criteria)
1. View columns/ filters tabs; no configurations available relating to 'is_deceased'
Current behaviour
----------------------------------------
On a contact record:
- No change to relationship (or relationship display) when one of the contacts is marked as deceased
Within reports:
- As described above
Proposed behaviour
----------------------------------------
On a contact record:
- Propose that - on the relationships tab of the contact record - after the name of the contact that is deceased is added in red "(deceased)" in the same way that it is added next to the main display name at the top of the contact record for a deceased contact currently.
![3DC980F2-DC13-440B-A9D3-6875552B2006](/uploads/fb62f7fa05eeaa9002a9298cff5813d5/3DC980F2-DC13-440B-A9D3-6875552B2006.png)
On reports:
- Propose that a filter is added so that 'deceased' contacts can be excluded from relationships reports
Comments
----------------------------------------https://lab.civicrm.org/dev/core/-/issues/1419Cannot sort membership reports by membership start/end/join2023-01-11T05:03:27ZCoreyBurgerCannot sort membership reports by membership start/end/joinI cannot sort my expired membership report by expiry date, the only column I have is "Date Received". Membership reports should be able to be sorted by Start Date, End Date and Join DateI cannot sort my expired membership report by expiry date, the only column I have is "Date Received". Membership reports should be able to be sorted by Start Date, End Date and Join Date