Jump to content

Table where each row is a subset of the previous row


tspencer

Recommended Posts

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 elsewhere

etc.

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...