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 |
How can you change the group key dynamically?
What is data stream and data adapter is it same are different? Explain?
How do we have left -right flow , normally its top-down flow
How do you design a report which has multiple child datastream (horizontal seq)
What is report bursting?
What is afc?
What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?
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.
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?
Where do we use ACvisitor class?
How to set Parameter in Script data source?
What is page level security?