Stored procedure in a Impromptu report

[justjohno]

I'm very new to Cognos and would like a little help if possible.  I created a stored procedure with multiple select statements, returning multiple result sets.  I can create a report calling the stored proc but when I run the report, only get one result set.  Ive tried creating a temp table in the stored proc and select from that and it doesn't work.  I've also looked at sub reports but cant quite figure that out.  I just want my report to return all values in my stored proc if possible.

Thanks in advance to for any help.