Jump to content
Changes to the Jaspersoft community edition download ×

Summary of subreport values


JayLink

Recommended Posts

Hi there --

 

 

I understand how to return a value from a subreport to the master report. I also understand how to sum these return values.

 

 

What I would like to do, however, is to have a list of subreport totals in my master report's summary.

 

 

For example, let's say I have customers in three cities: Chicago, London, and Milan, and I call the subreport once for each city. Each time it is run, I will return the number of customers in that city.

 

 

So, let's pretend that I have 6 customers in Chicago, 3 in London, and 4 in Milan. I don't just want the number 13. Instead, I want my master report's summary to say:

 

 

Chicago: 6

London: 3

Milan: 4

 

Total: 13

 

 

Ideally, I would prefer not to have another subreport in the Summary, because the query is complex and takes several minutes to run.

 

 

Can I store the return value from each subreport's query separately somehow? When I try this, I just seem to end up with the last subreport's value in all of my variables.

 

 

Thanks so much,

 

 

- Jay

 

Post edited by: JayLink, at: 2007/05/31 19:16

Post edited by: JayLink, at: 2007/05/31 19:17

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...