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 |
What is AFC? Where we Use AFC in Actuate?
Can you give an example of any complex report you designed using Actuate?
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.
How to set Parameter in Script data source?
What is report bursting?
How to do performance tunning of reports?
WHERE WE USED JAVA CONCEPTS IN ACTUATE?
What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?
how many times executite the fetch method at run time?
How can you change the group key dynamically?
Can we connect to 2 different types of database through the same report?
what will we have to do if we want to generate an existing report in different language for different countries??