I am new to SSRS.  Using SQL 2008, Visual Studio 2010 shell.

I have a stored procedure that when I execute it through SSMS, it returns the correct results.  However, when my report runs through SSRS (using the same stored procedure).  I get inconsistent results.

I've been able to narrow it down to a specific parameter in my report where I pass in Id's.  This particular parameter gets its values from a query and is setup to use multiple values.  I have focused on two ID's which together are giving me problems. 

The IDs are !'" and !!T.

When I ONLY select !'" the report returns the correct results.

When I ONLY select !!T the report return the correct results.

When I select !'" and !!T the report only return the results for !!T.

I have no clue why SSRS doesn't like this.  Any help would be apprec

I have a stored procedure that ... is setup to use multiple values.

How do you handle the multiple values in your stored procedure, are you splitting the values correctly? See Passing multi-value parameter in stored procedure ssrs for an example