Problem Using Stored Procedures In Report Datasets

I have a local Reporting Services report that I am modifying to use a stored procedure.



Although I am executing a stored procedure in the dataset query window, I also have to run a SELECT statement to retrieve the fields from a table that will populate the report.



The code that I have in the dataset query window looks like the following:



------------------------------------------------------------------------------------------------------------

EXECUTE @retCode = RunClaimVerification @parmID, @parmDate, @parmRecordID OUTPUT



SELECT *

FROM ClaimsDetail

WHERE ClaimRecordID = @parmRecordID

------------------------------------------------------------------------------------------------------------



When I execute this code, the only results that are returned SEEM TO BE the return code associated with running the stored procedure.



I thought about putting the SELECT code in the stored procedure and returning a table or a cursor from the stored procedure BUT it looks like tables are not supported as Report Parameter data types.



The stored procedure code generates Claim data that is stored in a SQL Table. The fields in this SQL table need to be retrieved by a unique record id to populate the fields in the report.



Does anybody have any suggestions as to how to go about doing this OR any suggestions that would help me resolve this problem?