vhp1990
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by vhp1990
-
-
Hello,
I have a stored procedure my_sp which takes in two parameters, first an integer and then a date. That is,
EXEC my_sp 265522,'6-10-15'
I have been trying to design a report based on the result set from this procedure in Jaspersoft Studio 5.6. The report does not generate or atleast takes way too long if I use the two parameters though the output data consists of only 25 rows. I am using this query,
exec my_sp $P{param1} , $P{param2}and feel the probelm is with the syntax only. Also the same query works perfect when I had tried it in Sql Server Management Studio and in jaspersoft studio, stored procedures with a single parameter work like magic. Kindly help me out on this -
Hey,
I would like to obtain the values for a 'where in' clause using a query. That is , for $X{IN, colName, parameter}, I want to provide the parameter as a query. In normal where conditions, we use $P!{} and pass the query as a string. In case of $X how do we do this ? Kindly help. Thanks in advance.
Passing multiple parameters to sql server stored procedure from jaspersoft studio 5.6
in Products
Posted
Hello Rajesh. Yes the problem was with the parameter. Since I was trying to format the parameter before passing it, it was throwing up an error. Thanks a lot.