Check the RD and the filter criteria first. I think you are running the RD individually to see the rows fetched. If RD is not able to fetch the expected run the tracer and enable DB query to capture the query being formed. If you have DB access the you can run the query at DB end to verify the query formation. But mostly check your filter criteria.