SuiteCRM 8 Download to Reports not working

When I create a report in suitecrm 8.8 and also 8.9 and select the download PDF action, I get the title page and a bit of the first record, and thats it. It does not produce the rest of the report.

7.15 works fine and produces the report, on the same server as the 8.8 so I don’t think its a server issue and the 8.9 version is on a different server.

Any tips? Anyone else experiencing this?

Hello Paul,

that sounds odd.
I cannot reproduce it here - all looks just fine.
Groups / sums / standard reports / multi pages etc.

Most interestingly, I can replicate the issue on the live site :joy:

I’ve got a fairly vanilla LAMP, PHP 8.3 fpm, MariaDB. It’s an upgraded SuiteCRM system, other than that nothing really special.

That’s exactly what mine does, just prints the first page just like that it looks like you reproduced the bug. Do you get rows or records? …. also no errrors in the log.

This was produced from the Demo (correct), @BastianHammer it looks like the one you produced is bugged too like mine?

I’ve just tested on the demo again.
Leads - ID, City

and the same like yesterday:
Accounts - Name

All is working fine - just like in my installations.

Yesterday, the same report on the demo didn’t work (see my last screenshot).

So what changed from yesterday to today on the demo?
Probably not the environment. Maybe some temporary RAM issues when generating the report?
Does it work in your instance, when you limit the rows by one record (condition ID = …)?

Or maybe there are non printable characters / “difficult” characters for the PDF engine inside the records and that’s why it’s stopping. Would be surprising, if this happens exactly after the first record though.

There really aren’t that many rows. Its my own demo install with test data, there are only a few dozen opportunities to print. It’s weird it failed on the same server one day an worked the next. Wonder if its a specific field in the report thats messing it up. Nothing is failing in log that I can see.

I recommend changing the sequence of the fields in the report and testing it again.

I recall that we previously encountered an issue where the report failed to display records if a related field was selected first (we have topic on it on this forum).

Additionally, you may want to review the config.php and php.ini files on both instances to ensure there are no configuration differences.

Even with just a few basic fields it fails.