how to get sum of field value

[kalpesh.chavda]

Hello,
I want to print sum of total values of my field into my result:

in my table report

like

name  mark   total

aa        3         16

bb        6         16

cc       7           16

[alba.ortega]

Hello, 

Do you want to add only the total for each column or do you want to add both columns and rows?

[marianol]

You can use Variables to calculate the total. Check the docs here on how to use variables: http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v610/variables

in Jaspersoft Studio if you drop a field in the column footer, or summary band it will ask you if yu want to aggregate the value (i.e. sum, avg, etc) and automatically create the variable for you.

 

[hozawa]

Have you tried using Crosstab component?

[kalpesh.chavda]

hello,

in my subreport, my query is select  mobile from emp where id = 12;

when i run this query i am getting data

8888888888

2222222222

now in my main report i want to displya record like this:

name   mobile1            mobile 2

abc     8888888888      2222222222

[kalpesh.chavda]

hello,

in my subreport, my query is select  mobile from emp where id = 12;

when i run this query i am getting data

8888888888

2222222222

now in my main report i want to displya record like this:

name   mobile1            mobile 2

abc     8888888888      2222222222