Let’s just assume that…

You’ve created your data driven subscription (File share) for your reporting services report, and everything is as it should be. The subscribers table has been created, populated and correctly mapped to the required fields in the subscription (FileName, Path, Format, Parameters, etc), the schedule is set. And then you test your subscription.

The Error Message Status

The schedule has run and you find this very helpful error message status beside you subscription in Report Manager. Scratching your head you dive into the Error & Event logs searching (in vain) for those few lines that will shed some light on the question “Why did those 2 errors occur?” Nothing.

Found ‘em!

Hidden away in its own folder are the Reporting Services Log Files:

SQL Sever 2005 –> *C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles  

SQL Server 2008R2 –> *C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

*These may be different depending on your installation

More specifically, you’ll need to look at the ReportServerService__mm_dd_yyyy_hh__mm_ss.log files. These files will list, among other things, any errors encountered in your Data Driven Subscriptions. Here’s mine:

From this I could deduce that there was a problem with the filename that was being used for one of the reports. Once I had reviewed all the filenames being used and had updated those that contained the special characters (2 of them), the subscription ran without a hitch. Problem solved.

So the bottom line here is, if you have any issues with you reports look in the reporting services log file.