Reports dont display dates

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi all, I’ve just upgraded from CE 6.1.5 to SuiteCRM and I’m testing some of the additional functionality. I’ve added a few invoices and then tried to run a report however I cant get the report to display / filter or sort on date.

If I add a date field it just shows as blank and if i try to sort or filter the the entire report comes up blank.

Hope someone can help.

Cheers

Rob

2

can you post a screen shot of your edit view in the report, or post your exact set-up of the report

3

Hi Matt, thanks for getting back to me. Screen grab attached, and I suppose I should have mentioned I’m using MS SQL 2008 for the Db.

Cheers
Rob

4

this is a bug in the reports when using mssql

to fix try editing the file ‘modules/AOR_Reports/aor_utils.php’

on line 337 where it says:-

$fieldlist[$fieldname]['value'] = $timedate->to_display_date($value);

add in the following line so it becomes:-

$value = $focus->convertField($value, $fieldlist[$fieldname]);
$fieldlist[$fieldname]['value'] = $timedate->to_display_date($value);

thanks for highlighting this issue

1 Like
5

Thats great Matt thankyou, that cured the issue with dates displaying. Also to display fields that are date & time also add at line 334:

$value = $focus->convertField($value, $fieldlist[$fieldname]);

to show :

$value = $focus->convertField($value, $fieldlist[$fieldname]); 
$fieldlist[$fieldname]['value'] = $timedate->to_display_date_time($value, true, true);

I am still having a problem with sorting / grouping / functions though? If I try and use any of this functionality i just end up with a blank report … any ideas?

Thanks agaib.

Rob

6

Hi Matt (or anyone else), is there any more information on my sorting & grouping issue in reports?

Cheers

Rob