UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Using summary/average functions in a report design    
 
   
ldg05
post Nov 7 2005, 04:56 PM
Post #1

New Member
Posts: 1



How can I move the summaries and or averages for different groups in my report? They only seem to calculate correctly while in the header or footer for that specific group. I want some of them to show up on every page of the report, not just in the header or footer for that group. Like a TOTAL ORGANIZATIONAL SUMMARY for all at the top of each page.
Go to the top of the page
 
+
fredrisg
post Nov 7 2005, 05:53 PM
Post #2

UtterAccess VIP
Posts: 1,795
From: LA, CA, USA



One solution is to create a subreport that just calcs the totals and displays them at the top of each page.

The subrpt qry should be similar to the main report qry but a totals qry based on the same critieria.

You could place this subrpt on each page header.

The only issue might be a time hit . . . so another option would be to run the subrpt once and then store the values for printing on each page.

Steve
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 01:47 PM