sql server - Query returns different number of rows when used in an SSRS report -

my query returns 6 rows when run on production server. when same query used build ssrs report, returns first 2 rows of data when run in production. have been trying issue sorted 2 days now. appreciated!

here's query:

declare @startdate varchar(255), declare @enddate varchar(255)  select i.customeridname 'customer name', count(s.[subject]) as'activities'  dbo.incident  full outer join  dbo.serviceappointment s on i.incidentid = s.regardingobjectid  full outer join dbo.account on a.accountid = i.accountid join filteredaccount crmaf_filteredaccount on crmaf_filteredaccount.accountid = i.customerid i.customeridname not null  , (s.scheduledstart between cast(@startdate datetime) , cast(@enddate datetime))  group i.customeridname,a.owneridyominame 

couple of things check.

• filters : check ssrs table filters may have placed on
• cached data : go root of solution , delete .data files , re-rubn report
• connections : mention have production? logic dictates have dev. check data-sources point right way.