Some problem about table and query.

[2005 IR Help]

By: tanade - tanessawad

Some problem about table and query.

2004-03-22 20:52

Actually,I need to create one page which have one group of textFields(about 6) and one table(30row*12column).

 

it has not some problem about group of textField.i used report query like this to query the value from my database.

"Select * from M_CERTIFICATE"

 

But my problem is about the table.The value of each cell have to query from database because them have different condition to got them.The value of each cell depend on different condition.

 

but Report Query can have only one SQL statement.How to manage this problem?Anyone please help me.

 

 

 

 

By: David Lim - aberrant80

RE: Some problem about table and query.

2004-03-22 21:45

Do the query externally and wrap the resulting ResultSet set object inside a JRResultSetDataSource and use it instead of a connection.