If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Create Report from Stored Procedure

Started by Shobha, 26 Jul 2007 11:07:56 PM

Previous topic - Next topic

Shobha

Hi all, Can we create a report from Stored Procedure. If yes then pls tell me the procedure and how to access and use it in report.

I had just tried but i am not getting any fields under Stored procedure name.

Thanks.

snadgir30

#1
Hi Shobha,
You can use SP to create report.
For that you need to do rather SP   ;D following:

  • 1.Import SP in FM as Query Subject .
         2.Keep in mind that SP should return fields that you will be using in Report in short SP should return Temporary table fields
         3.Publish the package
         4.Build the report on same.

I hope this suffice.

Regards
Snadgir30

Shobha

Can u pls explain in detail.. if don't mind with an sample example..
and what are changes has to be done in framwork manager for stored procedure
and how call it in report studio?

Thanks