error in subreport

[2004 IR Help]

By: just - justjasper

error in subreport

2004-02-19 00:45

hi,

i made subreport but i have 2 problems:

1- subreport not appear ever i did all steps in vedio document.

2- in subreport i have this error:

Executing query select * from GRN_TREATIES where GRN_BOQ_ID = $P{ID}

 

java.sql.SQLException: Non supported SQL92 token at position: 51: ID

 

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)

 

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)

 

at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:954)

 

at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:200)

 

at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:120)

 

at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:68)

 

at oracle.jdbc.driver.OracleConnection.nativeSQL(OracleConnection.java:1207)

 

at oracle.jdbc.driver.OracleStatement.expandSqlEscapes(OracleStatement.java:6073)

 

at oracle.jdbc.driver.OracleStatement.parseSqlKind(OracleStatement.java:6062)

 

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2481)

 

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:717)

 

at IReportCompiler.main(IReportCompiler.java:145)

 

can u help me...

 

 

 

 

By: Giulio Toffoli - gt78

RE: error in subreport

2004-02-20 09:34

 

You are using iReport 0.0.1?

 

Leave the query field blank in the compiler window

 

Giulio