cokelyd

Hi all, I recently put in a post about calling stored procedures from iReport 3.7.6. I've one reply indicating that this will work without adding in the query executer plug in. Thank you very much to that person! I've another question on this matter. Do I need to use a specific version of Jasper Reports API for the libraries in my java workspace in order to achieve this? In other words, are there any new .jar files that I may need to incorporate? Thanks so much!

I have an older iReport manual released in 2007. I have upgraded my iReport to version 3.7.6. I would like to call stored procedures from an Oracle database. I see in the 2007 manual, that on an Oracle data base you have to use a temporary table or implement the Barry Klawans query executer for PL/SQL. Has anyone any information to offer on either of these work arounds? In the past I have always only called SQL within iReport. I am interested in knowing the impact of going the temp table route. I need to ensure that large results sets (both many rows and columns) will not be negatively impacted by using a temp table. I am also interested in hearing from anyone who has used the new query executer and your experiences with that. Thanks so much!

I have loaded a query that runs for me in SQuirreL. Yet, when I load the query into 'Report Query' I recieve the error: SQL Problems ORA-00933 SQL command not properly ended. Is there some sort of special syntax or formatting required for SQL commands in iReport??? Thanks so much, Donna

I would like to create ONE parameter that can accept more than one value. For example, I would like to have a parameter UserID. I would like to enter more than one user id when I am prompted for the parameter value. I do not want to create separate parameters as the user may not always need to enter more than one user id. Is there a way to create the parameter to allow this? I would expect the entry would be something like: userid1, userid2, userid3 And my SQL query would SELECT WHERE a.userid IN $P(UserID)