Re stored procedures

[1raviteja]

Hi,
I would like to know to call astored procedure In ImpromptU.How I can pass parameters to the stored procedure.Is it I have to write a macro or udf.
I don't know much about that.I know only through template only.
If I passe parameters to prompt the stored procedure is not returning any rows.
Thanks for your help.
Sridhar
972-550-9485

 

[1raviteja]

Hi,
I would like to know to call astored procedure In ImpromptU.How I can pass parameters to the stored procedure.Is it I have to write a macro or udf.
I don't know much about that.I know only through template only.
If I passe parameters to prompt the stored procedure is not returning any rows.
Thanks for your help.
Sridhar
972-550-9485

 

[griffindm]

See thread401-71396

The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[1raviteja]

Hi,
I would like to know to call astored procedure In ImpromptU.How I can pass parameters to the stored procedure.Is it I have to write a macro or udf.
I don't know much about that.I know only through template only.
If I pass parameters to prompt the stored procedure is not returning any rows.
I am using SQL Server 2000 and ImpromptU 7.0
Thanks for your help.
Sridhar