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.
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.
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?
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