czupet Posted November 24, 2013 Share Posted November 24, 2013 I am using iReports 5.1: In CrystalReports you can add a filter to exclude records by Sum like this:Sum ({Amount}, {ZipCode}) > 0.00 How can I accomplish the same in Jasper Reports?For example if I have a Zip codeand I do a sum by Last Name in the Zip code group and I only want to display Zip Codes that have sum > 0for exampleZipCode: 12345Family1 Sum 10Family2 Sum 0Family 3 Sum 100(I want to display all of them)ZipCode: 98765Family1 Sum 0 I don't want to display this Zip Code or anything under the Zip Code. Thank You Peter 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