sanbez

https://stackoverflow.com/questions/18787697/table-tool-in-showing-one-fewer-lesser-database-records

http://community.jaspersoft.com/questions/507944/sum-return-values-subreports
Is it your case? HTH

>Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 10

Are you sure that $P{yearFrom} containt 10 characters?

www.tutorialspoint.com/java/lang/string_substring_index.htm
 

Set at report properties whenNoDataType="AllSectionsNoDetail"

Why 7 digids? You start only with 4 :) I guess that one of the possible values of $F{RACE_CODE} is "abcxyz" (you don't write example of data). Is it right? In this case you can use expression like this (java code example):
public static void main(String[] args) { String RACE_CODE = "abcxyz"; System.out.println(RACE_CODE.indexOf("abc") == -1 ? "0" : "1" + (RACE_CODE.indexOf("lmn") == -1 ? "0" : "1") + (RACE_CODE.indexOf("pqr") == -1 ? "0" : "1") + (RACE_CODE.indexOf("xyz") == -1 ? "0" : "1")); }[/code] 

Show your java-code which make export to excel

Pattern:
#,##0.00;(-#,##0.00)
and don't use conditional style. It is not need in this simple case
 

Set in main report properties for subreport:
Connection Type = Use a datasource expression
Data Source Expression = (like this:)new JRBeanCollectionDataSource(myCollection)

Check that you don't put DataSourceExpression into "ConnectionType" (see yuor error):
net.sf.jasperreports.engine.data.JRBeanCollectionDataSource cannot be cast to java.sql.Connection



 

You must define params "value1" and "value2" in jrxml

Add paratemer city_to_choose in Report  (not in a Dataset). After that you can pass it into New Dataset 1 (for example if you want to display this parameter in table header)

in iReport:   Tools/Options/Export Options/Excel/Common      set  checkbox "Detect Cell Type" on checked.  (iReport 4.1.2)

But i don't remember... Has iReport 4.0.2 this option?

Variant 1 (easy):   Set vertical size of Detail 2 equal size of subreport (not empty rows in Detail 2 after subreport). Set in Main report in propetry windows of subreport 2  check box "Remove line when blank" in "checked". May be in this case, you must set Properties "When no data" in subreport2 in to "All sections, no details".
Variant2 (more difficult)
Return value $V{REPORT_COUNT} from subreport2 into main report (for example variable $V{Var1)). And set Print when expression ${Var1} on Detail2 section (or subreport).

HTH

 

Why in TextFieldExpression for firstName class is com.myCompany.Person ? replace it on java.lang.String

Check in iReport   Tools/Options/ClassPath
Which version of jasperreports-X.Y.Z.jar    in this classpath?
After upgrade iReport to new version installer may save old classpath in new iReport  with uncompatible libraries (previous version jasperreports-x.y.z.jar) 

Which version of jasper? In iReport 4.0.0 and later you may use Table and set "Column print when" condition. In this case all values on column will be hidden, and others columns shift left (there is no empty space).

Which type of calculation setting on cell of table?
Try to use Calculation = Sum  in value expression for data cell.  
And it may be required to write:
Incrementer (implements JRExtendedIncrementer)       and
IncrementerFactory (implements JRExtendedIncrementerFactory)    classes on java

I am make this for calculation sum on crosstab where cell of crosstab is complex data. And it's work fine.
I am think that for cell of table it's also will be work (for calculation in cell = "Sum" and set your incrementer)