ctiscar

Hi, I created a report using a crosstab. Actually there are two crosstabs, one overlapping the other, because I want the crosstab rows displayed alternatevely with different backgroud colors. In order to do that the query returns also a field that numbers the rows, so that even rows are displeyd with white background an odd rows are displayed with grey background. In some way this field acts like the REPORT_COUNT variable that I cannot use because the crosstab is not in the detail band. Everything works fine using PDF format, but in HTML format only odd rows are displayed. Why? Thanks. CT

Great! It works fine. The correct SQL statement is: select a, b, c, from T1 join t2 on (<join condition>) where t1.a = '$P!{xxx}' and t2.x in (select x from T3 where t3.y = '$P!{xxx}') because t1.a and t3.y are varchar2 Oracle type and Oracle expects a quoted string. Thanks a lot. CT

I'm sorry for the fonts used!

Hi, I would like to define some parameters for all reports built in iReports, that is I would like to create another parameter just like REPORT_LOCALE or REPORT_MAX_COUNT so that it will be automatically available for every report I create. Is this possible? How? Thank you in advance CT

Hi, I'm using iReport 3.1.0 and I havo some problems using parameters in SQL statements with subquery in where clause. Example: select a, b, c, from T1 join t2 on (<join condition>) where t1.a = $P{xxx} and t2.x in (select x from T3 where t3.y = $P{xxx}) The same query without the second condition (and t2.x in (select...)), perfectly runs without errors. Why this happens? Where is my mistake? Thanks CT This is the error log I get:Error filling print... Error executing SQL statement for : report4 net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report4 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1193) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:843) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:792) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:890) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 11 more Print not filled. Try to use an EmptyDataSource...