Have you tried running a trace to see what SQL SSRS is actually running? If you have parameters involved, it may be it's passing a value you're not expecting and returns no results.
Hopefully running a trace will show quite easily where it's going "wrong".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk