Hi All,

I have managed to get my Reporting Services 2005 up and running.
I have a question though: Instead of defining my dataset as a text query
(such as select * from table..) I would like to define it as executing a
stored procedure. This stored procedure will be a little bit more complex
than just a simple (select * from..)

In other words, it will look into some tables and then iterate through some
values...

WHILE
BEGIN
-- get my values here
-- Here i Used to build a string with the data needed and just print it
(e.g., SET @PrintString = @Value + N' ' + @Value2... )
-- PRINT @SPrintString
FETCH NEXT..@Value, @Value2..
 ...
END

I used to create a string and print that, but now I would like the results
in a table form so that Reporting Services renders them correctly as a
report. Should I somehow create a temporary table and insert the values in
it and then have my query something of the form (INSERT INTO TempTable exec
sp_StoredProcedure) ? Is this the correct way of doing it or should I go
about it a different way ? And if this is the solution, how would I create
this table and how would I actually return it ? Would I just create it
before calling the stored procedure and drop it after that?

Thanks.