Stored Procedure in Report Studio

[cwilms]

Hello,

we are trying to call a stored procedure in Report Studio (Cognos 8.4) with several parameters.
Can someone please help us, how we can do this.

Thanks

[EArumugam]

Hi ,

1.Import the Stored Procedure to FM.

2.goto Edit Definition>Pass arguments, Datatype to the IN parameters for the SP(always use the same parameter values for the stored procedures.)

     2a.   Click the "Test" button. You will be prompted to enter values to use for the test:

3.Publish the package to Report Studio.

4.It will be display as query subject in RS.

5.Map the parameter name to Prompts.

6. Create report with query item from stored procedure query subject.

I thnk it will clear for you..

I am haivng screen shot of all steps mentioned above but not able to attach the same here.

Reply back if you have doubts.


Regds,
Eas