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

wat is synchronous and asynchronous reporting?

1 Answers   HSBC,


Can we define global methods in a report?

2 Answers   L&T,


HOW TO DEBUGGING A REPORT?

1 Answers  


What is data stream and data adapter is it same are different?

0 Answers  


What is data stream and data adapter is it same are different? Explain?

0 Answers  






How can i make use of Multiple Input Filter, the case is, i have two Datasources with different queries with a common field. i need the merge set in datarow of MultipleInputFilter. how can i make it.? please provide with clear example i'm new to actuate. thanks in advance.

2 Answers  


What is afc?

0 Answers  


What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

0 Answers  


how many times executite the fetch method at run time?

2 Answers   EDS, IBM, TCS,


Where do we use ACvisitor class?

0 Answers  


What is AFC? Where we Use AFC in Actuate?

4 Answers  


What property you use to Hide a control at runtime?

2 Answers  


Categories