TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALLAN WHITWORTH
from: LANGLEY MCKELVY
date: 1995-07-03 08:24:00
subject: Report Specs

 On 07-01-95 ALLAN WHITWORTH wrote to LANGLEY MCKELVY... 
  
 AW> Can't you use the same csum / count, etc functions in calculated 
 AW> fields at each group in your report? Your final group, at Grand Total at 
 AW> report's end would be what you're looking for, I believe. 
 
 I don't have difficulty doing my calcs at the end of the report.  My problem 
 occurs when there are multiple group records.  For example:  if I have a 
group  
 of employees that perform certainjob tasks and I want to print monthly 
perform- 
 ance statistics, then give an average against the number of days they 
worked,  
 I can do that quite easily. The problem occurs when I have multiple 
employees  
 in the same result table, because I am unable to count the number of 
iterations  
 for each one within the report spec.  If there was a way to count the number 
 
 of records in each group it would solve my problem I think.  (I know that 
you 
 can GROUP by iteration but I can't find out how to count them on the fly). 
  
 
 
  
 
 
... OFFLINE 1.50 
--- Alexi/Mail 2.02b (#12)
(1:106/4196)
---------------
* Origin: Database Connections BBS * USR DS 16.8 * 713-980-3234 *

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.