Normal Topic [Solved] Report Totals Directly beneath Heading (Read 615 times)
dhopkins
Member
*
Offline



Posts: 47
Joined: Aug 20th, 2007
[Solved] Report Totals Directly beneath Heading
Jan 24th, 2008 at 5:30pm
Print Post Print Post  
I need to print a report with the totals at the top instead of beneath the individual fields. After some thought I think I've figured out how to do it. If anyone has a better idea, feel free to share.

I'll add a second report group to the page, identical to the original group.
On 1 report I change all the body fields to 'hidden' and leave the sum fields normal. This would print the heading and totals only.

Then on the second report, I remove the headers and the clear the footer, leaving the body fields intact.

And the result should look something like this:
      Apples|Oranges|Grapes
Total|3        |1          |2
--------------------------------
Bob |1        |0          |1
Tom|2        |1          |1


D
« Last Edit: Jan 24th, 2008 at 7:23pm by Hammer »  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report Totals Directly beneath Heading
Reply #1 - Jan 24th, 2008 at 6:32pm
Print Post Print Post  
I usually do this with a second view, as opposed to a second group. Which may actually be what you mean from the way you describe it.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
dhopkins
Member
*
Offline



Posts: 47
Joined: Aug 20th, 2007
Re: Report Totals Directly beneath Heading
Reply #2 - Jan 24th, 2008 at 7:12pm
Print Post Print Post  
You're right, once I tried it, I realized that I meant View not Group. And aside from some quirks with column widths, it seems to be working

D
  
Back to top
 
IP Logged