Calling Stored Procedure From Report Net

[addpremkumar]

Hi,

I Have a Stored Procedure in Framework Manager, which will return Dept Name for the given Dept No.

I want to Know how I can Call this Procedure in Design Time i.e., in Report Studio.

Can any one Help me....

Bye,
Prem.

[Draoued]

Add the procedure to the package to be publish to Reportnet.
Re-publish the package to reportnet.
Now in ReportStudio, when add a new field (create a calcution or double click the field in the report) the procedure is available in the function tab, and can be used as all the others available functions.

[Sunil Gulati]

Correct me if I am wrong but doesn't the stored procedure become available after publishing as a query subject in ReportNet rather than as a function in the Functions tab?

[addpremkumar]

Hi,
After publishing the stored procedure in FM. In report studio it was there in the table's list.
I dropped the required columns from procedure and the input parameter for the procedure automaticaly prompts me...

its working good...

One more clarification.....

I want the Input parameter entered for procedure at runtime to be stored in a temp variable..
For that I want to use the a new query in report studio
for Ex: for a table my SQL was as follows

select * from Tablename..

But for my procedure I can't write like that...is there any other way to get the prameters for my procedure By SQL

How can i call a procedure from the Query ie Tabular Sql in report studio

Thanks For ur guidence it helped me a lot....

Bye,
Prem