Subtotals and/or Subreports

DavidWIII · August 2013

I have a report with a GroupHeader, MasterBand, and a GroupFooter. The GroupFooter has a total that displays on a page break when a name changes.
I need another total for a group before the names changes that is displayed in the report. For example, a person can have different functions. Each function would have its own total. That total would not need a page break.

Do I need to do a subreport? Is there another way to do subtotals.

The report does not have a detailband. Do I need to add one?

My description is general. Let me know if I need to post more info.

Will someone point me to some examples of subtotals and/or subreports? The manual says to look at the example in the demo. I don't know where to get that demo. I should be able to figure it out on my own if I see an example.

Any help is appreciated.

DavidWIII · August 2013

My report currently does a page break on the name and displays total time in the GroupFooter.

GroupHeaderÂ Â  Bruce Wayne
MasterDataÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DateÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ActivityÂ Â Â Â Â Â Â Â Â Â Â Â Â Â  TimeÂ Â Â Â Â Â Â Â Name
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/1/2013Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/5/2013Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/7/2013Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/8/2013Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 30Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/1/2013Â Â Â Â Â Â EatingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/5/2013Â Â Â Â Â Â EatingÂ Â Â Â Â Â Â Â  10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/7/2013Â Â Â Â Â Â SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
GroupFooterÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Total: 110
[page break] 
GroupHeaderÂ Â  Clark KentÂ Â Â Â Â Â Â Â  
MasterDataÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DateÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ActivityÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â TimeÂ Â Â Â Â Â Â Â Name
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/2/2013Â Â Â Â  DrinkingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/6/2013Â Â Â Â  DrinkingÂ Â Â Â Â Â Â Â 15Â Â Â Â Â Â Â Â Â Â Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/1/2013Â Â Â Â  EatingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/5/2013Â Â Â Â  EatingÂ Â Â Â Â Â Â Â 25Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/7/2013Â Â Â Â  SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  7/8/2013Â Â Â Â  SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Clark Kent
GroupFooterÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Total: 70
[page break]

Now I need to also total the Activity when that changes. There will be no page break for that total.

Bruce Wayne
DateÂ Â Â Â Â Â Â Â Â Â Â Â Â Â ActivityÂ Â Â Â Â Â Â Â TimeÂ Â Â Â Â Â Â Â Name
7/1/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
7/5/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
7/7/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
7/8/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  DrinkingÂ Â Â Â Â Â Â Â 30Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Â Â Â Â Â Â Â Â Â Â Â Â  Total:Â Â 70
7/1/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  EatingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
7/5/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â EatingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  10Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Total:Â Â 20
7/7/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  20Â Â Â Â Â Â Â Â Â Â  Bruce Wayne
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Total:Â Â  20
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Total: 110
[page break]
Clark Kent
DateÂ Â Â Â Â Â Â Â Â Â Â Â Â Â ActivityÂ Â Â Â Â Â Â Â Â Â Â Â Â Â TimeÂ Â Â Â Â Â Â Â Name
7/2/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  10Â Â Â Â Â Â Â Â Â Â Clark Kent
7/6/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DrinkingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  15Â Â Â Â Â Â Â Â Â Â Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Total:Â Â 25Â Â Â Â Â Â Â Â Â Â  
7/1/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â EatingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Clark Kent
7/5/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â EatingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  25Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Total:Â Â 35
7/7/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Clark Kent
7/8/2013Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  SleepingÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Clark Kent
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Total:Â Â 20
[page break]Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Total: 70

Do I need a subreport? Is there another way to do a subtotal? Please offer suggestions? Anything that would steer me in the right direction would be helpful?
Thanks

DavidWIII · August 2013

I never got the formatting right in my examples above. I attached images of the report.

The report currently looks like this:

gordk · August 2013

use nested groups
add a second group header set condition to the activity field and set its height to 0 if you dont want to see it.
and a second groupfooter for your subtotal

DavidWIII · August 2013

Yes, nested groups are all I needed. It was simpler than I thought.
Thanks

Subtotals and/or Subreports

Comments

Leave a Comment