# KReporter **URL:** https://community.spicecrm.io/c/kreporter/6.md [Latest](https://community.spicecrm.io/latest.md) · [Categories](https://community.spicecrm.io/categories.md) --- ## [About the KReporter category](https://community.spicecrm.io/t/about-the-kreporter-category/12)
**Author:** [@spicecrm](https://community.spicecrm.io/u/spicecrm)\ **Replies:** 0
This category is for all issues related to Reporting and KReporter. --- ## [CustomFunction on the Date field](https://community.spicecrm.io/t/customfunction-on-the-date-field/798)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 5, 2026, 7:16pm UTC](https://community.spicecrm.io/t/customfunction-on-the-date-field/798 "2026-08-05T19:16:23Z")
Only Year DATE\_FORMAT({t}.{f}, '%Y') → Returns a 4-digit year (e.g., 2026). DATE\_FORMAT({t}.{f}, '%y') → Returns a 2-digit year (e.g., 26). YEAR({t}.{f}) → A direct alternative function to extract the year as a numeric … --- ## [CustomFunction to get Min](https://community.spicecrm.io/t/customfunction-to-get-min/797)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [June 24, 2026, 4:36pm UTC](https://community.spicecrm.io/t/customfunction-to-get-min/797 "2026-06-24T16:36:50Z")
If we want to get the MIN for field. Could we use the below in the customFunction column? MIN({t}.{f}) Or MIN({f}.FIELDNAME) --- ## [How to extract year & month from date](https://community.spicecrm.io/t/how-to-extract-year-month-from-date/716)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 11\ **Last updated:** [May 29, 2026, 3:37pm UTC](https://community.spicecrm.io/t/how-to-extract-year-month-from-date/716 "2026-05-29T15:37:13Z")
Hello, I have date field like 05/18/2018 09:12AM or 2023-10-03 18:11:08. I want to display only year out of it. I am using the below Formula on the manipulate screen. But it is not working. substr(0,4) substr(5,2) … --- ## [How to add the 365 days to date field](https://community.spicecrm.io/t/how-to-add-the-365-days-to-date-field/795)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [May 29, 2026, 3:36pm UTC](https://community.spicecrm.io/t/how-to-add-the-365-days-to-date-field/795 "2026-05-29T15:36:03Z")
We could use the below customFunction for date field. DATE\_ADD({t}.{f}, INTERVAL 365 DAY) --- ## [Calculate number of days in the KReport](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [May 27, 2026, 1:51pm UTC](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794 "2026-05-27T13:51:27Z")
Hello @maretval We want to calculate the number of days and display them in the columns of the KReport. We have Created Date and Modified Date fields in the record, and we want to know how many days have passed since t… --- ## [Display Full Name](https://community.spicecrm.io/t/display-full-name/790)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [March 9, 2026, 1:37pm UTC](https://community.spicecrm.io/t/display-full-name/790 "2026-03-09T13:37:35Z")
Hello, We have first name and last name of user, and it is store as FN & LN in the kreport. Now, we want to add new column which will display the FN LN in the output table. How to do it? Solution: In the formula col… --- ## [Truncating time off of Date Created field for Report](https://community.spicecrm.io/t/truncating-time-off-of-date-created-field-for-report/348)
**Author:** [@tessupport](https://community.spicecrm.io/u/tessupport)\ **Replies:** 2\ **Last updated:** [February 11, 2026, 10:18pm UTC](https://community.spicecrm.io/t/truncating-time-off-of-date-created-field-for-report/348 "2026-02-11T22:18:47Z")
Trying to create a report of contacts added last 7 days, grouped by day. Our Date Created field has a time stamp as well, so we get individual returns per time stamp, unless there was a dump of contacts at the same time… --- ## [Presentation drilldown](https://community.spicecrm.io/t/presentation-drilldown/788)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 3, 2025, 3:24pm UTC](https://community.spicecrm.io/t/presentation-drilldown/788 "2025-12-03T15:24:20Z")
We want to use presentation drilldown to get better understanding of the data. How to use it? What all report plugin supports it (standard view, group view)? --- ## [How to apply amount difference condition](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 9:21am UTC](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786 "2025-12-02T09:21:05Z")
@maretval How can we use amount difference condition in the report. For example, we have amount1 and amount 2. We want to display records where amount1 \< amount2. --- ## [How to filter negative records](https://community.spicecrm.io/t/how-to-filter-negative-records/787)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 9:18am UTC](https://community.spicecrm.io/t/how-to-filter-negative-records/787 "2025-12-02T09:18:23Z")
We have added custom row in kreport called Final Amount. We are doing field1 - field2 to calculate amount for Final Amount column. Now, we want to display only -negative values in the table. How to do it? --- ## [How to get year or month from field?](https://community.spicecrm.io/t/how-to-get-year-or-month-from-field/784)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 4\ **Last updated:** [November 3, 2025, 4:24pm UTC](https://community.spicecrm.io/t/how-to-get-year-or-month-from-field/784 "2025-11-03T16:24:50Z")
@maretval how to get the year or month out of date time field in the kreport. For example, the date field has value 10/20/2030 11:11pm. In the formula, column we tried to use the below but did not work. substr({Store… --- ## [Override the name](https://community.spicecrm.io/t/override-the-name/780)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [August 20, 2025, 9:02am UTC](https://community.spicecrm.io/t/override-the-name/780 "2025-08-20T09:02:40Z")
We have a kreport with the text field, it could have three values A,B & C. In visualize, we have Bar Chart & it is displaying the A, B & C as legend values & on the x-axis instead of that we want to display Apple, Banana… --- ## [How is current week determined for Select?](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367)
**Author:** [@tessupport](https://community.spicecrm.io/u/tessupport)\ **Replies:** 3\ **Last updated:** [August 18, 2025, 6:18am UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367 "2025-08-18T06:18:50Z")
We would like to run reports for Saturday at 12a to following Friday at 12:59p. Current Week filter seems to only pull from Monday - Sunday. Is there a way to change Current Date so we don’t have to edit a between filt… --- ## [Calculate number of days](https://community.spicecrm.io/t/calculate-number-of-days/776)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 18, 2025, 6:11am UTC](https://community.spicecrm.io/t/calculate-number-of-days/776 "2025-08-18T06:11:20Z")
Hello @maretval, :smiley: We have date created(mm/dd/yyy hh:mm AM/PM) and Completed Date (mm/dd/yyyy) formats in the Cases module. Now, we want to find the number of days between date created & completed date. How coul… --- ## [How to use Context and Reference?](https://community.spicecrm.io/t/how-to-use-context-and-reference/769)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 5\ **Last updated:** [August 18, 2025, 6:04am UTC](https://community.spicecrm.io/t/how-to-use-context-and-reference/769 "2025-08-18T06:04:04Z")
Hello @maretval, We want to use the Context and Reference fields in the kreport. But we do not know how to use them. Our requirement is that we want to display week value equal to zero when we do not have any reporting… --- ## [Merge two columns name in the chart legend](https://community.spicecrm.io/t/merge-two-columns-name-in-the-chart-legend/777)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 15, 2025, 2:28pm UTC](https://community.spicecrm.io/t/merge-two-columns-name-in-the-chart-legend/777 "2025-08-15T14:28:30Z")
Hello @maretval, We have kreport with the column chart & it has the legends in the side. We want to add new filed in report by using Formula (For example, {field1}.-.{field2}). The field1 are all numbers, but field2 h… --- ## [KReports 4.4 on SuiteCRM](https://community.spicecrm.io/t/kreports-4-4-on-suitecrm/768)
**Author:** [@ijdavie](https://community.spicecrm.io/u/ijdavie)\ **Replies:** 3\ **Last updated:** [June 20, 2025, 1:38pm UTC](https://community.spicecrm.io/t/kreports-4-4-on-suitecrm/768 "2025-06-20T13:38:20Z")
Hello, I am experencing some really odd pagination when I add more than one KReport to the dashboard on SuiteCRM.When we click next to get the next page of results it will jump page 2 and display page 3, this happens ea… --- ## [Showing results above certain values](https://community.spicecrm.io/t/showing-results-above-certain-values/728)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 5\ **Last updated:** [June 25, 2024, 7:52pm UTC](https://community.spicecrm.io/t/showing-results-above-certain-values/728 "2024-06-25T19:52:31Z")
Is it possible to use customFunction or formula on the amount column in the kreport? If yes, what will be the fuction? --- ## [Kreport error in the console](https://community.spicecrm.io/t/kreport-error-in-the-console/729)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [June 21, 2024, 8:13pm UTC](https://community.spicecrm.io/t/kreport-error-in-the-console/729 "2024-06-21T20:13:33Z")
We are getting kreport error in the console. kreportsbase1.js:1 Uncaught TypeError: Cannot read properties of undefined (reading 'k57d589071bdf9f4e47f66905d56b') at i.generateSummaryData (kreportsbase1.js:1:8254) … --- ## [Round upto 2 decimal points](https://community.spicecrm.io/t/round-upto-2-decimal-points/726)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [June 14, 2024, 6:55pm UTC](https://community.spicecrm.io/t/round-upto-2-decimal-points/726 "2024-06-14T18:55:57Z")
Hello, We have kreport with cost column. It is showign around 6 digits after decimal point. How could we round up to 2 decimal points in the report? --- ## [Google Maps issue](https://community.spicecrm.io/t/google-maps-issue/724)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [May 25, 2024, 7:12am UTC](https://community.spicecrm.io/t/google-maps-issue/724 "2024-05-25T07:12:47Z")
Hello, We have Google Maps under visualize in the KReporter. We have checked cluster pins option too, but it is not diplating any pins/toggles on the map. How to resolve this issue? Thanks! --- ## [The 'override Alignment' feature is not controlling the alignment](https://community.spicecrm.io/t/the-override-alignment-feature-is-not-controlling-the-alignment/725)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 1\ **Last updated:** [May 25, 2024, 7:11am UTC](https://community.spicecrm.io/t/the-override-alignment-feature-is-not-controlling-the-alignment/725 "2024-05-25T07:11:13Z")
I created a simple report and wanted to have control over the alignment of a column. Eg. I want to centre the ‘Project Component’ field after editing ‘Override Aligment’ and setting - ‘Center Align’ and SAVE, then t… --- ## [Consider a single amount while we have same record](https://community.spicecrm.io/t/consider-a-single-amount-while-we-have-same-record/723)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [April 24, 2024, 6:44pm UTC](https://community.spicecrm.io/t/consider-a-single-amount-while-we-have-same-record/723 "2024-04-24T18:44:59Z")
Hello all, We have an opportunity with two applications. We’re using Sum function in the report for the opportunity amount. So, it is displaying two records and multiplying the opportunity amount by twice. How could we… --- ## [KReportPresentationManager - an error on function display()](https://community.spicecrm.io/t/kreportpresentationmanager-an-error-on-function-display/718)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 5\ **Last updated:** [February 3, 2024, 1:27pm UTC](https://community.spicecrm.io/t/kreportpresentationmanager-an-error-on-function-display/718 "2024-02-03T13:27:36Z")
I am using kreporter 3.1 with PHP 7.4 Why I am getting the below error and what is solution for it? PHP Fatal error: Uncaught Error: Call to a member function display() on bool in /var/www/html/CRM/modules/KReports/KR… --- ## [We need so many videos on this channel about big K](https://community.spicecrm.io/t/we-need-so-many-videos-on-this-channel-about-big-k/717)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 3:13pm UTC](https://community.spicecrm.io/t/we-need-so-many-videos-on-this-channel-about-big-k/717 "2024-01-26T15:13:03Z")
Hello, We have videos on this channel but most of them have audio or video quality problem. Someone needs to create more videos on this channel and post them with best quality. Christian Knoll - YouTube :orange\_heart: … --- ## [Need documentation for KReporter](https://community.spicecrm.io/t/need-documentation-for-kreporter/715)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [January 10, 2024, 3:48pm UTC](https://community.spicecrm.io/t/need-documentation-for-kreporter/715 "2024-01-10T15:48:13Z")
Could anyone please share complete documentation of the KReporter? --- ## [Duplicate button not working](https://community.spicecrm.io/t/duplicate-button-not-working/714)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 4\ **Last updated:** [January 3, 2024, 8:51pm UTC](https://community.spicecrm.io/t/duplicate-button-not-working/714 "2024-01-03T20:51:50Z")
Hello, When I click on duplicate button of Kreporter. It is just showing a blank screen. --- ## [Installation issues KReporter 4.1](https://community.spicecrm.io/t/installation-issues-kreporter-4-1/19)
**Author:** [@spicecrm](https://community.spicecrm.io/u/spicecrm)\ **Replies:** 3\ **Last updated:** [December 27, 2023, 4:48pm UTC](https://community.spicecrm.io/t/installation-issues-kreporter-4-1/19 "2023-12-27T16:48:15Z")
with the release of KReporter 4.1 we also did release KREST 2.5.1. Unfortunately one file was missing in the KREST packae causing issues with KReporter. If you encounterd these issues (after installation and creation of … --- ## [KReport Knowledge Base](https://community.spicecrm.io/t/kreport-knowledge-base/519)
**Author:** [@MayerElyashiv](https://community.spicecrm.io/u/MayerElyashiv)\ **Replies:** 3\ **Last updated:** [December 22, 2023, 6:01pm UTC](https://community.spicecrm.io/t/kreport-knowledge-base/519 "2023-12-22T18:01:39Z")
Hi, is there any knowledge base abobut Kreport with a collection of the best examples? This guide: is still very useful… [Next page](https://community.spicecrm.io/c/kreporter/6.md?page=1)