Subscription sends report with data to one user but empty report to other users

The strange thing in this case is that the initial report is (only sometimes) sent without data, but if we manually rerun the subscription, the report (an attached Excel file) has data. Very strange.