If you are using more then one table in the report then be sure that all are properly linked , so then it will work fine.
You have to check all the linked in the table that you are using in the report