CiviCRM Community Forums (archive)

Hello,

I am having some trouble with emailing a custom report using Scheduled Jobs and mail_report.

When I go to the Scheduled Jobs page and select Execute Now on the Report sender job, the report is sent to the email addresses specified and the format and data in the report are as expected.

When the job is executed via cron, the email is sent with a csv attachment, but the report has the wrong column titles and no data.

Here is the command being executed via cron:

php ../www/www/administrator/components/com_civicrm/civicrm/bin/cli.php -s <site> -u <username> -p <password> -e Job -a execute

Any suggestions on what I can look at to figure out where this is going wrong? Thank you!