SSRS report does not pull all the data from the view that its bind to. This view when run sql server shows more than 250 records but when this same view is integrated with SSRS report it shows very few of them less than 10 records. It does not have any parameters as such. Its just a report to display the available time on each day for the resources. Is there anything that I am missing.
Here is SQL query:
SELECT C_code, Eq_Code, header, quantity, date
FROM V_available_hours
WHERE (CONVERT(datetime2(0), date) IN (@date))