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

Difference between onRow and Onread method?

1 Answers   HSBC,


What is page level security?

3 Answers   L&T,


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  


Can we define global methods in a report?

2 Answers   L&T,


i have one question? i generated one report design time i can color green. at run i want bule how to change dynamically? and which method i can over write?

1 Answers   IBM,


I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

0 Answers  


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  


how can i generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report. can any one guide me on this. pls... awaiting for the rply..

1 Answers  


I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

0 Answers  


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  


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

1 Answers  


Categories