sagarnikam123 Posted November 23, 2012 Share Posted November 23, 2012 I have this report but i am not figure out how to sum all values present in column "DoctorID" ? I just put variable $V{COLUMN_COUNT},it gives no of rows in a column Link to comment Share on other sites More sharing options...
lisacbeaton Posted November 26, 2012 Share Posted November 26, 2012 What type of field is DoctorID? Is it a string? Why would you want to sum them? What would a sum mean for you in regards to DoctorID? Link to comment Share on other sites More sharing options...
Solution jvway Posted November 26, 2012 Solution Share Posted November 26, 2012 Yeah, unless they are number types you will only be presented with the option to count. If the fields are number type then when you drag the field over iReport will give you the option of sum in the drop down. Link to comment Share on other sites More sharing options...
sagarnikam123 Posted November 27, 2012 Author Share Posted November 27, 2012 DoctorID is an integer,i want to sum them...forget about ID,its an misleading name,sum means adding all values of column "DoctorID" to get actual total instead of 9 in last row Link to comment Share on other sites More sharing options...
dieguito28 Posted November 30, 2012 Share Posted November 30, 2012 Put sum not count! count = 9, sum = 49959 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now