zamudio

asim1985, Your SQL statement should look something like the statement below. When using $X you do not need to specify the IN sql operator before it. zamudio Code:and sp.fin_id=fm.fy_id /* after commenting records were came in large no i.e no of records increases */ /*and p.fin_id=fm.fin_id */ /* Reason for commenting fin id of property is null*/--and p.sac_no in(/*'BX1408080030000',*/'BX1408080110000'/*,'BX1408230020013','BX1408230020036','BX1408090000002','BX1408070070000','BX1408090000000'*/)and ($X{IN,p.sac_no,SAC_NO})

I have several reports in iReport 3.6.0 which are not rendered correctly in JasperServer 3.5.0. Some label names and fields are not displayed on JasperServer. I find that this is caused if labels or fields overlap each other in the report design. If I render the report in XHTML in iReport everything displays correctly, even if overlapping. Is there way to render reports using XHTML in JasperServer instead of plain HTML? Or some other way to fix this issue? zamudio Post Edited by zamudio at 09/12/2009 22:23

Found it! To pass a Collection parameter to a subreport or dataset enter it as the following expression: If your report language is Java, pass the parameter as $P{ParameterName} If your report language is Groovy, pass the parameter as $P{ParameterName}.toArray() zamudio Post Edited by zamudio at 09/12/2009 22:02

That works! One more question, how do you pass a Collection field to a dataset or a subreport? zamudio

I am trying to run a report with a multi-select parameter in iReport 3.6 but cannot get it to run. Parameter name is EmployeeType of type java.util.Collection. My default value expression is java.util.Arrays.asList(new String[]{"Manager","General"}) select Name from Table1 where $X{ IN, EmpType, EmployeeType} In the Report Query window, I get an error message saying: Error: SQL problems: Line 3: Incorrect syntax near 'X'. If I try using $P I get the message: Error: SQL problems: The Java type java.util.Arrays$ArrayList is not a supported type. If I try using $P! I get the message: Error: SQL problems: Invalid column name 'Manager, General'. Any ideas on how to solve this?