How to call a stored procedure from a report?



How to call a stored procedure from a report?..

Answer / akash

place the connection in the connection slot --use "ODBC
connection" option here.
while placing the data source in the data stream
choose "Stored prodedure data source componant" ,click on OK
Place the data row in the data row slote under data stream .
Now double click on the data stream go to Property-Stored
Procedure Def ,click on the browse button ,
then it will automatically opens the SP in your database ,
just select the stored procedure (SP) which u want

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Actuate Interview Questions

Hi, we had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas.

2 Answers  


Hi Friends, I am planning to learn actuate tool by it self .... can u suggest me any examples to practise this tool.

1 Answers  


Can we connect to 2 different types of database through the same report?

6 Answers   L&T,


Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

0 Answers  


What property you use to Hide a control at runtime?

2 Answers  






What is the difference between -using Group by in the SQL of the report -having a Group section in the report

2 Answers   HCL,


How do we have left -right flow , normally its top-down flow

1 Answers  


What is AFC? Where we Use AFC in Actuate?

4 Answers  


how many times executite the fetch method at run time?

2 Answers   EDS, IBM, TCS,


We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

0 Answers  


what is the filter?

1 Answers  


I need a help for Connecting to iServer Volume using IDAPI Classes(Java Classes) and after connecting to iServer i want to execute the ROX on iServer and also want know the status whether that job is succesfully run or not. Please do the needful if anyone of you known the code and send the copy of it ASAP.

3 Answers  


Categories