try switching your main proc to using local variables as mentioned

it sounds like the first problem to address is the parameter problem.

SELECT t.FieldId, t.FieldDescription

FROM dbo.Table AS t WITH (NOLOCK)

WHERE t.Active = -1

ORDER BY t.FieldD

could be bringin back dupes. check for...

sounds like exactly what I went through. SQL Server will stage an execution plan better running through SSMS than it does receiving values from SSRS. if you change your SQL...

Thanks, this post helped me resolve an issue that had us all scratching our heads. in SSMS my SQL ran in 30 seconds, in SSRS, it never stopped running. The...