Error : 1 - Error evaluating expression : Source text : $F{Aantal}

[mulcamd]

I have made a report with iReport, first without an Input control.

In my query I have Country, Region City, aantal (dutch for count)

I have a group on Country, Region

I used the Report Wizard on iReport and used the template Coffee.

Running this report from both iReport and JasperServer is ok. No errors.

Then I added an Input control for Region named "Region" with ID: RegionId and Name: Region

I have made a parameter called: RegionId and type "java.lang.Integer", but added it not yet to the query.

The report runs fine,both from iReport and JasperServer. No errors.

Then I add the parameter to the query in the Where clause

WHERE RegionId = $P{RegionId}

Then the following error occurs, see below.

Questions:

1. What is wrong with $F{Aantal} . Without the Input control this field in the detail section gives no problem.
2. How should I solve this problem?

Code:

1 - Error evaluating expression : Source text : $F{Aantal} java.lang.Exception: 1 - Error evaluating expression :      Source text : $F{Aantal}	at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403)	at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320)	at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70)	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  

[ernestoo]

Can you post your JRXML? Hard to tell what is going on.

[mulcamd]

Hi,

 

I solved the problem, but I do not know what is the difference.

I removed the field and run the report and then added it again. Then it was fine.