calling SP containing Temp table in IReport

[2002 JI Open Discussion]

By: Jhonny Bravo - ac48

calling SP containing Temp table in IReport

2005-11-09 06:17

hi folks

i m trynig to call a stored procedure using IReport and there is no

problem with that and the procedure gets called ....

but if that procedure has a temporary table then I cannot get the records in my Report....

 

So if any one of you have tried the same plz let me know

thanx in advance

 

 

 

By: TesTech - testech

RE: calling SP containing Temp table in IReport

2005-11-10 23:04

hi ,

Check whether the SP is actually returning any records ?

call the procedure with the required parameters.

For example if ur using SQL server

 

exec <procedure name> <parameters>

 

if the above stmt returns any record , then it will be reflected to Report wizard.

 

thats all my suggestion abt.

 

Regards

Varun Chakravarthi T

 

 

By: allfonsaravanan - allfonsaravanan

RE: calling SP containing Temp table in IReport

2005-11-28 03:39

i m trynig to call a stored procedure using IReport and there is a

problem with that and the procedure have to call from oracle database not from sql server...can any one tell me abt that ...how to call procedure with parameter from ireport?.

[hussainian]

Hi Jhonny!

Can you please tell me how did you make a call to procedure from iReport. Also tell me whether your problem solved. I'm in the same situation i.e. Stored Procedure with Temp table.

Thanks & Best Regards.