I can't exec stored procedure of MS SQL Server with two or more parameters.

[ceciliaf.vm.ar]

Hello.

I have a stored procedure in database of MS SQL Server 2008 wich have two parameters. I using sqljdbc4.jar.

Well, my problem is this: I can't call in the report a stored procedure with two o more parameters.

I try with this options:

 

exec Stored_procedure value1, value2

Stored_procedure value1, value2

Sotred_procedure (value1, value2)

 

The procedure, in then query analyzer of SQL return the data correctly.

I see in the Query designer that only options to create sintax is with SELECT.

Forgive my english, I have little knowledge of the language.

Thanks.

 

[cameron_1]

You should be able to put the exec sp_name <parameter1>, <parameter2> statement directly into the report query window (don't use the query designer as it doesn't work that well) - 

 

[ceciliaf.vm.ar]

Hellow cameron_1.

 

Thanks for the help, but I discovered that jdbcsql not solve stored procedures with temporary tables.

To solve the problem, from PHP run the stored procedure and keep the result in a table, and from iReport select the record that need to see.

Regards.

[ceciliaf.vm.ar]

-

[ceciliaf.vm.ar]

The problem is the driver. It not knows how solve stored procedures with temporal tables.
So, the solution is create a new stored procedure that return it the content of original stored procedure.
Thanks.