CODEWITHSUNDEEP
plsqljasper-reports
M Kharitonov
M Kharitonov

Reputation: 25

How can I make a field optional?

I use Oracle stored procedure in my jrxml report. It returns cursor as a result. I wish to be able to return different column sets, so some columns in cursor may appear or disappear.

However when column which I've described as a field 

<field name="MY_COLUMN" class="java.lang.String"/>

doesn't exist in cursor it throws an error like this:

error while rendering
net.sf.jasperreports.engine.JRException: Unknown column name MY_COLUMN in result set

Is there any way to declare field in JRXML as optional? When the column doesn't exist in the result set.

Upvotes: 1

Views: 581

Answers (1)

Petter Friberg
Petter Friberg

Reputation: 21710

AFIK: There is no setting/attributes that you can set on your field declaration.

Your options are:

  1. Always return the column name even if not available using sql alias for example:

    SELECT column1, null as MY_COLUMN from myTable.

  2. Create your own JRDatasource which can be all from loading data into beans and passing a JRBeanCollectionDataSource to creating your own JRQueryExecuter and register it to the factory.

Upvotes: 1

Related Questions