Our emailed reports have corrupt pdf files. Below is the code were using to generate the files.
select 'dbr.mail'; select 'dbr.mail.attach', 'OCP Orders Yesterday - Total.pdf', 'http://reports.primetimesolutions.net/report.php?r=74&m=7&h=f6e84a62bce3ea3761417968d7b1dd99a472756e&export=pdf'; select 'dbr.mail.recipient', 'firstname.lastname@example.org', 'Test User';
select 'dbr.mail.debug', 1;
select '', '', 'OCP Orders Yesterday', 'See attached PDF';
When i go to the report itself and click export and choose pdf it works fine. But the URL in the code is generating a bad pdf file. Any ideas?
We are on RHEL 6.4 with PHP 5.4, Apache 2.2, and MySQL 5.5
We also have Flash charts, Image charts (ChartDirector 5.1), Graphviz charts, and wkhtmltopdf installed