Reports with date parameters don't paginate

[MaxSantolo]

After the creation of a report with date parameters (like from - to) and using "value" as parameter so that the user can enter a specific date, and after adding a main grouping of the report based on a "feedback field": if one of the groups has more than 20 items clicking the paging results in empty group.

Expected Behavior

Pagination should show the next 20 group results.

Actual Behavior

Pagination shows empty list and disables pagination buttons.

Steps to Reproduce

1. Create a report with "from" and "to" value of date parameters
2. Group the report based on another field ("status" for example)
3. Choose the dates and activate the report: no pagination

Context

I need a report of leads grouped by feedback in a period of parametric dates (from - to)

Your Environment

• SuiteCRM Version used: 8.5
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Chrome and Firefox
• Environment name and version (e.g. MySQL, PHP 7): PHP 8.1, MariaDb
• Operating System and version (e.g Ubuntu 16.04): Debian 11

[serhiisamko091184]

Hello @MaxSantolo,

thanks for raising the issue,

I'm afraid I'm unable to replicate that behavior,

would you please be more specific about the report setting and add some screenshots if possible (particularly fields used and conditions applied)?

I'd like to clarify as well about modules - is it only the case for the Leads module or several modules?

Thanks in advance!

Regards, Serhii

[MaxSantolo]

@serhiisamko091184 Modules Impacted are leads and contacts.

Search

After Next Page click

[serhiisamko091184]

Hello @MaxSantolo,

thank you for your quick response,

the issue has been moved to the SuiteCRM repo as present in v.7 as well.

I was not able to achieve the same behavior from the very first time, because having this set of local settings works fine for me:

One more time thanks for bringing this up to our attention!

Regards, Serhii

[MaxSantolo]

Hello @serhiisamko091184, I can confirm It's a problem of date format. With mm/dd/yyyy works perfectly. Probably something in the js. Let me know if I can help in any way. Regards, Max