Show Multiple Columns with a footer

[rafaelviana]

When I'm working with multiple columns the column footer appears in each column.Is there any way to show the footer only in the latest column of the latest page?  

[slow]

uhm...

you can show a texfiled only in the last column using this print when expression

new Boolean($V{COLUMN_NUMBER}.intValue()==3)

use the max number of columns instead of 3...

and placing this textfield in the first column footer.

in this way it appears in all pages but only on the 3° column.

if you 'd show it only in the last page, you can use the last page footer band or the summary band;
in this bands there aren't columns so, you can place your field under the last columns...

 

____________________________________
if it works... give me KARMA points please!    : ) 
____________________________________
 

Post Edited by slow at 05/07/2010 08:37

[rafaelviana]

Ok. Thanks.

But it isn't enough because if I fix the value in 3 for example.There can be situation that only 1 column is filled, so the footer will not be showed. How can I know the number of total columns instead of use the static value.eg: 3?

 

[Giulio Toffoli]

The only way to do something special in the last page is by using the last page footer band, until you are not using a custom datasource able to tell you if there are more records or no.

Giulio

[rafaelviana]

Thanks! I got it!
 

In the datasource i put it:

private final int COLUMNS = 5;
private final int RECORDS_PER_COLUMN = 55;

private int LAST_PAGE;
private int LAST_COLUMN;
 

LAST_PAGE = (int) Math.ceil( ((double) numero.size()) / (COLUMNS * RECORDS_PER_COLUMN ) );
LAST_COLUMN = (int) Math.ceil( ( ((double)(numero.size()) % (COLUMNS * RECORDS_PER_COLUMN )) / RECORDS_PER_COLUMN ) );
 

And in the column footer i put this expression:

new Boolean ( $V{COLUMN_NUMBER}.equals($F{LAST_COLUMN}) && $V{PAGE_NUMBER}.equals($F{LAST_PAGE}) )

 

 

 

i think it also could be make inside the Ireport switching the fields by the expression used in Java, the size of the list is in the variable: REPORT_COUNT.

Something like this, only needs to find a manner to use the Math.ceil

new Boolean ( $V{COLUMN_NUMBER}.equals($(int) Math.ceil( ( ((double)(REPORT_COUNT) % (5 * 55)) / 55 ) )) && $V{PAGE_NUMBER}.equals( (int) Math.ceil( ((double) REPORT_COUNT) / (5 * 55 ) )) )