How do you use stored procedures & functions ReportNet?

[pali]

Hi Guys,

I need help in the reportnet using DB2 stored procedures.
Please provide me step by step after importing stored procedures/functions in the FM and aldo how do you use in the report studio.
Thanks in Advance.

[BIsrik]

Plz refer the manuls for step by step procedure.. :D

Srik

[maya_sekar]

In Framework manager you have option for importing Stored Procedures and functions. The imported SP's will appear in report studio like any other table.

If you have any input parameter then after importing the Sp's you will have to double click the parameters and give
macro functions like below
#prompt('Start_Date','DATETIME')#

If you give macros then when you run the report with SP's the report will prompt for inputs.