# KReporter **URL:** https://community.spicecrm.io/c/kreporter/6.md?page=1 [Latest](https://community.spicecrm.io/latest.md) · [Categories](https://community.spicecrm.io/categories.md) **Page:** 2 --- ## [The browser console error - cannot display table](https://community.spicecrm.io/t/the-browser-console-error-cannot-display-table/710)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [December 22, 2023, 2:29pm UTC](https://community.spicecrm.io/t/the-browser-console-error-cannot-display-table/710 "2023-12-22T14:29:30Z")
When we save a report, we are not getting a presentation table. The browser console error is as below. kreportsbase1.js:1 Uncaught TypeError: Cannot read properties of undefined (reading 'k247c9b9c86afc91918c6c63c05d6'… --- ## [KReporter Plugin for SuiteCRM](https://community.spicecrm.io/t/kreporter-plugin-for-suitecrm/704)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 4\ **Last updated:** [December 14, 2023, 8:04pm UTC](https://community.spicecrm.io/t/kreporter-plugin-for-suitecrm/704 "2023-12-14T20:04:01Z")
Hello Team, Could you please create the KReporter Plugin/add-on for the SuiteCRM versions? --- ## [Browser console error when hover over table in edit view](https://community.spicecrm.io/t/browser-console-error-when-hover-over-table-in-edit-view/705)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 2\ **Last updated:** [December 11, 2023, 2:28pm UTC](https://community.spicecrm.io/t/browser-console-error-when-hover-over-table-in-edit-view/705 "2023-12-11T14:28:08Z")
Hello, I am getting the below console error when hover on table in manipulate tab when I am in edit view of KReports. Uncaught TypeError: Cannot read properties of undefined (reading 'getLeft') at i.isOnLeftEdge (e… --- ## [Filters in custom functions?](https://community.spicecrm.io/t/filters-in-custom-functions/48)
**Author:** [@ralph](https://community.spicecrm.io/u/ralph)\ **Replies:** 10\ **Last updated:** [December 10, 2023, 2:27pm UTC](https://community.spicecrm.io/t/filters-in-custom-functions/48 "2023-12-10T14:27:00Z")
Is it possible to use the fieldname reference created in a filters (select section) in a custom function of a field (manipulate section)? --- ## [Kreport Plugin PDF](https://community.spicecrm.io/t/kreport-plugin-pdf/287)
**Author:** [@caiocarvalho](https://community.spicecrm.io/u/caiocarvalho)\ **Replies:** 3\ **Last updated:** [November 17, 2023, 3:29pm UTC](https://community.spicecrm.io/t/kreport-plugin-pdf/287 "2023-11-17T15:29:14Z")
Hello, Everyone! I know that this isn’t the place to do this question, but I didn’t have answer for another channel. could we tell me how I buy the plugin to export in PDF? and How much is it? best regards, Caio Carv… --- ## [After Installation I get a blank page for Kreport 4.2](https://community.spicecrm.io/t/after-installation-i-get-a-blank-page-for-kreport-4-2/279)
**Author:** [@mirco\_cervi](https://community.spicecrm.io/u/mirco_cervi)\ **Replies:** 21\ **Last updated:** [November 17, 2023, 2:00pm UTC](https://community.spicecrm.io/t/after-installation-i-get-a-blank-page-for-kreport-4-2/279 "2023-11-17T14:00:29Z")
After a good installation of KREST API (I have positive veryfication of API) I try to create a report and I have a blank screen (png here attached) \[03\] in LINUX with |Apache | 2.4.29| |PHP | 5.6.33| |MySQL | 5.6.… --- ## [Kreporter Suitecrm](https://community.spicecrm.io/t/kreporter-suitecrm/277)
**Author:** [@jrivas3](https://community.spicecrm.io/u/jrivas3)\ **Replies:** 11\ **Last updated:** [November 15, 2023, 7:33pm UTC](https://community.spicecrm.io/t/kreporter-suitecrm/277 "2023-11-15T19:33:28Z")
Hello. How are you? First of all, congratulations for this project works very well. I have always used KREPORTER in SUITECRM and it works very well. However in the last versions of Suitecrm I have had problems and I ha… --- ## [SuiteCRM 7.13.4 and KReporter V3.1 | SuiteCRM 8.x and KReporter x.x](https://community.spicecrm.io/t/suitecrm-7-13-4-and-kreporter-v3-1-suitecrm-8-x-and-kreporter-x-x/702)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 4\ **Last updated:** [October 15, 2023, 10:10pm UTC](https://community.spicecrm.io/t/suitecrm-7-13-4-and-kreporter-v3-1-suitecrm-8-x-and-kreporter-x-x/702 "2023-10-15T22:10:33Z")
I am learning SuiteCRM and KReporter and totally new to these things. Is it possible to use KReporter V3.1 with SuiteCRM 7.13.4? System config: Ubuntu 22.04, nginx 1.18.0 and PHP 7.4 Could we add legend to KRepor… --- ## [Kreport guidance](https://community.spicecrm.io/t/kreport-guidance/614)
**Author:** [@agondar](https://community.spicecrm.io/u/agondar)\ **Replies:** 5\ **Last updated:** [October 10, 2023, 2:27pm UTC](https://community.spicecrm.io/t/kreport-guidance/614 "2023-10-10T14:27:38Z")
We have subscribed “SuiteCRM on-demand” service: Can you tell me the link where I can download the KReporter module? I would appreciate some guidance on the steps to need to successfully install KReporter (what steps a… --- ## [KReport Pivot Sorting on Total](https://community.spicecrm.io/t/kreport-pivot-sorting-on-total/631)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 2:24pm UTC](https://community.spicecrm.io/t/kreport-pivot-sorting-on-total/631 "2022-02-01T14:24:45Z")
Hi @maretval The pivot table does not allow sorting on “total” or “group of month total”. We want to sort on “September”. “October”, “November”, & “Total”. Regards, Asif Khalyani www.offshoreevolution.com --- ## [KReport Add new Scheduler lost existing](https://community.spicecrm.io/t/kreport-add-new-scheduler-lost-existing/632)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 0\ **Last updated:** [December 14, 2021, 8:07am UTC](https://community.spicecrm.io/t/kreport-add-new-scheduler-lost-existing/632 "2021-12-14T08:07:09Z")
HI @maretval I am updating the existing KReport and I append a new row of scheduler action but I lost the existing row and overwritten it with a new row. After appending the new row How can I add a third line wit… --- ## [Site cannot be Reached CSV export](https://community.spicecrm.io/t/site-cannot-be-reached-csv-export/254)
**Author:** [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Replies:** 11\ **Last updated:** [October 18, 2021, 8:24am UTC](https://community.spicecrm.io/t/site-cannot-be-reached-csv-export/254 "2021-10-18T08:24:05Z")
when trying to export to CSV i get "site cannot be reached" below is the error log , do you have any ideas? \[20-Feb-2018 14:43:39 Europe/London\] PHP Fatal error: Uncaught Error: \[\] operator not supported for strings i… --- ## [KReport changing filter does not refresh charts](https://community.spicecrm.io/t/kreport-changing-filter-does-not-refresh-charts/624)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 8\ **Last updated:** [September 28, 2021, 9:06am UTC](https://community.spicecrm.io/t/kreport-changing-filter-does-not-refresh-charts/624 "2021-09-28T09:06:45Z")
Hi @maretval I am creating the report on a filter of a specific value of Introduction and its editable filter in Report. Now, I filter value change and get the new data from the data display but does not affect the … --- ## [KReport Bar Chart Sorting Issue](https://community.spicecrm.io/t/kreport-bar-chart-sorting-issue/621)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 7\ **Last updated:** [September 27, 2021, 2:42pm UTC](https://community.spicecrm.io/t/kreport-bar-chart-sorting-issue/621 "2021-09-27T14:42:28Z")
Hi, I have one dropdown field of “Office”. It displays the value as text and DB stores the value integer. How it’s possible to sort on DB value instead of display value. Drop Down of Office DB Value ::: Display Value … --- ## [Column names are not displayed when we try editing kreport](https://community.spicecrm.io/t/column-names-are-not-displayed-when-we-try-editing-kreport/619)
**Author:** [@RohitN](https://community.spicecrm.io/u/RohitN)\ **Replies:** 3\ **Last updated:** [September 8, 2021, 8:03am UTC](https://community.spicecrm.io/t/column-names-are-not-displayed-when-we-try-editing-kreport/619 "2021-09-08T08:03:17Z")
Hi, The issue is on kreport v4.2 when the report is created for Grant or representative module, on the creation it shows the column/fields on that module, But when tried editing the newly created report the fields are n… --- ## [Export based Search/filter on record view of Kreport](https://community.spicecrm.io/t/export-based-search-filter-on-record-view-of-kreport/620)
**Author:** [@RohitN](https://community.spicecrm.io/u/RohitN)\ **Replies:** 1\ **Last updated:** [August 19, 2021, 1:37pm UTC](https://community.spicecrm.io/t/export-based-search-filter-on-record-view-of-kreport/620 "2021-08-19T13:37:55Z")
Hi, I’m facing an issue on Kreport v4.2, When search/filter is modified on the record view of Kreport and try to export(based on new filter added on record view), its get all record in CSV which based on original search… --- ## [KReport Treeview of showing all items](https://community.spicecrm.io/t/kreport-treeview-of-showing-all-items/617)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 0\ **Last updated:** [August 5, 2021, 6:17am UTC](https://community.spicecrm.io/t/kreport-treeview-of-showing-all-items/617 "2021-08-05T06:17:24Z")
Hi, I have made one KReport Treeview report for Account of Quote count, a sum of the total, and a sum of the subtotal. Choose the main module as Account and select fields are Account Name, Quote Title Count, Quote tota… --- ## [KReport detail page does not load report](https://community.spicecrm.io/t/kreport-detail-page-does-not-load-report/599)
**Author:** [@offshoreevolution](https://community.spicecrm.io/u/offshoreevolution)\ **Replies:** 15\ **Last updated:** [April 15, 2021, 11:12am UTC](https://community.spicecrm.io/t/kreport-detail-page-does-not-load-report/599 "2021-04-15T11:12:35Z")
I have the pro version of KReprot. It is working fine on the Edit page but when I am saving the report and redirect to the detail page but the report does not load. There is no error in the error log or SuiteCRM log … --- ## [Problem with Presentation Drilldown Link vs Popup](https://community.spicecrm.io/t/problem-with-presentation-drilldown-link-vs-popup/595)
**Author:** [@dianna](https://community.spicecrm.io/u/dianna)\ **Replies:** 6\ **Last updated:** [February 27, 2021, 9:32pm UTC](https://community.spicecrm.io/t/problem-with-presentation-drilldown-link-vs-popup/595 "2021-02-27T21:32:49Z")
We are using KReports version 3.1 (licensed) in SuiteCRM and have been having a problem with our drilldown report that used to be working just fine. Our drilldown is set as a link and when we select the drilldown report … --- ## [Is Between datetime filter not working when you edit it](https://community.spicecrm.io/t/is-between-datetime-filter-not-working-when-you-edit-it/584)
**Author:** [@chrislynch8](https://community.spicecrm.io/u/chrislynch8)\ **Replies:** 1\ **Last updated:** [February 3, 2021, 8:34pm UTC](https://community.spicecrm.io/t/is-between-datetime-filter-not-working-when-you-edit-it/584 "2021-02-03T20:34:27Z")
Hi, We have report with an Is Between filter defined in the setup. This filter is set as required and allow edit =yes. When the report runs the initial defined filter works, but when you change the filter values on the … --- ## [Report Does not run](https://community.spicecrm.io/t/report-does-not-run/558)
**Author:** [@BMKN](https://community.spicecrm.io/u/BMKN)\ **Replies:** 7\ **Last updated:** [November 20, 2020, 11:44am UTC](https://community.spicecrm.io/t/report-does-not-run/558 "2020-11-20T11:44:44Z")
Hi, We have a report and when you use Search/Filter Criteria = Date - “Is Between” - From = 22/10/2020 - To = 02/11/2020 When you input the above data the report does not run. Any help is appreciated. --- ## [Retrieving relationship modules from the same module](https://community.spicecrm.io/t/retrieving-relationship-modules-from-the-same-module/556)
**Author:** [@albertostic](https://community.spicecrm.io/u/albertostic)\ **Replies:** 3\ **Last updated:** [November 2, 2020, 3:22pm UTC](https://community.spicecrm.io/t/retrieving-relationship-modules-from-the-same-module/556 "2020-11-02T15:22:01Z")
Hi, When we have a relationship within the same module and try to create a report based on that module, we can’t list the modules related when it is the second level relationship of that module. Here an screenshot (“Pe… --- ## [Sort by Quarter not available v4.2](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541)
**Author:** [@ConstPan](https://community.spicecrm.io/u/ConstPan)\ **Replies:** 3\ **Last updated:** [October 7, 2020, 12:56pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541 "2020-10-07T12:56:37Z")
Hi team, we had a report that included a formula and would split all open opps into quarters. I can’t find the option Quarter in my report, only date. How can I group these by Quarter ? Is it simply adding a formula like… --- ## [Kreporter 3.1 and Security Groups filtering records](https://community.spicecrm.io/t/kreporter-3-1-and-security-groups-filtering-records/527)
**Author:** [@albertostic](https://community.spicecrm.io/u/albertostic)\ **Replies:** 4\ **Last updated:** [September 11, 2020, 6:42pm UTC](https://community.spicecrm.io/t/kreporter-3-1-and-security-groups-filtering-records/527 "2020-09-11T18:42:54Z")
HI, I’m trying to install Kreporter 3.1 in SuiteCRM 7.10 and make it work with native modules of Security Suite. I had to do some little modifications for it to work with PHP 7.3. In addition of these little modificati… --- ## [Kreporter 3.1 is no longer displaying Google Charts](https://community.spicecrm.io/t/kreporter-3-1-is-no-longer-displaying-google-charts/525)
**Author:** [@dianna](https://community.spicecrm.io/u/dianna)\ **Replies:** 9\ **Last updated:** [June 17, 2020, 8:52pm UTC](https://community.spicecrm.io/t/kreporter-3-1-is-no-longer-displaying-google-charts/525 "2020-06-17T20:52:46Z")
We have a license for 3.1 extension and have noticed recently that are charts aren’t always displaying and now not at all. We are using Kreporter with Suitecrm 7.8.31. I see this error in the console log and wonder if y… --- ## [D3 v3 is going to be deleted](https://community.spicecrm.io/t/d3-v3-is-going-to-be-deleted/521)
**Author:** [@MayerElyashiv](https://community.spicecrm.io/u/MayerElyashiv)\ **Replies:** 2\ **Last updated:** [May 21, 2020, 7:48am UTC](https://community.spicecrm.io/t/d3-v3-is-going-to-be-deleted/521 "2020-05-21T07:48:50Z")
Hi, with KReporter v. 4.2 as soon as i try to show Google Chart Graphs i get an alert saying: with D3 v3 is going to be deleted. Please migrate to v4 ASAP. See go/d3v4 for details and resources on migration. What hav… --- ## [Does Kreporter 4 supports SugarCRM 6.5?](https://community.spicecrm.io/t/does-kreporter-4-supports-sugarcrm-6-5/523)
**Author:** [@Rcabarubias](https://community.spicecrm.io/u/Rcabarubias)\ **Replies:** 1\ **Last updated:** [May 12, 2020, 6:25pm UTC](https://community.spicecrm.io/t/does-kreporter-4-supports-sugarcrm-6-5/523 "2020-05-12T18:25:39Z")
I am using Kreporter 3 as of the momebt in sugar 6. And I am olaning to upgrade to Kreporter 4. My question is, does kreporter 4 will work on sugarcrm 6.5? Has anyone tried it? Thanks --- ## [Union Module - Companies and Opportunities](https://community.spicecrm.io/t/union-module-companies-and-opportunities/518)
**Author:** [@Alberto](https://community.spicecrm.io/u/Alberto)\ **Replies:** 1\ **Last updated:** [March 23, 2020, 4:31pm UTC](https://community.spicecrm.io/t/union-module-companies-and-opportunities/518 "2020-03-23T16:31:27Z")
Hi, I need a report thaht unions the companies module and opportunities module exist in the same report. How can i see how many and which companies converted by a single leads souce. For Example, with this view: Comp… --- ## [Periodic failure of KReporter displaying reports](https://community.spicecrm.io/t/periodic-failure-of-kreporter-displaying-reports/388)
**Author:** [@jonnie00](https://community.spicecrm.io/u/jonnie00)\ **Replies:** 20\ **Last updated:** [February 5, 2020, 8:48am UTC](https://community.spicecrm.io/t/periodic-failure-of-kreporter-displaying-reports/388 "2020-02-05T08:48:59Z")
I have a recurring issue with KReporter which I can only solve by conducting a repair/rebuild of the database. Every few days when you run a KReport the screen does not load the report data. I cannot work out what migh… --- ## [Pivot/Tree table reports not showing](https://community.spicecrm.io/t/pivot-tree-table-reports-not-showing/481)
**Author:** [@tessupport](https://community.spicecrm.io/u/tessupport)\ **Replies:** 2\ **Last updated:** [February 5, 2020, 8:33am UTC](https://community.spicecrm.io/t/pivot-tree-table-reports-not-showing/481 "2020-02-05T08:33:02Z")
Hi, We recently upgraded our PHP to 7.2, running SuiteCRM v. 7.8.17. Pivot table report section just spins (loading presentation), but the graph shows correct data. Tree reports show no data, no spinning (just blank),… [Previous page](https://community.spicecrm.io/c/kreporter/6.md) [Next page](https://community.spicecrm.io/c/kreporter/6.md?page=2)