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

0

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)  </td></tr></tbody></table>
mulcamd's picture
93
Joined: Mar 16 2011 - 11:47am
Last seen: 1 year 10 months ago

2 Answers:

-1
Can you post your JRXML? Hard to tell what is going on.
ernestoo's picture
9054
Joined: Nov 29 2010 - 11:59am
Last seen: 2 years 2 months ago
0

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.

 

mulcamd's picture
93
Joined: Mar 16 2011 - 11:47am
Last seen: 1 year 10 months ago
Feedback
randomness