How to call a stored procedure from a report?
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 |
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.
Hi Friends, I am planning to learn actuate tool by it self .... can u suggest me any examples to practise this tool.
Can we connect to 2 different types of database through the same report?
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?
What property you use to Hide a control at runtime?
What is the difference between -using Group by in the SQL of the report -having a Group section in the report
How do we have left -right flow , normally its top-down flow
What is AFC? Where we Use AFC in Actuate?
how many times executite the fetch method at run time?
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?
what is the filter?
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.