How to call a stored procedure from a report?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you design a report which has multiple child datastream (horizontal seq)

2149


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

577


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?

576


Where do we use ACvisitor class?

2123


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?

566






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

566


Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.

2402


What is afc?

541


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.

2392


Explain difference between onrow and onread method?

514


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?

587


How to 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?

554


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

583


How to do performance tunning of reports?

1945


Where we use afc in actuate?

549