tspencer Posted July 9, 2013 Share Posted July 9, 2013 I am new to Jasper and I have a complex report to build where each row of a table filters the values in the previous row by some additional criteria.For example say I have a Customer table and I want a report that count the number of customers that meet certain criteria, each row of the report is a subselect from the previous row:All customers Customers with surname beginning with A Customers with surname beginning with A who llive in London Customers with surname beginning with A who llive in Manchester Customers with surname beginning with A who llve elsewhere Customers with surname beginning with B Customers with surname beginning with B who llive in London Customers with surname beginning with B who llive in Manchester Customers with surname beginning with B who llve elsewhereetc.How can I do this? The only way I can think of is to use a complex SQL query with an inline query for each row of the output, but it seems very inefficient to keep repeating the same query and adding to the WHERE clause. Is there a better way? 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