I need to display he data in the following format
2001 | 2002 | 2003 | 2004.... | sum | |
data1 | 10 | 20 | 10 | 10 | 50 |
data2 | 20 | 20 | 20 | 20 | 80 |
data3 | 30 | 20 | 20 | 30 | 100 |
sum | 60 | 60 | 50 | 60 |
My sql query is
select year, data1, data2,data3 from table1. Year data1,data2,data3 are allseparate columns in the table. Cross tab does not help in this case
1 Answer:
The column total is very easy, just drop your fields in the column footer and JasperSoft studio will ask you if you want to agregate the result (select SUM) and will create the proper variables for you.
For the row total create a variable, let say ROW_TOTAL and in the variable expression add all the fields you want to add i.e.: $F{sales-01} + $F{sales-02} +$F{sales-03}.... and then in the last column just print your variable $V{ROW_TOTAL}
For more info on working with variables, look at chapter 9 in the JSS user guide http://community.jaspersoft.com/documentation/v56/jaspersoft-studio-user...