How to access my stored procedure in sql server?

[Vishnuprasadkv760]

In my jaspersoft studio I am able to connect my sql server by using jdbc connection, but what i need is , i have a set of stored procedure in that server , which will accept 3 parameters.
 i really dont know how to connect to that stored procedure and create a report. any one can help me with the steps i need to follow. i searched a lot, but didnt get a properway to connect to stored procedure in sql server. 

[nardao]

You can "connect" in your store procedure as the same way that execute any other query. Store procedure don't have a different way to access, you simple have to call the procedure, ex:

call MyDB.procedure_tes(param1, 'param2', param3);

If this parameters are dinamic, you can use the report parameter or variable, ex:

call MyDB.procedure_tes($P{param1}, $V{param2},$P{param3});

 

 

[nardao]

You can "connect" in your store procedure as the same way that execute any other query. Store procedure don't have a different way to access, you simple have to call the procedure, ex:

call MyDB.procedure_tes(param1, 'param2', param3);

If this parameters are dinamic, you can use the report parameter or variable, ex:

call MyDB.procedure_tes($P{param1}, $V{param2},$P{param3});

 

[ravurisam5]

Can I call multiple stored procedures?