klin0011

Hi, I made a report with iReport 3.7, in which I created a table with integer-values. When I export the report as a xls-file, this interger-values from the table changed to strings. How can I change it, to get also integer values in the xls-file, like they are defined in iReport. I appreciate any kind of help. Thank you! Ingrid

Hi, I want to construct a bubble chart in iReport 3.7. In the "chart details" in the "Dataset" tab I set the "Reset Type" to "Report" and the "Increment Type" to "Non". In the "Details" tab I added a "XYZ series" with the following features: the X-, Y-, Z-values are numbers and the "Series expression" is a Field $F{id} which I used in the SQL-query from the report. In the tab "Item hyperlink" / "link parameters" I added a Parameter $P{Messpunkt}. When I run the report, the chart appears in the report without errors, but the bubbles don't appear. I appreciate any kind of help. Thank you! Ingrid

Hi Christina, I added the parameter "List" at the input data types at the server. The properties for "List" are : Name and Label: List Input Control Details: -Type: Multi-select Query(Check Box) -Query Resource: Locally defined -The query (SQL): select id, name from metadata; -The locally defined datasource is my postgresql -Value Column: id -Visible query column: id In the database "id" is defined as an Integer. I don't know if it's possible to define somewhere the type of "id", so that the collection can be filled with Integer-values. Regards Ingrid

I tried is also with this query in iReport: SELECT id, name FROM metadata WHERE id IN( $P!{Messpunkt}) and than I get this errors: Code: Regards Ingrid Post Edited by klin0011 at 04/16/2010 13:57

Hi Christina if I use this query in iReport: SELECT id, name FROM metadata WHERE $X{IN, id, List} I get the following errors: Code Post Edited by klin0011 at 04/16/2010 13:47

Hi Christina, there is only a very big java stack trace saying the sql statement is wrong. The statement SELECT id,name FROM metadata WHERE $X{IN, id, List} is expanded to: SELECT id,name FROM metadata WHERE id IN([1,2]) And the stack trace in the sql classes say something like: "[" error in sql statement. The Collection List is filled from another sql statement with id from type Integer. Therefore an "Input Datatype" was defined. When printing the parameter in the main report we get something like [1,2,3,4]. When we change the sql query manually to SELECT id,name FROM metadata WHERE id IN(1,2) everything is working fine. Regards Ingrid

Hi, I am trying to run a report with a multi-select parameter in iReport 3.7 but cannot get it to run. Parameter name is List of type java.util.Collection. I have a column in my database called "id" of type int. I passed the parameter value to the query like this: SELECT id, name FROM metadata WHERE $X{IN, id, List} I get error messages for executing SQL statment. Any ideas on how to solve this?