We seem to have come across a bug/issue in report builder where we develop a report and its runs fine the first time but once its saved and then ran again it returns the data in blank rows. You are then able to export the report to excel where it shows all of the expected data from the query.