COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: justjohno on 18 Aug 2008 11:36:44 AM

Title: Stored procedure in a Impromptu report
Post by: justjohno on 18 Aug 2008 11:36:44 AM
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.