SSRS reports does not show all the data in view

277 Views Asked by At

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))
0

There are 0 best solutions below