This problem has popped up recently. We have SSRS reports that are sent to 3 people. One person receives an Excel file that is empty, while the other two receive an Excel file that has the correct data. If we rerun the subscription, then all 3 receive the correct data. It doesn’t matter if the first time is sent at the scheduled time or manually. I have rebooted the SQL Server multiple times to no effect.
Here is the SQL Server info:
Product: Microsoft SQL Server Standard (64 bit)
Operating System: Windows Server 2019 Standard (10.0)
This usually happens when the subscription runs under different user contexts or parameter values.
Check if the user getting the empty report has filters or row-level security applied that return no data. Also verify the subscription owner’s credentials — SSRS runs the job using that account, which can affect data access.
If parameters and permissions look fine, check the ExecutionLog3 table to see if the dataset actually returned rows for that user. That’ll tell you if it’s a data issue or a rendering problem.
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.