Reporting Services Errors?

I'm constantly getting various errors within reporting services. If you're a high end user, its going to happen quite a lot. More often than not the error messages themselves are less than useful such as 'Done: n processed of n total; n errors' which is the issue I've been fighting with today.

That's all very well but if you're scratching your head wondering what the actual errors are and berating Microsoft for not being a bit more descriptive and helpful, all you need to do is check your log files.

They'll be somewhere like C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and when you crack open these text files and manage to locate the report you're playing with (CTRL + F), you can see much more detail about your error. Of course its a drag if, like me, you're working in a system where there's five webfarms and you have to check them all but in the end you'll get there.

So the moral of this story is CHECK YOUR LOG FILES.