Hello! Is there a way to connect a StoredProcedure (result is a table) with a normal Table in SSRS? At the moment we have this solution in a crystal report and it works finde but i have to create a SSRS-Report from this crystal report! Thanks 4 answers! Gilbert

Hello Gilbert, You can add a "DataSet" basing on a stored procedure and this dataset you can use for a table/matrix/tablix control in SSRS.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hello! I know this! But i have to connect the result (table) of the stored procedure with an other table! Like: SELECT * FROM (EXEC sp_StoredProcedureName) SP LEFT JOIN Persons P ON P.PersonID = SP.PersonID I know this statement can't work, but is there a way/solution/workarround to do this in SSRS? Thanks 4 Help Gilbert

No, this is (directly) not possible. You can only use 2 datasets, one for the SP and one for the query, in SSRS you can then use the Lookup Function (Report Builder and SSRS) to lookup data from one dataset with filter values from the other ds, eg. with PersonID. Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing