alan_3 Posted May 30, 2013 Share Posted May 30, 2013 Just purchased Jaspersoft on AWS and couldn't figured out how to apply filter on an aggregated field. Let's say I have two tablesUsers Table with UserId, FirstName, LastNameUserData Table with UserId, DateTime, Value (for each user, there exists multiple user data).In UserData table, I was able to create Value field as a measure. So on a report table, I'm able to display the sum of all Value for a particular user. However, if I want to add a filter on Value, it is only able to fiilter the Value base on each row withinin UserData table, not the aggregated SUM of the value. Is there any way to add such a filter within JasperSoft's portal or via iReport? If so, how? Link to comment Share on other sites More sharing options...
mmflynn Posted June 4, 2013 Share Posted June 4, 2013 Filtering on an aggregate value can be done in the Crosstab ad hoc view if using Jaspersoft OLAP (not included with Jaspersoft BI for AWS) as the data source, or in JasperReports at the query with the GROUP BY and HAVING clauses. This link may help: http://www.w3schools.com/sql/sql_having.asp. Mary FlynnJaspersoft 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