how to use S Proc in report studio......

[pooja]

URGENT-----how to use SP in cognos RS

please need some assistance with all the steps, would be great

thank you so much in advance

pooja

[pooja]

...????????....

:o :o :o :o :o :o :o :o

[EArumugam]

Hi Pooja ,

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

[admin_cog]

let me know which DB you are using.

[lindero]

you can also call a S Proc with a native SQL statement if you don't want to import it in FM.

kind regards