Report Does not run

KReporter
1

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.

2

Brian,
What is your reporter version?
In which crm (sugar, suite CRM, spicecrm) in which version is it running?
Val

3

Hi

Version 4.2 and running with SugarCRM

Regards
Brian

4

SugarCRM CE? which version?

5

Hi,

** Sugar Version 6.5.24 (Build 509**

It is only an issue when the field is a date time. See screen shot below

screenshot_18
screenshot_181275×384 23.5 KB

6

I could’nt reproduce.
Is it a licensed KReporter version?
In that case please, turn on query analyzer (tab integrate).
Then view the report and get the query
grafik

Then post it

7

Hi this is a nonlicensed version and the Toolbar is greyed out

screenshot_6
screenshot_6900×244 6.93 KB

8

Ok Then catch the built:
open modules/KReports/KReport.php
find function getContextselectionResult
Scroll down to line 1260 or somewhere near 1260 ( I probably already debiugged some stuff in my version and added lines).

grafik
grafik977×383 48.5 KB

Add this code after the line:
$GLOBALS['log']->fatal('KReporterQuery = '.$query);
then save

Make sure your loglevel is set to fatal in config.php (or go to administration settings and set the parameter). I prefere to fatal in order to limit the amount of lines written in the log.

Call your report
Open sugacrm.log, you should see the query.
If you can run it directly to database, you shall see if it contains an error.
Or post-it here.