I hate to cross post, but I wasn't getting any progress with this on serverfault and there appears to be a lot more activity with regard to reporting services here.
I've created a simple report in SSRS, and then tried my hand out with a data driven subscription.
I can verify that the subscription runs on the 'My Subscriptions' page. Under Status it says Done: 1 processed of 1 total; 1 errors.
How do I find out what this error is?
I've looked in the Windows Event Logs and haven't found anything. I also checked the SQL Server Logs and nothing is there either.
You need to look in the "Report Server Execution Log" which is a particular SQL Reporting Services log file.
See Reporting Services Log Files for details.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With