sql server stored procedures in jaspersoft studio 5.6 -


i have stored procedure my_sp takes in 2 parameters, first integer , date. is,

exec my_sp 265522,'6-10-15'

i have been trying design report based on result set procedure in jaspersoft studio 5.6. report not generate or atleast takes way long if use 2 parameters though output data consists of 25 rows. using query,

exec my_sp $p{param1} , $p{param2}

and feel probelm syntax only. same query works perfect when had tried in sql server management studio , in jaspersoft studio, stored procedures single parameter work magic. kindly me out on this

this should absolutely work.

  1. add ! after p of each parameter
  2. is sp creating temp tables? if try driver or create sp returns result of sp
  3. try driver anyway
  4. add @paramname tsql = $p{} instead of anonymously naming them

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -