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
Downloads
Everything posted by vhp1990
-
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.
-
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.
