How to Create Report from Stored Procedure

[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]

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