Why Does My Scheduled Report Contain No Data?

eTapestry has the ability to schedule report to run overnight. This is very helpful for larger reports that will take a long time to run, or helpful for a report you may need to run daily, weekly, or monthly.

It is possible that the report runs successfully, you receive the report via email/dropbox, and the file contains no data. When you manually run the report within eTapestry, the report does have results.

Article
Number:94377

Products:

eTapestry

Make sure that the user account who scheduled the report has not been moved into a security group different security group. At the time the report was scheduled, the user may have had access to all/certain accounts or journal entries. If that user has been moved into a different security group, you may have blocked access to the accounts or journal entries being expected in the scheduled report. You would want to move that user back to the original security group, or disable the report and schedule it using your user account. For this particular situation you would have to have the Advanced Security module. Basic security can't block access to seeing accounts or journal entries.

The scheduled report is based off the user's time zone. Each individual user can set their time zone on their user account in the Preferences page. The database also has it's own time zone setting found under Management > My Organization > Preferences. If the user that scheduled the report has a time zone much earlier/later than the rest of those expecting the report, it might affect the data being pulled.